🦖 ReXLlenT

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

  

• Typst Table (with default parameters)

  

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

  

• Typst Table (with parse-alignment: false)

  

• Typst Table (with parse-stroke: false)

  

• Typst Table (with parse-fill: false)

  

• Typst Table (with parse-font: false)

  

• With Custom Style

  

Pixel Art

You can also convert pixel art to typst table using ReXLlenT. Here are some examples:

• Typst Logo

  

• Typst Guy

  

• Impression, soleil levant

  

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

• lublak/typst-spreet-package
• MathNya/umya-spreadsheet

License

This package is licensed under the MIT License.

Star History