first of all thanks for the excellent job!
I want to feed an Excel sheet with data.
I have created a Table in an empty Excel sheet. I proceed like this to setup all the formatting upfront. My Table consists in a header row and an empty row with the desired formatting
Through code I populate my table by :
retrieving the IXLTable object
getting its last row (which is my empty row)
and then I want to append rows to the table with data
My issue, cause I have one... ;-)
If I use the method InsertRowsAbove : the appended rows are part of my table, the style of the rows is Ok but the cells formatting is lost
If I use the method InsertRowsBelow: the appended rows have the cells formatting I expect but are not part of the table (and obviously don't have the table style)
Any idea on how to append rows to the table keeping cells formatting?
Thanks in advance!!