py- xlwings

# -*- coding:utf-8 -*-

import os
import numpy as np
import pandas as pd
from xlwings import Book

class wb(Book):  # 继承
	def __init__(self, filename=None, impl=None):
		Book.__init__(self, filename, impl)
		# super(Book, self).__init__(*args, **kwargs)  # 新式类

def my_macro(sht_name):
	sht = wb.caller().sheets[sht_name]  
	# sht.clear_contents()  # 保留格式清除  sht.clear
	sht.clear()  # 全部清除
	sht.autofit(axis=None)  # 自动调整行高列宽，axis='r'(行), 'c'(列)
	print('引用范围字符串值', sht[1, 1].address)  # '$B$2'
	sht[2, 5].expand('table').clear_contents()  
	sht[2, 5].options(expand='table').value = np.ones((5, 5))  # 区域赋值
	rng = sht[2, 5].current_region  # sht[2,5]所在整个区域,只到遇到空行空列
	# print('row:', rng.rows.count, rng.columns.count)  # 行列单元格数
	print('end:'