I have a question about the proper use of the ExportDataTable method of Cells.
In my project, this line of code works:
cells.ImportFromDataReader(sqlDataReader, 1, 0, true);
At this point, I have a not-so-common use case that I need to handle that requires me to change some of the data in the cells that were just imported. (I do not want to save the Excel document yet!)
To satisfy the above, I thought that I could call the ExportDataTable method, edit the returned DataTable instance, and then call ImportDataTable. But the following code does not return any data:
DataTable table = cells.ExportDataTable(row, column, maxRow, maxColumn, false);
Should this approach work? Could someone post some sample code that will work for this use case? Thanks.