Attempted to read past the end of the stream | Infragistics Forums

1660

Attempted to read past the end of the stream

Thangachan Kuriyan posted over 8 years ago

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"). Add format

Also i have attached the screen shot.

Let me know how to resolve it.

Thanks

2525

Sam Elliott posted over 8 years ago in reply to Thangachan Kuriyan

Hello Thangachan,

I was unable to reproduce the behavior you are mentioning. Loading the excel worksheet with Format As Table set to one of the templates does not result in any error. I am attaching a sample that I used to test this behavior. Feel free to modify this if you feel this is not an accurate representation of what you are trying to achieve.

How many columns do you have in your worksheet? Can you provide the worksheet you are trying to load?

WHDG_groupedToExcel.zip
Cancel
Reply

Cancel
1660

Offline Thangachan Kuriyan posted over 8 years ago in reply to Sam Elliott

Hi,

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.

Thanks
Cancel
Reply

Cancel
2525

Sam Elliott posted over 8 years ago

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.
Cancel
Reply

Cancel