在Python中使用win32.com取消隐藏分组的列

pip install pywin32

import win32com.client

excel = win32com.client.Dispatch("Excel.Application")

workbook = excel.Workbooks.Open("path/to/your/file.xlsx")

worksheet = workbook.Worksheets("Sheet1")

group_range = worksheet.Range("A:C")  # 以A列到C列为例

group_range.Rows.ShowDetail = True

workbook.Save()
workbook.Close()

import win32com.client

excel = win32com.client.Dispatch("Excel.Application")
workbook = excel.Workbooks.Open("path/to/your/file.xlsx")
worksheet = workbook.Worksheets("Sheet1")
group_range = worksheet.Range("A:C")
group_range.Rows.ShowDetail = True
workbook.Save()
workbook.Close()