openpyxl - A Python library to read/write Excel 2007 xlsx/xlsm files

Author:Eric Gazoni Source code:http://bitbucket.org/ericgazoni/openpyxl/src Issues:http://bitbucket.org/ericgazoni/openpyxl/issues Generated:January 26, 2012 License:MIT/Expat Version:1.5.7

Usage examples

Tutorial

• Manipulating a workbook in memory
  • Create a workbook
  • Playing with data
    • Accessing one cell
    • Accessing many cells
    • Data storage
• Saving to a file
• Loading from a file

Cookbook

• Simple usage
  • Write a workbook
  • Read an existing workbook
  • Using number formats

Read/write large files

• Optimized reader
• Optimized writer

API Documentation

• Module openpyxl.workbook – Workbook
• Module openpyxl.worksheet – Worksheet
• Module openpyxl.reader.iter_worksheet – Optimized reader
• Module openpyxl.cell – Worksheet Cell
• Module openpyxl.reader.excel – Filesystem reader
• Module openpyxl.writer.dump_worksheet – Optimized writer

Indices and tables

• Index
• Module Index
• Search Page