| Name | resfeci JSON |
| Version |
0.0.19
JSON |
| download |
| home_page | |
| Summary | Currently allows you to quickly split an Excel report into multiple sheets or multiple reports based on unique column values. |
| upload_time | 2023-07-06 03:04:14 |
| 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.
|
# ResFeci for Excel
In it's current state, this package will allow you to quickly split a single Excel sheet into either separate tabs within the same report or into different Excel reports. For example, if Column 'B' of your Excel report contains "Names" and "Jack" appears in 3 rows and "Jill" appears in 2, then, this will split the report into 2 separate reports (one for only Jack's rows and another for only Jill's rows); alternatively, this will create a new report with tabs entitled "Jack" and "Jill".
By default, the script will split the first worksheet. However, the user may select a specific sheet to split through an optional parameter (see below examples).
**IMPORTANT: Your sheet must contain a header row to function properly!**
## EXAMPLE OF SPLITTING AN EXCEL SHEET BY UNIQUE VALUES IN COLUMN B INTO DIFFERENT REPORTS
from resfeci import excel_split
excel_split.split_into_separate_reports(input_report_path= 'PATH_TO_REPORT.xlsx' , column_number_to_split_by=2)
## EXAMPLE OF SPLITTING AN EXCEL SHEET BY UNIQUE VALUES IN COLUMN B INTO DIFFERENT TABS OF THE SAME REPORT
from resfeci import excel_split
excel_split.split_into_new_tabs_of_single_report(input_report_path= 'PATH_TO_REPORT.xlsx' , column_number_to_split_by=2)
## EXAMPLE OF SPLITTING AN EXCEL SHEET BY UNIQUE VALUES IN COLUMN 'C' OF A WORKSHEET CALLED 'NAMES' INTO DIFFERENT REPORTS
from resfeci import excel_split
excel_split.split_into_separate_reports(input_report_path= 'PATH_TO_REPORT.xlsx' , column_number_to_split_by=3, sheet='NAMES')
**PARAMETER DESCRIPTIONS**
input_report_path = the path to the report to be split
column_number_to_split_by = the NUMBER of the Excel column to split by (A = 1, B = 2, C =3, etc.)
sheet = OPTIONAL parameter which allows you to enter the name of the specific sheet to split. By default, the script will split the first worksheet.
**DEPENDENCIES**
Openpyxl, Pandas
**KNOWN ISSUE**
The current version of this script does not support transfer of formulas!!
Raw data
{
"_id": null,
"home_page": "",
"name": "resfeci",
"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/09/a4/16b7ea678714dfec8b6cfe06413f174da3a2912a0845d6e45276194f60e9/resfeci-0.0.19.tar.gz",
"platform": null,
"description": "# ResFeci for Excel\r\n\r\nIn it's current state, this package will allow you to quickly split a single Excel sheet into either separate tabs within the same report or into different Excel reports. For example, if Column 'B' of your Excel report contains \"Names\" and \"Jack\" appears in 3 rows and \"Jill\" appears in 2, then, this will split the report into 2 separate reports (one for only Jack's rows and another for only Jill's rows); alternatively, this will create a new report with tabs entitled \"Jack\" and \"Jill\". \r\n\r\nBy default, the script will split the first worksheet. However, the user may select a specific sheet to split through an optional parameter (see below examples).\r\n\r\n**IMPORTANT: Your sheet must contain a header row to function properly!**\r\n\r\n\r\n## EXAMPLE OF SPLITTING AN EXCEL SHEET BY UNIQUE VALUES IN COLUMN B INTO DIFFERENT REPORTS\r\n\r\nfrom resfeci import excel_split\r\n\r\nexcel_split.split_into_separate_reports(input_report_path= 'PATH_TO_REPORT.xlsx' , column_number_to_split_by=2)\r\n\r\n\r\n## EXAMPLE OF SPLITTING AN EXCEL SHEET BY UNIQUE VALUES IN COLUMN B INTO DIFFERENT TABS OF THE SAME REPORT\r\n\r\nfrom resfeci import excel_split\r\n\r\nexcel_split.split_into_new_tabs_of_single_report(input_report_path= 'PATH_TO_REPORT.xlsx' , column_number_to_split_by=2)\r\n\r\n## EXAMPLE OF SPLITTING AN EXCEL SHEET BY UNIQUE VALUES IN COLUMN 'C' OF A WORKSHEET CALLED 'NAMES' INTO DIFFERENT REPORTS\r\n\r\nfrom resfeci import excel_split\r\n\r\nexcel_split.split_into_separate_reports(input_report_path= 'PATH_TO_REPORT.xlsx' , column_number_to_split_by=3, sheet='NAMES')\r\n\r\n\r\n\r\n**PARAMETER DESCRIPTIONS**\r\n\r\ninput_report_path = the path to the report to be split\r\n\r\ncolumn_number_to_split_by = the NUMBER of the Excel column to split by (A = 1, B = 2, C =3, etc.)\r\n\r\nsheet = OPTIONAL parameter which allows you to enter the name of the specific sheet to split. By default, the script will split the first worksheet.\r\n\r\n**DEPENDENCIES**\r\nOpenpyxl, Pandas\r\n\r\n**KNOWN ISSUE** \r\nThe current version of this script does not support transfer of formulas!!\r\n",
"bugtrack_url": null,
"license": "",
"summary": "Currently allows you to quickly split an Excel report into multiple sheets or multiple reports based on unique column values.",
"version": "0.0.19",
"project_urls": {
"Homepage": "https://github.com/Guitarman-Waiting-In-The-Sky/excel_splitter"
},
"split_keywords": [
"excel",
"split",
"opensource"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "3196c8f1782b1b30e19682c778e7c37bd9a686e0a93835aceaf4334399aa5c23",
"md5": "935a1f66f8967ec5f40c5145f479c55f",
"sha256": "d39ba41acc140f15f67f23c17df60da53157c3c90b102ab7f86da46667483b18"
},
"downloads": -1,
"filename": "resfeci-0.0.19-py3-none-any.whl",
"has_sig": false,
"md5_digest": "935a1f66f8967ec5f40c5145f479c55f",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 4901,
"upload_time": "2023-07-06T03:04:13",
"upload_time_iso_8601": "2023-07-06T03:04:13.194446Z",
"url": "https://files.pythonhosted.org/packages/31/96/c8f1782b1b30e19682c778e7c37bd9a686e0a93835aceaf4334399aa5c23/resfeci-0.0.19-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "09a416b7ea678714dfec8b6cfe06413f174da3a2912a0845d6e45276194f60e9",
"md5": "a0ad53f7ee76033e40baa4d62dcdb996",
"sha256": "15e43755a2b847bb0cf46f9c48befe92db9f9217f42dfa69bc6ea4487a510804"
},
"downloads": -1,
"filename": "resfeci-0.0.19.tar.gz",
"has_sig": false,
"md5_digest": "a0ad53f7ee76033e40baa4d62dcdb996",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 4650,
"upload_time": "2023-07-06T03:04:14",
"upload_time_iso_8601": "2023-07-06T03:04:14.492250Z",
"url": "https://files.pythonhosted.org/packages/09/a4/16b7ea678714dfec8b6cfe06413f174da3a2912a0845d6e45276194f60e9/resfeci-0.0.19.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-07-06 03:04:14",
"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": "resfeci"
}
