posted @ 2018-11-26 16:44
oohy
阅读(1)
推荐(0)
编辑
摘要:
import xlwt Excel = xlwt.Workbook(encoding='utf-8', style_compression=0) table = Excel.add_sheet('hello',cell_overwrite_ok=True) #sheet名命名为hello table.write(1,2,"hello")#第一行第二列写入hello(row,col,data)...
阅读全文
posted @ 2018-11-26 11:15
oohy
阅读(3207)
推荐(0)
编辑
摘要:
import codecs import pandas as pd xd = pd.ExcelFile('XXX.xls') pd.set_option('display.max_colwidth',1000)#设置列的宽度,以防止出现省略号 df = xd.parse() with codecs.open('XX.html','w') as html_file: html_file.w...
阅读全文
posted @ 2018-11-26 11:03
oohy
阅读(6631)
推荐(0)
编辑