[question] 1) how can i add a row above the table add some text in it. ? 2) and merge the cells a1 to g1 ?

[blackholeearth]

Excel Type

• [x] XLSX
• [ ] XLSM

MiniExcel Version

Description

[question]

1. how can i add a row above the table add some text in it. ?
2. and merge the cells a1 to g1 ?

[6933]

这个功能确实很实用，希望在SaveAs之前可以写入标题或其他的说明性文字.

[birdol]

I need this method too

[shps951023]

You can use SaveAsByTemplate

[birdol]

I need translate my datacolumn Name . and keep english colName stay. unless... I make a dynamic template file.

my solution for this condition ： export to csv。 then insert translateed row in second line。then merge csv to xlsx。 but，there is a question，i need read csv file into DataTable，it takes too much memory。

[michelebastione]

@birdol could you provide a sample of your code and an example of the output you want to achieve?