README.rst 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  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 is based on PHPExcel
  7. http://www.phpexcel.net/
  8. Mailing List
  9. ============
  10. Official user list can be found on
  11. http://groups.google.com/group/openpyxl-users
  12. Sample code::
  13. from openpyxl import Workbook
  14. wb = Workbook()
  15. # grab the active worksheet
  16. ws = wb.active
  17. # Data can be assigned directly to cells
  18. ws['A1'] = 42
  19. # Rows can also be appended
  20. ws.append([1, 2, 3])
  21. # Python types will automatically be converted
  22. import datetime
  23. ws['A2'] = datetime.datetime.now()
  24. # Save the file
  25. wb.save("sample.xlsx")
  26. Official documentation
  27. ======================
  28. The documentation is at: http://openpyxl.readthedocs.org
  29. * installation methods
  30. * code examples
  31. * instructions for contributing
  32. Release notes: http://openpyxl.readthedocs.org/en/latest/changes.html