Import Spreadsheet reading row by row

[Bernie]

I need to import a spreadsheet into a dataset. The spreadsheets have rows and columns of data, but some of the columns are totaled at the bottom. I think this is giving me error when trying to use the DataTableFormatProvider.Export.

So I want to open the file and read the cells row by row. Are there any examples on how to open a spreadsheet and walk through it row by row?

[Yoan]

Hello, Bernie

I was able to reproduce the same results you are describing and have logged this behavior as an item in our Feedback Portal: SpreadProcessing: Exception "Invalid data passed" is thrown when exporting with DataTableProvider and a column containing а formula. If you'd like you can subscribe to the task in order to track its progress and get notified of any future updates.

I apologize if this is causing you any setbacks. I have updated your Telerik Points as a sign of appreciation for bringing this up.

As a workaround, I can suggest:

• If you'd like to keep the totaled cells you can set their value manually and not have a formula in them.
• If the totaled cells are not required in the final result you can delete them completely before exporting.

And if you are still interested, more information on iterating Spreadsheet cells and having access to their properties can be found in the following articles:

• Iterating Used Cells
• Get, Set and Clear Cell Properties

If you have any other questions or feedback you would like to share, feel free to do so.

Regards,
Yoan
Progress Telerik