Metadata-Version: 2.4
Name: excelPlay
Version: 2.8.1
Summary: Split Microsoft Excel file to individual CSV file(s) containing one sheet per file. Multiple input files can be fed in one shot.
Home-page: https://github.com/impratikjaiswal/excelPlay
Author: Pratik Jaiswal
Author-email: impratikjaiswal@gmail.com
License: GNU GENERAL PUBLIC LICENSE v3.0
Project-URL: Bug Tracker, https://github.com/impratikjaiswal/excelPlay/issues
Keywords: Excel Play,Excel CSV Export,excel,microsoft excel,excel export,excel export csv,xlsx,xls,csv,comma seperated values
Requires-Python: >=3.9
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: playHelpers
Requires-Dist: fsspec
Requires-Dist: openpyxl
Requires-Dist: xlrd
Dynamic: author
Dynamic: author-email
Dynamic: description
Dynamic: description-content-type
Dynamic: home-page
Dynamic: keywords
Dynamic: license
Dynamic: license-file
Dynamic: project-url
Dynamic: requires-dist
Dynamic: requires-python
Dynamic: summary

# excelPlay

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

# Stats

[![GitHub License](https://img.shields.io/github/license/impratikjaiswal/excelPlay)](LICENSE)
[![Contributor Covenant](https://img.shields.io/badge/Contributor%20Covenant-2.1-4baaaa.svg)](CODE_OF_CONDUCT.md)

[![GitHub Release](https://img.shields.io/github/v/release/impratikjaiswal/excelPlay)](https://github.com/impratikjaiswal/excelPlay/releases/latest)
[![GitHub commits since latest release](https://img.shields.io/github/commits-since/impratikjaiswal/excelPlay/latest)](https://github.com/impratikjaiswal/excelPlay/commits/main/)

[![Static Badge](https://img.shields.io/badge/amenitypj.in/excelPlay-a?label=website%20url)](https://amenitypj.in/excelPlay)
[![Website](https://img.shields.io/website?url=https://amenitypj.in/excelPlay&label=website%20status)](https://amenitypj.in/excelPlay)

[![Static Badge](https://img.shields.io/badge/impratikjaiswal.github.io/excelPlay-a?label=gihub%20website%20url)](https://impratikjaiswal.github.io/excelPlay)
[![Website](https://img.shields.io/website?url=https://impratikjaiswal.github.io/excelPlay&label=website%20status)](https://impratikjaiswal.github.io/excelPlay)

# Url(s) of AmenityPj 

Refer [Url(s) of AmenityPj](https://impratikjaiswal.github.io/amenitypj/#urls-of-amenitypj) for details.

# Screen Shot(s) of Web App [![Static Badge](https://img.shields.io/badge/amenitypj.in-a)](https://amenitypj.in/) 
![sample_web_1](https://github.com/impratikjaiswal/excelPlay/blob/main/static/images/sample_web_1.gif?raw=true)

# Installation/Setup

Steps can be found [here](https://github.com/impratikjaiswal/pythonHelpers/blob/main/HOW_TO_INSTALL_PYTHON_APPS.md).

# How To Use

There are various ways to Get Started:

- Online Mode
    - Website [![Static Badge](https://img.shields.io/badge/amenitypj.in-a)](https://amenitypj.in) 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](https://github.com/impratikjaiswal/amenitypj) can be used

# Help

Issue tracker can be found [here](CONTRIBUTING.md#issue-tracker).

# Contributing

- Code of Conduct can be found [here](CODE_OF_CONDUCT.md).
- Contributing Guidelines can be found [here](CONTRIBUTING.md).

# 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
    ```
