openpyxl
- A Python library to read/write Excel 2010 xlsx/xlsm files
这里使用了 openpyxl 库
from openpyxl import Workbook
from openpyxl import load_workbook
import os;
owb = Workbook() #输出wb
ows = owb.active #获取活动表
ows.title = "sheet" #命名表
wb1 = load_workbook('附件1 相关的要素名称及位置坐标数据.xlsx') #读入1
s_name1 = wb1.get_sheet_names() #得到输入表名数组
ws1 = wb1.get_sheet_by_name(s_name1[0]) #得到读入book1的第一张表
print ('sheet_name:%s'% s_name1[0])
f=open("aera.txt","w")
for i in range(1,116):
for j in range(1,7):
f.write("{0} {1}".format( ws1.cell(row=i, column=j).value,' '))
f.write('\n')
f.close()
openpyxl 官方文档: https://openpyxl.readthedocs.io/en/stable/