Universe

ReXLlenT is a typst package that helps you convert Excel xlsx tables to typst tables, powered by wasm. (Formerly eXMLlent.)

Quick Start

Start by importing the package:

#import "@preview/rexllent:0.2.3": xlsx-parser

Then you can use xlsx-parser function to convert your xlsx Excel table to typst table. Here is an example:

#xlsx-parser(read("test.xlsx", encoding: none))

By passing sheet-index parameter, you can specify the sheet index to parse. The default value is 0.

#xlsx-parser(read("test.xlsx", encoding: none), sheet-index: 1)

By toggling parameters below, you can customize the output table:

  • parse-table-style: Parse table style(columns width, rows height), default is true.
  • parse-alignment: Parse cell content alignment, default is true.
  • parse-stroke: Parse cell stroke, default is true.
  • parse-fill: Parse cell fill, default is true.
  • parse-font: Parse font style, default is true.

[!NOTE] Notice that 0pt height or 0pt width will be parsed as auto. Disable parse-table-style to prevent this behavior and set the width and height manually.

Extra arguments passed to xlsx-parser function will be passed to table. Feel free to customize the output table.

Have fun!

Example

  • Excel Table

    Excel

  • Typst Table (with default parameters)

    Typst

  • Typst Table (with parse-table-style: false)

    Typst

  • Typst Table (with parse-alignment: false)

    Typst

  • Typst Table (with parse-stroke: false)

    Typst

  • Typst Table (with parse-fill: false)

    Typst

  • Typst Table (with parse-font: false)

    Typst

  • With Custom Style

    Typst

TODOs

ReXLlenT is still in development and PRs are welcome. Here are some TODOs (also limitations):

  • [ ] Implement in-cell image parsing.
  • [ ] Prevent parsing errors caused by special characters.
  • [ ] Parse auto width and height instead of treating 0pt as auto.
  • [ ] Handle hidden rows and columns.
  • …

Credits

License

This package is licensed under the MIT License.