Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Bhagya
170
UltraGrid - How to import the Excel to Ultragrid and update the Ultragrid instead of adding new rows
posted

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

Parents
  • 17259
    Offline posted

    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.

Reply Children
No Data