Hi,
When i tried to load the excel sheet containing FORMAT AS TABLE the following error occurs - Attempted to read past the end of the stream
Infragistics.Documents.Excel.Workbook.Load(Excel.xls").
Also i have attached the screen shot.
Let me know how to resolve it.
Thanks
Hello Thangachan,
Can you provide more details on how you are populating the excel sheet in your code? How many columns does the Excel sheet you are trying to load have?
Looking forward to your response.
Am populating the excel with WebHierarchicalDataGrid.
WebExcelExporter.Export(WebHierarchicalDataGrid, Workbook.Worksheets[0], 0, 0);
I need the header with filtering. In excel we have option FORMAT AS TABLE. I need that while populating the WebHierarchicalDataGrid in the excel.