excelPlay

Split Microsoft Excel file to multiple CSV file(s) containing one sheet per file.
Multiple input files can be fed in one shot.

Stats

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 "data\sampleData\Excel Worksheet1.xlsx"
   python -m excel_play.main.excelplay "data\sampleData\Excel Worksheet1.xlsx" "data\sampleData\Excel Worksheet2.xlsx"
   python -m excel_play.main.excelplay "data\sampleData"
   python -m excel_play.main.excelplay "D:\Other\Github_Self\excelPlay\data\sampleData\Excel Worksheet1.xlsx"
   python -m excel_play.main.excelplay "D:\Other\Github_Self\excelPlay\data\sampleData"
   python -m excel_play.main.excelplay "D:\\Other\\Github_Self\\excelPlay\\data\sampleData\\Excel Worksheet1.xlsx"
   python -m excel_play.main.excelplay "D:/Other/Github_Self/excelPlay/data/sampleData/Excel Worksheet1.xlsx"
   

2. Mandatory Parameter: source file(s) or folder path(s)

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

3. Optional Parameter: output format (.csv or .xlsx)

   Examples:
   
   python -m excel_play.main.excelplay file_path -f .csv
   python -m excel_play.main.excelplay file_path --output_format .csv
   python -m excel_play.main.excelplay file_path -f .xlsx
   
   

4. Optional Parameter: archive output format (.zip)

   Examples:
   
   python -m excel_play.main.excelplay file_path -ff .zip
   python -m excel_play.main.excelplay file_path --archive_output_format .zip
   
   

5. Optional Parameter: archive output

   Examples:
   
   python -m excel_play.main.excelplay file_path -a False
   python -m excel_play.main.excelplay file_path --archive_output True
   python -m excel_play.main.excelplay file_path --archive_output true
   python -m excel_play.main.excelplay file_path --archive_output yes
   
   

6. Optional Parameter: output path

   Examples:
   
   python -m excel_play.main.excelplay file_path -o Test
   python -m excel_play.main.excelplay file_path --output_path Test
   

7. Optional Parameter: encoding

   Examples:
   
   python -m excel_play.main.excelplay file_path -e ascii
   python -m excel_play.main.excelplay file_path --encoding ascii
   

8. Optional Parameter: encoding_errors

   Examples:
   
   python -m excel_play.main.excelplay file_path -ee replace
   python -m excel_play.main.excelplay file_path --encoding_errors replace
   

9. Help: For Detailed help

   python -m excel_play.main.excelplay --help