pyexcel
Introduction
Data models and data structures
Data source
Data format
Data transformation
Data manipulations
Signature functions
Import data into Python
Four data access functions
Two native functions
Export data from Python
Data transportation/transcoding
Sheet: Data Access
Random access to individual cell
Random access to rows and columns
Use custom names instead of index
Reading a single sheet excel file
Read the sheet as a dictionary
Can I get an array of dictionaries per each row?
Writing a single sheet excel file
Write multiple sheet excel file
Read multiple sheet excel file
Sheet: Data manipulation
Column manipulation
Remove one column of a data file
Append more columns to a data file
Cherry pick some columns to be removed
What if the headers are in a different row
Row manipulation
Sheet: Data filtering
Work with data series in a single sheet
Read an excel file
Play with data
Filter out some data
Save the data
Work with multi-sheet file
How do I read a book, pocess it and save to a new book
What would happen if I save a multi sheet book into “csv” file
After I have saved my multiple sheet book in csv format, how do I get them back in pyexcel
Sheet: Data conversion
How to obtain records from an excel sheet
How to get an array from an excel sheet
How to save an python array as an excel file
How to get a dictionary from an excel sheet
How to obtain a dictionary from a multiple sheet book
How to save a dictionary of two dimensional array as an excel file
How to an excel sheet to a database using SQLAlchemy
How to open an xls file and save it as csv
How to open an xls file and save it as xlsx
How to open a xls multiple sheet excel book and save it as csv
Sheet: Formatting
Convert a column of numbers to strings
Cleanse the cells in a spread sheet
Book: Sheet operations
Merge excel books
Manipulate individual sheets
merge sheets into a single sheet
Work with excel files
Add a new row to an existing file
Update an exiting row to an existing file
Add a new column to an existing file
Update an existing column to an existing file
Work with excel files in memory
Read any supported excel and respond its content in json
Write to memory and respond to download
Recipies
Update one column of a data file
Update one row of a data file
Merge two files into one
Select candidate columns of two files and form a new one
Merge two files into a book where each file become a sheet
Merge all excel files in directory into a book where each file become a sheet
Split a book into single sheet files
Extract just one sheet from a book
Loading from other sources
How to load a sheet from a url
Questions and Answers
API Reference
Signature functions
Obtaining data from excel file
pyexcel.get_array
pyexcel.get_dict
pyexcel.get_records
pyexcel.get_book_dict
Saving data to excel file
Cookbook
Book
Constructor
Attribute
Conversions
Save changes
Sheet
Constructor
Save changes
Attributes
pyexcel.Sheet.row
pyexcel.Sheet.column
Iteration
Cell access
Row access
Column access
Data series
Any column as row name
Any row as column name
Formatting
Filtering
Conversion
Anti-conversion
Transformation
Row access
Column access
Data formatters
pyexcel.formatters.ColumnFormatter
pyexcel.formatters.NamedColumnFormatter
pyexcel.formatters.RowFormatter
pyexcel.formatters.NamedRowFormatter
pyexcel.formatters.SheetFormatter
Data Filters
pyexcel.filters.ColumnFilter
pyexcel.filters.SingleColumnFilter
pyexcel.filters.OddColumnFilter
pyexcel.filters.EvenColumnFilter
pyexcel.filters.RowFilter
pyexcel.filters.SingleRowFilter
pyexcel.filters.OddRowFilter
pyexcel.filters.EvenRowFilter
pyexcel.filters.RegionFilter
Internal API reference
Data sheet representation
Row represetation
Column represetation
Developer’s guide
Acceptance criteria
How to test your contribution
pyexcel
Docs
»
Internal API reference
Edit on GitHub
Internal API reference
¶
This is intended for developers and hackers of pyexcel.
Data sheet representation
¶
In inheritance order from parent to child
Row represetation
¶
Column represetation
¶
Read the Docs
v: v0.1.7
Versions
latest
stable
v0.1.7
v0.1.6
v0.1.5
v0.1.4
v0.1.3
v0.1.2
v0.1.1
v0.0.10
v0.0.9
v0.0.8-rc4
v0.0.7-rc3
v0.0.6-rc2
v0.0.5-rc1
v0.0.4-beta3
v0.0.3-beta2
v0.0.2-beta
v0.0.1-alpha
Downloads
On Read the Docs
Project Home
Builds
Free document hosting provided by
Read the Docs
.