import openpyxl from openpyxl.utils import get_column_letter wb = openpyxl.load_workbook("style.xlsx") sheets = wb.worksheets for st in sheets: fileName = str(st)[12:-2]+".txt" fp = open(fileName, 'w') for rows in range(1, st.max_row+1): for col in range(1, st.max_column+1): content = st[get_column_letter(col)+str(rows)].value if content == None: continue else: fp.write("%s %s" % (content, "\t")) fp.write("\r") fp.close() wb.close() print("========Done!=========")
第12章 将Excel内容写入文本
最新推荐文章于 2020-08-08 05:10:11 发布