paper-xlsxAPI referencereader.excel
WorksheetReader
paper-xlsx 0.2.1 API reference
Create a parser and apply it to a workbook
WorksheetReader(ws, xml_source, shared_strings, data_only, rich_text, *, warn_extensions=True)Attributes
parser
attributeparser= WorkSheetParser(xml_source, shared_strings, data_only, ws.parent.epoch, ws.parent._date_formats, ws.parent._timedelta_formats, rich_text, warn_extensions=warn_extensions)tables
attributetables= []ws
attributews= wsFunctions
bind_all
funcbind_all()bind_cells
funcbind_cells()bind_col_dimensions
funcbind_col_dimensions()bind_formatting
funcbind_formatting()bind_hyperlinks
funcbind_hyperlinks()bind_merged_cells
funcbind_merged_cells()bind_properties
funcbind_properties()bind_row_dimensions
funcbind_row_dimensions()bind_tables
funcbind_tables()normalize_merged_cell_link
funcnormalize_merged_cell_link(coord)Returns the appropriate cell to which a hyperlink, which references a merged cell at the specified coordinates, should be bound.
paramcoord