METADATA 2.5 KB

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