GitHub - yclaires/Split-Excel: How to split Excel file into different files? One sheet into different workbooks by column value.

To split one excel file (one worksheet) into different excel files (different workbooks) by column value.

Two methods are provided. One is to do the job with python, one with VBA macros.

Python:

Libraries used in this file are:

pandas, pathlib, argparse

In the end you will be able to run the script via the command line instead of adjusting the code in python file thanks to argparse.

Credits, thank you for your tutorials:

VBA Macro: Split Excel Worksheet into Multiple Worksheets Based on Column Value

https://www.youtube.com/watch?v=2isx7rIYpz4

Argparse Basics - How I run my scripts via the Command Line

https://www.youtube.com/watch?v=FbEJN8FsJ9U

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
.gitignore		.gitignore
Excel-Split.ods		Excel-Split.ods
Excel-Split.xlsx		Excel-Split.xlsx
README.md		README.md
run_test_2.py		run_test_2.py
split_excel_by_column.py		split_excel_by_column.py
split_excel_by_column_vba_macros.txt		split_excel_by_column_vba_macros.txt

Provide feedback