| Name | Split-Excel-Package JSON |
| Version |
0.0.8
JSON |
| download |
| home_page | |
| Summary | A packge to quickly split an Excel report into multiple sheets or multiple reports based on unique column values. |
| upload_time | 2023-07-04 07:13:50 |
| maintainer | |
| docs_url | None |
| author | |
| requires_python | >=3.7 |
| license | |
| keywords |
excel
split
opensource
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# 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!!
Raw data
{
"_id": null,
"home_page": "",
"name": "Split-Excel-Package",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": "",
"keywords": "Excel,Split,opensource",
"author": "",
"author_email": "Jason Yearry <jasonyearry@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/0c/92/863afeafdfbfa9fe56e7251982f05f2a0509fb7b4feba28ae61656832325/Split_Excel_Package-0.0.8.tar.gz",
"platform": null,
"description": "# Excel Splitter\r\n\r\nThis 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.\r\n\r\nIMPORTANT: Your sheet must contain a header row to function properly!\r\n\r\nOnce installed, you can call the split_sheet() function which contains the following parameters: \r\n\r\nsplit_sheet(split_type, input_report_path, column_number_to_split_by)\r\n\r\nACCEPTED PARAMETER VALUES:\r\n\r\nsplit_type = \"separate_files\" or \"split_tabs\"\r\ninput_report_path = the path to the report to be split\r\ncolumn_number_to_split_by = the # of the Excel column to split by (A = 1, B = 2, C =3, etc.)\r\n\r\nEXAMPLE OF SPLITTING AN EXCEL SHEET BY UNIQUE VALUES IN COLUMN B INTO DIFFERENT REPORTS\r\n\r\nsplit_sheet(split_type='separate_files, input_report_path='PATH_TO_REPORT.xlsx', column_number_to_split_by=2)\r\n\r\nKNOWN ISSUE: \r\n\r\nThe current version of this script does not support transfer of formulas!!\r\n",
"bugtrack_url": null,
"license": "",
"summary": "A packge to quickly split an Excel report into multiple sheets or multiple reports based on unique column values.",
"version": "0.0.8",
"project_urls": {
"Homepage": "https://github.com/Guitarman-Waiting-In-The-Sky/excel_splitter"
},
"split_keywords": [
"excel",
"split",
"opensource"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c4f6267065c3835e9f0ffe9da1fd49e0ce0b5542e5d3ce18d2947c093ac6988e",
"md5": "cd7b991a8ef4c1aee927cc4faced9879",
"sha256": "c7ef445fabcb05b2e7b595e516d568e49aaf0c1e73c8d28158217a40585874c5"
},
"downloads": -1,
"filename": "Split_Excel_Package-0.0.8-py3-none-any.whl",
"has_sig": false,
"md5_digest": "cd7b991a8ef4c1aee927cc4faced9879",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 4349,
"upload_time": "2023-07-04T07:13:48",
"upload_time_iso_8601": "2023-07-04T07:13:48.796561Z",
"url": "https://files.pythonhosted.org/packages/c4/f6/267065c3835e9f0ffe9da1fd49e0ce0b5542e5d3ce18d2947c093ac6988e/Split_Excel_Package-0.0.8-py3-none-any.whl",
"yanked": true,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "0c92863afeafdfbfa9fe56e7251982f05f2a0509fb7b4feba28ae61656832325",
"md5": "e25a7486f9a2a69b369c0094847ef2b1",
"sha256": "58bece530053f8c21123966b22a4252d35f3ea3b4583837a8a3319b18cb210bc"
},
"downloads": -1,
"filename": "Split_Excel_Package-0.0.8.tar.gz",
"has_sig": false,
"md5_digest": "e25a7486f9a2a69b369c0094847ef2b1",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 3880,
"upload_time": "2023-07-04T07:13:50",
"upload_time_iso_8601": "2023-07-04T07:13:50.333450Z",
"url": "https://files.pythonhosted.org/packages/0c/92/863afeafdfbfa9fe56e7251982f05f2a0509fb7b4feba28ae61656832325/Split_Excel_Package-0.0.8.tar.gz",
"yanked": true,
"yanked_reason": null
}
],
"upload_time": "2023-07-04 07:13:50",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "Guitarman-Waiting-In-The-Sky",
"github_project": "excel_splitter",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "split-excel-package"
}
