How to Create an Excel Template and Fill Data Horizontally with MiniExcel

[masterworgen]

Excel Type

• XLSX
• XLSM
• CSV
• OTHER

Upload Excel File

https://github.com/masterworgen/MiniExcel/blob/master/test1.xlsx

MiniExcel Version

Description

I'm using MiniExcel to generate an Excel file from a template. My goal is to fill the data horizontally (from left to right) instead of the default vertical (top to bottom) direction. Specifically, I want to have labels in the first column (A) and fill data across subsequent columns (B, C, D, etc.).

The resulting filled data should look like this:

    A           B           C           D
1 Name     Name1     Name2     Name3
2 Department Department1 Department2 Department3
3 City      City1    City2    City3
4 Country   Country1   Country2   Country3

[bluesadman]

Yes，I want too！

[meiranzheng]

I opened PR #912 to document a workaround for horizontal fill (transpose to a matrix + MiniExcel.SaveAs(..., printHeader: false)) and clarify the current limitation in the template renderer.

PR: #912

[michelebastione]

This is a good enough workaround to pause further research around this feature implementation for the time being.