sheetparser: the Excel scraper

sheetparser is a library for extracting information from Excel sheets (as well as csv and pdf) that contain complex or variable layouts of tables.

Obtaining data from various sources can be very painful, and loading Excel sheets that were designed by humans for humans is especially difficult. The focus of the persons who create those sheet is first to display the information in a way that pleases their eyes or can convince others, and readability by a computer is low on the list of priorities. Also as time goes, they add intermediate lines or columns, or add more information. The systematic loading of historical information can then become a very heavy task.

The purpose of this package is to simplify the data extraction of those tables. Complex and flexible layouts can be implemented in a few lines.

Contents:

• Introduction to sheetparser
  • Another example
  • PDF Files
• Patterns
  • Some definitions
  • Workbook
  • Ranges
  • Iterators of lines
  • Stop tests
• Line and table transformations
  • Line transformations
  • Table transformations
• Results
• Documents and backends

Indices and tables

• Index
• Module Index
• Search Page