Python读写Excel 2007文件（xlsx）

最新推荐文章于 2024-02-23 20:22:12 发布

BIT工匠

最新推荐文章于 2024-02-23 20:22:12 发布

阅读量4.2k

点赞数

本文链接：https://blog.csdn.net/jollypigclub/article/details/46696315

版权

openpyxl是一个用于读写Excel 2010 xlsx/xlsm/xltx/xltm文件的Python库。它支持创建、修改工作簿、单元格数据、样式、图表、条件格式等。此外，提供了安装、使用教程和API文档，鼓励用户通过fork和pull request进行贡献。

摘要由CSDN通过智能技术生成

A Python library to read/write Excel 2007 xlsx/xlsm files

http://openpyxl.readthedocs.org/en/latest/

`openpyxl` - A Python library to read/write Excel 2007 xlsx/xlsm files

Author:	Eric Gazoni
Source code:	http://bitbucket.org/openpyxl/openpyxl/src
Issues:	http://bitbucket.org/openpyxl/openpyxl/issues
Generated:	June 30, 2015
License:	MIT/Expat
Version:	2.2.4

Introduction

Openpyxl is a Python library for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files.

It was born from lack of existing library to read/write natively from Python the Office Open XML format.

All kudos to the PHPExcel team as openpyxl was initially based on PHPExcelhttp://www.phpexcel.net/

Sample code:

 
      from openpyxl import Workbook
wb = Workbook()

# grab the active worksheet
ws = wb.active

# Data can be assigned directly to cells
ws['A1'] = 42

# Rows can also be appended
ws.append([1, 2, 3])

# Python types will automatically be converted
import datetime
ws['A2'] = datetime.datetime.now()

# Save the file
wb.save("sample.xlsx")
 
     

User List

Official user list can be found on http://groups.google.com/group/openpyxl-users

How to Contribute Code

Any help will be greatly appreciated, just follow those steps:

1. Please start a new fork (https://bitbucket.org/openpyxl/openpyxl/fork) for each independent feature, don’t try to fix all problems at the same time, it’s easier for those who will