METADATA 2.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586
  1. Metadata-Version: 2.1
  2. Name: openpyxl
  3. Version: 3.1.5
  4. Summary: A Python library to read/write Excel 2010 xlsx/xlsm files
  5. Home-page: https://openpyxl.readthedocs.io
  6. Author: See AUTHORS
  7. Author-email: charlie.clark@clark-consulting.eu
  8. License: MIT
  9. Project-URL: Documentation, https://openpyxl.readthedocs.io/en/stable/
  10. Project-URL: Source, https://foss.heptapod.net/openpyxl/openpyxl
  11. Project-URL: Tracker, https://foss.heptapod.net/openpyxl/openpyxl/-/issues
  12. Classifier: Development Status :: 5 - Production/Stable
  13. Classifier: Operating System :: MacOS :: MacOS X
  14. Classifier: Operating System :: Microsoft :: Windows
  15. Classifier: Operating System :: POSIX
  16. Classifier: License :: OSI Approved :: MIT License
  17. Classifier: Programming Language :: Python
  18. Classifier: Programming Language :: Python :: 3.6
  19. Classifier: Programming Language :: Python :: 3.7
  20. Classifier: Programming Language :: Python :: 3.8
  21. Classifier: Programming Language :: Python :: 3.9
  22. Classifier: Programming Language :: Python :: 3.10
  23. Classifier: Programming Language :: Python :: 3.11
  24. Requires-Python: >=3.8
  25. License-File: LICENCE.rst
  26. Requires-Dist: et-xmlfile
  27. .. image:: https://coveralls.io/repos/bitbucket/openpyxl/openpyxl/badge.svg?branch=default
  28. :target: https://coveralls.io/bitbucket/openpyxl/openpyxl?branch=default
  29. :alt: coverage status
  30. Introduction
  31. ------------
  32. openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.
  33. It was born from lack of existing library to read/write natively from Python
  34. the Office Open XML format.
  35. All kudos to the PHPExcel team as openpyxl was initially based on PHPExcel.
  36. Security
  37. --------
  38. By default openpyxl does not guard against quadratic blowup or billion laughs
  39. xml attacks. To guard against these attacks install defusedxml.
  40. Mailing List
  41. ------------
  42. The user list can be found on http://groups.google.com/group/openpyxl-users
  43. Sample code::
  44. from openpyxl import Workbook
  45. wb = Workbook()
  46. # grab the active worksheet
  47. ws = wb.active
  48. # Data can be assigned directly to cells
  49. ws['A1'] = 42
  50. # Rows can also be appended
  51. ws.append([1, 2, 3])
  52. # Python types will automatically be converted
  53. import datetime
  54. ws['A2'] = datetime.datetime.now()
  55. # Save the file
  56. wb.save("sample.xlsx")
  57. Documentation
  58. -------------
  59. The documentation is at: https://openpyxl.readthedocs.io
  60. * installation methods
  61. * code examples
  62. * instructions for contributing
  63. Release notes: https://openpyxl.readthedocs.io/en/stable/changes.html