virtual_warehouse.data.excel_parser
Parser of Excel data files.
Classes
Document(file_path)
|
Document class which loads xls or xlsx file and parse different data objects. |
-
class Document(file_path)[source]
Bases: object
Document class which loads xls or xlsx file and parse different data objects.
-
static check_xlsx(file_path)[source]
Check if document is .xlsx document (required for openpyxl library).
-
close()[source]
Release resources owned by the document.
-
static get_sheet_names(file_path)[source]
Get names of all sheets in document.
-
parse_coordinates(sheet_name='XYZ_coordinates')[source]
Parse XYZ_coordinates sheet.
-
parse_document()[source]
Parse the whole document.
-
parse_inventory_balance(sheet_name='Inventory Ballance')[source]
Parse Inventory Balance sheet (‘balance’ in final version, most likely).
-
parse_items(sheet_name='ITEMmaster')[source]
Parse ITEMmaster sheet.
-
parse_locations(sheet_name='LOCATIONmaster')[source]
Parse LOCATIONmaster sheet.
-
parse_orders(sheet_name='Order')[source]
Parse Order sheet.