Python操作Excel的模块简直不要太多,今天就为大家比较下各模块之间的优缺点。
xlutils & xlrd & xlwt
最原始的莫过于两位老牌黄金搭档xlrd xlwt
了,针对二者的封装有如下模块:
模块 | 官网 |
---|---|
xlutils | https://pypi.org/project/xlutils/ |
xlrd | https://pypi.org/project/xlrd/ |
xlwt | https://pypi.org/project/xlwt/ |
Python操作Excel的模块简直不要太多,今天就为大家比较下各模块之间的优缺点。
最原始的莫过于两位老牌黄金搭档xlrd xlwt
了,针对二者的封装有如下模块:
模块 | 官网 |
---|---|
xlutils | https://pypi.org/project/xlutils/ |
xlrd | https://pypi.org/project/xlrd/ |
xlwt | https://pypi.org/project/xlwt/ |
获取Excel菜单命令的VBA代码:
Sub ShowInfo() '返回菜单命令栏CommandBar的名称 Dim bar As CommandBar Dim i As Integer [a1] = "序号": [b1] = "英文名": [c1] = "中文名" For Each bar In Application.CommandBars With ActiveSheet i = i + 1 .Cells(i + 1, 1) = bar.Index .Cells(i + 1, 2) = bar.Name .Cells(i + 1, 3) = bar.NameLocal End With Next Cells.EntireColumn.AutoFit '自适应列宽 End Sub继续阅读“Office菜单栏中英文对照表”