Detailed explanation of how to read and write Excel using Python-Python Tutorial-php.cn

Detailed explanation of how to read and write Excel using Python

高洛峰

Release： 2017-03-31 10:09:16

Original

1575 people have browsed it

In the process of learning Python, we will encounter problems with reading and writing Excel. At this time, we can use the xlwt module to write data into the Excel table and the xlrd module to read data from Excel. Below we introduce how to use Python to read and write Excel.

Python version: 3.5.2

Install xlwt and xlrd modules through pip, if not installed:

pip install xlwt

pip install xlrd

1. Write the Excel file:

# -*- conding:utf-8 -*-
__author__ = &#39;mayi&#39;
#How to write to an Excel using xlwt module
import xlwt
#创建一个Wordbook对象，相当于创建了一个Excel文件
book = xlwt.Workbook(encoding = "utf-8", style_compression = 0)
#创建一个sheet对象，一个sheet对象对应Excel文件中的一张表格
sheet = book.add_sheet("sheet1", cell_overwrite_ok = True)
#向表sheet1中添加数据
sheet.write(0, 0, "EnglishName")  #其中，"0, 0"指定表中的单元格，"EnglishName"是向该单元格中写入的内容
sheet.write(1, 0, "MaYi")
sheet.write(0, 1, "中文名字")
sheet.write(1, 1, "蚂蚁")
#最后，将以上操作保存到指定的Excel文件中
book.save("name.xls")

Copy after login

2. Read the Excel file:

# -*- conding:utf-8 -*-
__author__ = &#39;mayi&#39;
# How to read from an Excel using xlrd module
import xlrd
# 打开指定路径中的xls文件，得到book对象
xls_file = "name.xls"
#打开指定文件
book = xlrd.open_workbook(xls_file)
# 通过sheet索引获得sheet对象
sheet1 = book.sheet_by_index(0)
# # 获得指定索引的sheet名
# sheet1_name = book.sheet_names()[0]
# print(sheet1_name)
# # 通过sheet名字获得sheet对象
# sheet1 = book.sheet_by_name(sheet1_name)

# 获得行数和列数
# 总行数
nrows = sheet1.nrows
#总列数
ncols = sheet1.ncols
# 遍历打印表中的内容
for i in range(nrows):
    for j in range(ncols):
        cell_value = sheet1.cell_value(i, j)
        print(cell_value, end = "\t")
    print("")

Copy after login

The above is the detailed content of Detailed explanation of how to read and write Excel using Python. For more information, please follow other related articles on the PHP Chinese website!