Can python handle excel?

Python mainly uses third-party module libraries xlrd, xlwt, xluntils, pyExcelerator and Pandas to process excel file data.

1, xlrd

xlrd is used to read and write data from Excel, but I usually only use it to read Operations and write operations will encounter some problems. It is more convenient to use xlrd to read. The process is the same as the usual manual operation of Excel. Open the workbook (Workbook), select the worksheet (sheets), and then operate the cell (cell).

import xlrd
data = xlrd.open_workbook('text.xls','rb')
print('工作表名为：'+ data.sheet_names()[0])
table = data.sheets()[0]
nrows = table.nrows
ncols = table.ncols
print('表格行数为%d,列数为%d'%(nrows,ncols))
#输出每一行的值
for item in range(table.nrows):
    print(table.row_values(item))
#获取单元格的值
cell_A1 = table.row(0)[0].value
cell_A2 = table.cell(0,0).value
cell_A3 = table.col(0)[0].value
print(cell_A1)
print(cell_A2)
print(cell_A3)

2, xlwt

If xlrd is not a simple Reader (if the last two characters in xlrd are regarded as Reader, then the last two characters of xlwt Similar to a Writer), then xlwt is a pure Writer, because it can only write to Excel. Not only do xlwt and xlrd have similar names, but many of their functions and operation formats are exactly the same. Below is a brief summary of common operations

import xlwt
data = xlwt.Workbook()
#新建工作表,可对同一个单元格重复操作
table = data.add_sheet('hello', cell_overwrite_ok=True)
#写入数据到A1单元格
table.write(0,0,'hello world')
#保存文件,不支持xlsx格式
data.save('test2.xls')
#初始化样式
style = xlwt.XFStyle()
#创建字体
font = xlwt.Font()
#指定字体名字
font.name = 'Times New Roman'
#字体加粗
font.bold = True
#将该font设定为style的字体
style.font = font
#写入到文件时使用该样式
table.write(0,1,'ni hao', style)
#修改完要再一次保存
data.save('test2.xls')

The above is the detailed content of Can python handle excel?. For more information, please follow other related articles on the PHP Chinese website!