I have two web pages. In one page I am populating the excel using the Importdatatable method and in the other i am binding the cells individually through code(The data comes from an xml, the contents of xml are written into a dataset and then bound to excel)
In the first page when i use -
chart.NSeries.CategoryData = "B7:B10";I have no isses with the creation of the chart based on the range specified. But in the second page where i am binding the cells through the code using
cells[startRow, 0].PutValue(...) method , the above code for setting the chart Nseries gives me this error -
"Index was out of range. Must be non-negative and less than the size of the collection.\r\nParameter name: index"
The index specified is very much within the collection size.
Could you please help?