Getting Error - Exception thrown: 'System.ArgumentOutOfRangeException' in unvell.ReoGrid.dll about reogrid HOT 5 OPEN

By default, a new worksheet in ReoGrid is initialized with 200 rows and 100 columns. Given your text file has 400 rows, you'll need to explicitly set the number of rows in your target worksheet to accommodate all the data from your file before loading the data.

worksheet.Resize(400, 74);

from reogrid.

Yes, this helps, Thank you @jingwood but now I end up in new error in later part of code. While writing data in my target excel file which is .xlsx file that contains Pivot tables using this data. After loading data in Excel Sheet, if I open Excel file Excel complains

If I select Yes, it deletes all existing Pivot tables and only retains 1 blank sheet and target sheet with data in the same.

Does this saving is not possible in ReoGrid, were only data is loaded, or it is related to option used
grid.Save(excelFilePath, unvell.ReoGrid.IO.FileFormat.Excel2007);
is breaking original sheet. Is there any available way out?

Thanks in advance.

from reogrid.

I can't help without more information about the error. If possible can you please share the Excel file?

from reogrid.