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")

Documentation

The documentation is at: https://openpyxl.readthedocs.io

installation methods
code examples
instructions for contributing

Release notes: https://openpyxl.readthedocs.io/en/stable/changes.html

分类

Development Status :: 5 - Production/Stable License :: OSI Approved :: MIT License Operating System :: MacOS :: MacOS X Operating System :: Microsoft :: Windows Operating System :: POSIX Programming Language :: Python Programming Language :: Python :: 3.10 Programming Language :: Python :: 3.11 Programming Language :: Python :: 3.6 Programming Language :: Python :: 3.7 Programming Language :: Python :: 3.8 Programming Language :: Python :: 3.9

版本列表

3.2.0b1 2022-05-19

3.1.5 2024-06-28

3.1.4 2024-06-12

3.1.3 2024-05-29

3.1.2 2023-03-11

3.1.1 2023-02-13

3.1.0 2023-01-31

3.0.10 2022-05-19

3.0.9 2021-09-22

3.0.7 2021-03-09

3.0.6 2021-01-14

3.0.5 2020-08-21

3.0.4 2020-06-24

3.0.3 2020-01-10

3.0.2 2019-11-25

3.0.1 2019-11-14

3.0.0 2019-09-25

2.6.4 2019-09-25

2.6.3 2019-08-19

2.6.2 2019-03-29

2.6.1 2019-03-04

2.6.0 2019-02-06

2.6.0b1 2019-01-08

2.6.0a1 2018-11-21

2.5.14 2019-01-23

2.5.12 2018-11-29

2.5.11 2018-11-21

2.5.10 2018-11-13

2.5.9 2018-10-19

2.5.8 2018-09-25

2.5.7 2018-09-13

2.5.6 2018-08-30

2.5.5 2018-08-04

2.5.4 2018-06-07

2.5.3 2018-04-18

2.5.2 2018-04-06

2.5.1 2018-03-12

2.5.0 2018-01-24

2.4.11 2018-01-24

2.4.10 2018-01-19

2.4.9 2017-10-19

2.4.8 2017-05-30

2.4.7 2017-04-24

2.4.5 2017-03-07

2.4.4 2017-02-23

2.4.3

2.4.2 2017-01-31

2.4.1 2016-11-23

2.4.0 2016-09-15

2.3.5 2016-04-11

2.3.4 2016-03-16

2.3.3 2016-01-18

2.3.2 2015-12-06

2.3.1 2015-11-20

2.3.0 2015-10-20

2.2.6 2015-09-04

2.2.5 2015-06-29

2.2.4 2015-06-17

2.2.3 2015-05-26

2.2.2 2015-04-28

2.2.1 2015-03-31

2.2.0 2015-03-11

2.1.5 2015-02-18

2.1.4 2014-12-16

2.1.3 2014-12-09

2.1.2 2014-10-23

2.1.1 2014-10-08

2.1.0 2014-09-21

2.0.5 2014-08-08

2.0.4 2014-06-25

2.0.3 2014-05-22

2.0.2 2014-05-13

1.8.6 2014-05-05

1.8.5 2014-03-25

1.8.4 2014-02-25

1.8.3 2014-02-09

1.8.2 2014-01-21

1.8.1 2014-01-14

1.8.0 2014-01-08

1.7.0 2013-11-17

1.6.2 2013-04-18

1.6.1 2012-10-28

1.5.8 2012-03-03

1.5.7 2012-01-22

1.5.6 2011-10-31

1.5.5 2011-10-11

1.5.4 2011-09-05

1.5.3 2011-09-05

1.5.2 2011-04-07

1.5.1 2011-04-07

1.5.0 2011-03-15

1.2.3 2010-12-07

1.1.7 2010-09-11

1.1.6 2010-09-10

1.1.5 2010-09-03

1.1.0 2010-08-11