xlsx to amx dict list
Project description
exceltoamx
import excel spreadsheet to list of amx dicts.
This is NOT a generic Excel importer. It's specific to campus AMX systems.
Each amx system is represented by a dictionary populated by the excel columns. These dictionaries are then put into a single list and returned.
Required columns: building_name, room_number, master_ip
Columns handled here but not required: system_number, space_use_code, tp_generation
Any additional columns are allowed. They will be converted to dict k,v pairs
Requires tablib. Dictionary keys are populated from the top row of data in the .xlsx file. Each additional row is turned into a dictionary with the values from that row. Then all of the rows/dictionaries are put into a list and returned. We could also return the xlsx dataset, but there's no current use for it so I left that commented out. :param path: path to .xlsx file :return: list of dictionaries
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for exceltoamx-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dadd02073b7ab2ee434c03307fb255cf4c7da81bd1598838960dc7112d52f38c |
|
MD5 | b793185780a0f07c408815f11b40ff13 |
|
BLAKE2b-256 | c20f3c98d5b0f3628a9000da9eb0cee892e2eda18d1f1eaa048d1965345aa9c0 |