How to determine whether listobject hasheaders

Aspose.Cells Product Family
1

I need a way to determine if an excel table was created with 'My table has headers'. I see that when adding a listobject to the collection there is a parameter to indicate whether the table has headers.

How do I retrieve the same information regarding an existing listobject Also, related topic, when a table has no header defined in Excel template, the header still displays on the resultant report (when template is copied).

2

Hi,

It seems, this feature is not available. Can you please attach a sample XLS/XLSX file, which you can create manually in Ms-Excel, so that I could further investigate it and add it as a New Feature Request?

3

the attached file has an excel table with a header row and one without. If i wanted to detect if a table has a header how would I do that? also see thread 287490… guessing its a related issue

4

Hi,

Thanks for providing a file. It is a feature of MS Excel 2007. I have added a request for it as CELLSNET-24730.

5

Hi,

Please try the new fix Aspose.Cells for .NET v5.3.0.5.
We have added the new property i.e. ListObject.ShowHeaderRow to check whether the Table has header row or not.

Thank you.