加载中…Python获取Excel表有数据的所有行数和列数
(2021-02-18 20:47:20)used_range
Used Range of Sheet.
Returns:
Return type: xw.Range
last_cell
Returns the bottom right cell of the specified range.
Read-only.
Returns:
Return type: Range
import xlwings as xw
wb = xw.Book(r'F:\xlwings\OriginalData.xlsx')
sht = wb.sheets[0]
info = sht.used_range
nrows = info.last_cell.row
print(nrows)
ncolumns = info.last_cell.column
print(ncolumns)
参见：https://blog.csdn.net/qq_31989047/article/details/103318044
喜欢
0
赠金笔