python excel库 linux_嵌入式linux Python-excel表格操作

Xlsx是python用来构造xlsx文件的模块，可以向excel2007+中写text，numbers，formulas 公式以及hyperlinks超链接。可以完成xlsx文件的自动化构造，包括：合并单元格，制作excel图表等功能：

1，Introduction:xlsxWriter支持多种excle功能；与excel完美兼容；写大文件，速度快且只占用很小的内存空间不支持读或者改现有的excel文件2， Installing:sudo pip install XlsxWriter;sudo easy_install XlsxWriter;或者源码安装：http://github.com/jmcnamara/XlsxWriter/archive/master.tar.gz3，使用：importxlsxwriter

workbook= xlsxwriter.Workbook('hello.xlsx') # 建立文件

worksheet=workbook.add_worksheet() # 建立sheet， 可以work.add_worksheet('employee')来指定sheet名，但中文名会报UnicodeDecodeErro的错误

worksheet.write('A1', 'Hello world') # 向A1写入

workbook.close()excel公式计算1234567891011121314151617181920212223# Some data we want to write to the worksheet.expenses= (['Rent',1000],['Gas',100],['Food',300],['Gym',50],) # Start from the first cell. Rows and columns are zero indexed. 按标号写入是从0开始的，按绝对位置'A1'写入是从1开始的row= 0col= 0 # Iterate over the data and write it out row by row.for item, costin (expenses):worksheet.write(row, col,     item)worksheet.write(row, col+ 1, cost)row+= 1 # Write a total using a formula.worksheet.write(row,0,'Total')worksheet.write(row,1,'=SUM(B1:B4)')# 调用excel的公式表达式 workbook.close()excel自定义格式：importxlsxwriter#建文件及sheet.

workbook = xlsxwriter.Workbook('Expenses02.xlsx')

worksheet=workbook.add_worksheet()#Add a bold format to use to highlight cells. 设置粗体，默认是False

bold = workbook.add_format({'bold': True})#Add a number format for cells with money. 定义数字格式

money = workbook.add_format({'num_format': '$#,##0'})#Write some data headers. 带自定义粗体blod格式写表头

worksheet.write('A1', 'Item', bold)

worksheet.write('B1', 'Cost', bold)#Some data we want to write to the worksheet.

expenses =(

['Rent', 1000],

['Gas', 100],

['Food', 300],

['Gym', 50],

)#Start from the first cell below the headers.

row = 1col=0#Iterate over the data and write it out row by row.

for item, cost in(expenses):

worksheet.write(row, col, item) # 带默认格式写入

worksheet.write(row, col+ 1, cost, money) # 带自定义money格式写入

row+= 1

#Write a total using a formula.

worksheet.write(row, 0, 'Total', bold)

worksheet.write(row,1, '=SUM(B2:B5)', money)

workbook.close() excel写入时间格式 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950from datetimeimport datetimeimport xlsxwriter # Create a workbook and add a worksheet.workbook= xlsxwriter.Workbook('Expenses03.xlsx')worksheet= workbook.add_worksheet() # Add a bold format to use to highlight cells.bold= workbook.add_format({'bold':1}) # Add a number format for cells with money.money_format= workbook.add_format({'num_format':'$#,##0'}) # Add an Excel date format.date_format= workbook.add_format({'num_format':'mmmm d yyyy'}) # Adjust the column width.worksheet.set_column(1,1,15) # Write some data headers.worksheet.write('A1','Item', bold)worksheet.write('B1','Date', bold)worksheet.write('C1','Cost', bold) # Some data we want to write to the worksheet.expenses= (['Rent','2013-01-13',1000],['Gas','2013-01-14',100],['Food','2013-01-16',300],['Gym','2013-01-20',50],) # Start from the first cell below the headers.row= 1col

登录 后发表评论

0条评论

还没有人评论过~