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!

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于Seaborn的相关问题,包括了数据可视化处理的散点图、折线图、条形图等等内容,下面一起来看一下,希望对大家有帮助。

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于进程池与进程锁的相关问题,包括进程池的创建模块,进程池函数等等内容,下面一起来看一下,希望对大家有帮助。

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于简历筛选的相关问题,包括了定义 ReadDoc 类用以读取 word 文件以及定义 search_word 函数用以筛选的相关内容,下面一起来看一下,希望对大家有帮助。

VS Code的确是一款非常热门、有强大用户基础的一款开发工具。本文给大家介绍一下10款高效、好用的插件,能够让原本单薄的VS Code如虎添翼,开发效率顿时提升到一个新的阶段。

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于数据类型之字符串、数字的相关问题,下面一起来看一下,希望对大家有帮助。

pythn的中文意思是巨蟒、蟒蛇。1989年圣诞节期间,Guido van Rossum在家闲的没事干,为了跟朋友庆祝圣诞节,决定发明一种全新的脚本语言。他很喜欢一个肥皂剧叫Monty Python,所以便把这门语言叫做python。

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于numpy模块的相关问题,Numpy是Numerical Python extensions的缩写,字面意思是Python数值计算扩展,下面一起来看一下,希望对大家有帮助。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

Dreamweaver Mac version
Visual web development tools

Notepad++7.3.1
Easy-to-use and free code editor

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
