README.rst 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. openpyxl
  2. ========
  3. openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.
  4. It was born from lack of existing library to read/write natively from Python
  5. the Office Open XML format.
  6. All kudos to the PHPExcel team as openpyxl was initially based on PHPExcel.
  7. Mailing List
  8. ============
  9. Official user list can be found on
  10. http://groups.google.com/group/openpyxl-users
  11. Sample code::
  12. from openpyxl import Workbook
  13. wb = Workbook()
  14. # grab the active worksheet
  15. ws = wb.active
  16. # Data can be assigned directly to cells
  17. ws['A1'] = 42
  18. # Rows can also be appended
  19. ws.append([1, 2, 3])
  20. # Python types will automatically be converted
  21. import datetime
  22. ws['A2'] = datetime.datetime.now()
  23. # Save the file
  24. wb.save("sample.xlsx")
  25. Official documentation
  26. ======================
  27. The documentation is at: https://openpyxl.readthedocs.io
  28. * installation methods
  29. * code examples
  30. * instructions for contributing
  31. Release notes: https://openpyxl.readthedocs.io/en/latest/changes.html