excel_gen

A CLI tool, written in Rust 🦀, to generate Excel files from an HTML or Avro file (if needed, we can add other input types).

It is used by our PHP library SpiriitLabs/php-excel-rust to generate Excel files.

Why did we do it ?
Because PHP was too slow to generate our excel files, and because it's fun. :D

How to use

Usage: excel_gen [OPTIONS] --output <OUTPUT> <COMMAND>

Commands:
  avro  Input from Avro
  html  Input from HTML
  help  Print this message or the help of the given subcommand(s)

Options:
  -o, --output <OUTPUT>  Path to excel file output
  -v, --verbose...       Increase logging verbosity
  -q, --quiet...         Decrease logging verbosity
  -h, --help             Print help
  -V, --version          Print version

Use with Avro

excel_gen --output ./output.xlsx avro --file ./input.avro

Note

You can find the Avro schema here: ./schema.json

Use with HTML

excel_gen --output ./output.xlsx html --file ./input.html

Note

HTML example

<table>
  <thead>
    <tr>
      <th>Name</th>
      <th>Age</th>
      <th>City</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>
        John Doe
      </td>
      <td>30</td>
      <td>New York</td>
    </tr>
    <tr>
      <td>Jane Smith</td>
      <td>25</td>
      <td>Los Angeles</td>
    </tr>
    <tr>
      <td>Emily Johnson</td>
      <td>40</td>
      <td>Chicago</td>
    </tr>
    <tr>
      <td colspan="2"></td>
      <td>3</td>
    </tr>
  </tbody>
</table>

Roadmap

• Avro input
  • with format options
• HTML input
  • handle colspan (skip cells)
  • with format options
• add testing
• add benchmarks

If you have any suggestions, feel free to open an issue.

Credits

• Huge thanks to jmcnamara/rust_xlsxwriter for their amazing excel library

License

This bundle is under the MIT license.
For the whole copyright, see the LICENSE file distributed with this source code.