Hi All,
Could you please help me in the following scenario.
I have a UltraGrid showing Employee info(for example). I have 2 buttons "Export to Excel" and "Import from Excel".
step 1: I export the employee info to a xls file.
step 2: Save the file in my local drive. Make changes to the file.
step 3: Import the file from the local drive, update the employee info with the changes made in the excel sheet.
Now I already know how to import from excel and insert data, but could you please help me with updating existing data with the excel data.
Thank you all in advance,
Bhagyashree
Hi Amiram,
Thank you so much for your suggestion. I imported the excel data into a datatable and then used the Merge function to merge the existing data with the imported data. It works great now.
Thanks a ton,
Do you have a data source like List or DataTable? if so, updating the data source is much more simple and faster. After that, refresh grid by grid.Row.Refresh()
If you don't have a data source, make a list of the data you get from the file and bind it to the grid.