How to change existing excel files in python

不言
Release: 2018-05-03 13:43:42
Original
1919 people have browsed it

This article mainly introduces the method of changing existing excel files in python. It has certain reference value. Now I share it with you. Friends in need can refer to it

Need Packages used:

import xlrd 
import xlwt 
import xlutils
Copy after login

## Ideas for modifying existing excel files:

First, open the excel file that needs to be changed, use the copy of the xlutils package to copy the excel file object, and then perform the modification operation

Specific code implementation:

import xlrd
import xlwt
from xlutils.copy import copy

# 打开想要更改的excel文件
old_excel = xlrd.open_workbook('fileName.xls', formatting_info=True)
# 将操作文件对象拷贝,变成可写的workbook对象
new_excel = copy(old_excel)
# 获得第一个sheet的对象
ws = new_excel.get_sheet(0)
# 写入数据
ws.write(0, 0, '第一行,第一列')
ws.write(0, 1, '第一行,第二列')
ws.write(0, 2, '第一行,第三列')
ws.write(1, 0, '第二行,第一列')
ws.write(1, 1, '第二行,第二列')
ws.write(1, 2, '第二行,第三列')
# 另存为excel文件,并将文件命名
new_excel.save('new_fileName.xls')
Copy after login

Related recommendations:


Python solves the problem of exceptions thrown when writing Chinese to Excel

Example of python exporting data to excel

Summary of several methods of accessing xls/xlsx files in Python

The above is the detailed content of How to change existing excel files in python. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template