| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- .. image:: https://coveralls.io/repos/bitbucket/openpyxl/openpyxl/badge.svg?branch=default
- :target: https://coveralls.io/bitbucket/openpyxl/openpyxl?branch=default
- :alt: coverage status
- Introduction
- ------------
- openpyxl is a Python library to read/write 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 PHPExcel.
- Security
- --------
- By default openpyxl does not guard against quadratic blowup or billion laughs
- xml attacks. To guard against these attacks install defusedxml.
- Mailing List
- ------------
- The user list can be found on http://groups.google.com/group/openpyxl-users
- 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")
- 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
|
