A packge to quickly split an Excel report into multiple sheets or multiple reports based on unique column values.
Project description
Excel Splitter
This is a package which will allow you to quickly split a single Excel sheet into either separate tabs of the same report or into different Excel reports.
IMPORTANT: Your sheet must contain a header row to function properly!
Once installed, you can call the split_sheet() function which contains the following parameters:
split_sheet(split_type, input_report_path, column_number_to_split_by)
ACCEPTED PARAMETER VALUES:
split_type = "separate_files" or "split_tabs" input_report_path = the path to the report to be split column_number_to_split_by = the # of the Excel column to split by (A = 1, B = 2, C =3, etc.)
EXAMPLE OF SPLITTING AN EXCEL SHEET BY UNIQUE VALUES IN COLUMN B INTO DIFFERENT REPORTS
split_sheet(split_type='separate_files, input_report_path='PATH_TO_REPORT.xlsx', column_number_to_split_by=2)
KNOWN ISSUE:
The current version of this script does not support transfer of formulas!!
Project details
Release history Release notifications | RSS feed
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 Split_Excel_Package-0.0.8.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 58bece530053f8c21123966b22a4252d35f3ea3b4583837a8a3319b18cb210bc |
|
MD5 | e25a7486f9a2a69b369c0094847ef2b1 |
|
BLAKE2b-256 | 0c92863afeafdfbfa9fe56e7251982f05f2a0509fb7b4feba28ae61656832325 |
Hashes for Split_Excel_Package-0.0.8-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c7ef445fabcb05b2e7b595e516d568e49aaf0c1e73c8d28158217a40585874c5 |
|
MD5 | cd7b991a8ef4c1aee927cc4faced9879 |
|
BLAKE2b-256 | c4f6267065c3835e9f0ffe9da1fd49e0ce0b5542e5d3ce18d2947c093ac6988e |