Using ImportExcelFile - How to get Headers

Aspose.Cells Product Family
1

I am using the following to import an .xls file.

GridWeb1.WebWorksheets.ImportExcelFile(selectedFilepath)

Is there something I can set that will import the first row as the column headings?

Dana

2

Hi Dana,

Well, I think you can try to create the column headers for the first row using GridWeb APIs after extracting excel file into the grid.

For reference, please check the source code (the demos are installed when you install the control using its msi installer, so you may open the project into VS.Net and check the source code) of our featured demos: http://www.aspose.com/Products/Aspose.Grid/Demos/ especially "Custom Headers" in Common category.

Thank you.