Export one or more Excel file(s) with single or multiple sheets to several files each containing one sheet.
All sheets will be exported inside a directory with the same name as of file.
Refer Url(s) of AmenityPj for details.
Steps can be found here.
There are various ways to Get Started:
- Online Mode
- Offline Mode (Requires Download / Cloning of the Repo)
- Code can be directly run from
excelPlay/excel_play/main/excelplay.py
using any IDE (Parameter can be passed via IDE) - Local Web Server App amenitypj can be used
- Code can be directly run from
Issue tracker can be found here.
-
Run form command prompt or via IDE or via executable (Executable needs to generate separately)
python -m excel_play.main.excelPlay file_path
ORexcelPlay.exe file_path
Examples: python -m excel_play.main.excelPlay "sample_data\Excel Worksheet1.xlsx" python -m excel_play.main.excelPlay "sample_data\Excel Worksheet1.xlsx" "sample_data\Excel Worksheet2.xlsx" python -m excel_play.main.excelPlay "sample_data" python -m excel_play.main.excelPlay "D:\Other\Github_Self\excelPlay\sample_data\Excel Worksheet1.xlsx" python -m excel_play.main.excelPlay "D:\Other\Github_Self\excelPlay\sample_data" python -m excel_play.main.excelPlay "D:\\Other\\Github_Self\\excelPlay\\sample_data\\Excel Worksheet1.xlsx" python -m excel_play.main.excelPlay "D:/Other/Github_Self/excelPlay/sample_data/Excel Worksheet1.xlsx"
-
Mandatory Parameter: source file or folder path
Examples: python -m excel_play.main.excelPlay file_path python -m excel_play.main.excelPlay dir_path
-
Optional Parameter: target format (csv or xlsx)
Examples: python -m excel_play.main.excelPlay file_path -f csv python -m excel_play.main.excelPlay file_path -f xlsx
-
Optional Parameter: Output Parent Folder path
Examples: python -m excel_play.main.excelPlay file_path -o Test
-
Help
python -m excel_play.main.excelPlay -h