Html generated for a table in the sheet does not have any identifier to distinguish between Header rows and other rows.
For example the html of the table in the attached excel file looks like:
Class | Cricket | Football | Basketball | total | |
1 | 12 | 10 | 8 | 31 |
Whereas it should be something like:
Class | Cricket | Football | Basketball | total | |
1 | 12 | 10 | 8 | 31 |
Or let me know if there is something else we should use to distinguish between the header rows and other rows in the table.
Same behavior is there when I get the XML using SpreadsheetML2003SaveOptions
Thanks,
Neeraj