excelPlay

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.

Url(s) of AmenityPj

Refer Url(s) of AmenityPj for details.

Screen Shot(s) of Web App

Installation/Setup

Steps can be found here.

How To Use

There are various ways to Get Started:

• Online Mode
  • Website can be used
• 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

Help

Issue tracker can be found here.

Contributing

• Code of Conduct can be found here.
• Contributing Guidelines can be found here.

Sample Usage

1. Run form command prompt or via IDE or via executable (Executable needs to generate separately) python -m excel_play.main.excelPlay file_path OR excelPlay.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"
   

2. Mandatory Parameter: source file or folder path

    Examples:
       
    python -m excel_play.main.excelPlay file_path
    python -m excel_play.main.excelPlay dir_path
   

3. 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
   

4. Optional Parameter: Output Parent Folder path

    Examples:
       
    python -m excel_play.main.excelPlay file_path -o Test
   

5. Help

    python -m excel_play.main.excelPlay -h