Hi Team,
I need to load a datatable to ultraspreadsheet. Is it possible for ultraspreadsheet ?
Please let me know if i can load data into ultraspreadsheet from database without creating cells and rows in a loop ?
Thanks,
Aditya Patwardhan
Hello Aditya,
Yes, you can load DataTable in UltraSpreadSheet. However, you will need to iterate the rows in cells in a loop to achieve this. For additional information you may check this article in our online documentation “Populating a Worksheet from a DataSet”.
Please let me know if you have any further questions on this matter.
Thank you very much Milko. It worked really fine.
Populating data in spreadsheet is work. But do i need to load complete spreadsheet into database or i can find out which rows has been changed and update those rows only to database?
I am afraid that i need to update each and every cell to database in the same way we have populated it .
Hi Aditya,
Neither the UltraSpreadsheet control nor the Workbook object keep track of which values have been changed. So in theory, you might be able to do that by handling events on the UltraSpreadsheet and tracking which cells the user modified.
But if you are loading data from a database and you need to track changes to the data, are you certain that a Spreadsheet is the control you want to be using? Maybe you would be better off using a DataGrid like the UltraGrid insetad. UltraGrid can bind directly to a data source (with no looping) and the DataSet/DataTable object in DotNet already have functionality to track changes and update the back end via a DataAdapter.