Insert a new line into an existing XLSX by using OpenXML

Hi,

I created an excel file (xlsx) from my database.
Now I want to add a header in the first line of the excel file.

I know how to change text in a line but not how to insert a new line to write the DB column name in it.

Please help.

Thanks in advance.
Best regards,

Pat

Hi Pat

It would be easiest to simply create the row with headers before you insert you data - it's more complicated to achieve after that.