用python怎么只读取excel 可见单元格 可见行怎么表示 可见列

Question

 excel会有hidden 筛选和隐藏 怎么让python只读确可见单元格呢 谢谢

Answer 1

可使用如下代码试试：

from openpyxl import load_workbook
import pandas as pd

wb = load_workbook(r'Data.xlsx') 
ws = wb['Sheet1']
data = []

for row in ws: 
    if ws.row_dimensions[row[0].row].hidden == False:
      row_values = [cell.value for cell in row]
      data.append(row_values)

df = pd.DataFrame(data[1:], columns=data[0])

print(df)

如有帮助，请采纳。