Rairy04

🛠️ excel-cli - Convert Excel Files Easily

🚀 Getting Started

Welcome to the excel-cli project! This powerful tool allows you to convert Excel files into various formats. You can output your data in JSON, CSV, SQL, HTML, Markdown, XML, and YAML. With features like UPDATE/UPSERT support, a template engine, data filtering, and schema generation, managing your Excel files becomes a breeze.

📥 Download the Tool

To get started, visit this page to download: GitHub Releases Page

📄 Features

• Multi-format Support: Convert Excel files to JSON, CSV, SQL, HTML, Markdown, XML, and YAML effortlessly.
• UPDATE/UPSERT Functionality: Easily update your existing data or insert new data with precision.
• Template Engine: Use templates to control the format of your output files.
• Data Filtering: Filter your data based on specific criteria to get only what you need.
• Schema Generation: Automatically generate schemas for your data formats.

💻 System Requirements

To install and run excel-cli, ensure your system meets the following requirements:

• Operating System: Windows, macOS, or Linux
• Processor: Intel or AMD processor with at least 1 GHz speed
• Memory: Minimum of 2 GB RAM
• Disk Space: At least 100 MB of free space
• Additional Software: None required

⚙️ Installation Steps

1. Navigate to the Releases Page: Go to the GitHub Releases Page.

2. Choose Your Version: Find the latest release version.

3. Download the Application: Click on the appropriate file based on your operating system. Generally, you will see files like excel-cli-windows.exe, excel-cli-macos, or excel-cli-linux.

4. Install the Application:
   • For Windows: Double-click the .exe file and follow the installation prompts.
   • For macOS: Drag the application into your Applications folder.
   • For Linux: Extract the file and run it from the terminal.
5. Run the Application: You can start using excel-cli by opening a command line or terminal window and typing excel-cli.

🎯 Basic Usage

Once you have installed excel-cli, you can start converting Excel files. Here’s a simple command to convert an Excel file:

excel-cli convert input.xlsx -o output.json

In this example, replace input.xlsx with the name of your Excel file, and output.json with the desired output file name.

🛠️ Command Options

excel-cli comes with various options to customize your conversion:

• --format: Define the output format (e.g., json, csv, sql).
• --output: Specify the name of the output file.
• --filter: Apply filtering criteria on your data.

You can view all available commands and options by typing:

excel-cli --help

📚 Example Scenarios

• Converting an Excel file to CSV: This is useful for importing data into many applications.

  excel-cli convert sales.xlsx -o sales.csv --format csv
  

• Generating JSON for a Web Application: Ideal for front-end projects that need data in JSON format.

  excel-cli convert data.xlsx -o data.json --format json
  

• Dynamic Reports using Templates: Use a template to create customized reports based on your data.

  excel-cli convert report.xlsx -o report.md --format markdown --template my_template.tpl
  

👩‍💻 Support and Contribution

If you have questions or need help, please check our issues page to report problems or request features.

We welcome contributions! Feel free to submit a pull request or Open an issue with suggestions or improvements.

📝 License

This project is licensed under the MIT License. See the LICENSE file for details.

Now, you are ready to start working with excel-cli! Enjoy converting your Excel files.