Release 1.7 - Read the Docs

openpyxl Documentation

Release 1.7.0 Eric Gazoni

December 31, 2013

Contents

1 Introduction

3

2 User List

5

3 How to Contribute Code

7

4 Other ways to help

9

5 Installation

11

6 Getting the source

13

7 Usage examples

15

7.1 Tutorial . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

7.2 Cookbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

7.3 Read/write large files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21

8 API Documentation

23

8.1 Module openpyxl.workbook ? Workbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23

8.2 Module openpyxl.worksheet ? Worksheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24

8.3 Module openpyxl.reader.iter_worksheet ? Optimized reader . . . . . . . . . . . . . . . 26

8.4 Module openpyxl.cell ? Worksheet Cell . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

8.5 Module openpyxl.reader.excel ? Filesystem reader . . . . . . . . . . . . . . . . . . . . . . 28

8.6 Module openpyxl.writer.dump_worksheet ? Optimized writer . . . . . . . . . . . . . . . 28

8.7 Module openpyxl.datavalidation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28

9 Indices and tables

31

Python Module Index

33

i

ii

openpyxl Documentation, Release 1.7.0

Author Eric Gazoni Source code Issues Generated November 13, 2013 License MIT/Expat Version 1.7.0

Contents

1

openpyxl Documentation, Release 1.7.0

2

Contents

CHAPTER 1

Introduction

OpenPyxl is a Python library to read/write Excel 2007 xlsx/xlsm files. It was born from lack of existing library to read/write natively from Python the new Open Office XML format. All kudos to the PHPExcel team as openpyxl is a Python port of PHPExcel

3

openpyxl Documentation, Release 1.7.0

4

Chapter 1. Introduction

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download