Rohan Parab

Rohan Parab

  • NA
  • 2
  • 6.1k

Select/Insert/Update/Delete Excel 2007 File and C#

Feb 22 2012 7:46 AM
I am using datagridview and i am binding my excel file to datagridview. I am able to read from excel file as well as insert to that file using datagridview. But I am not able to delete and update that file. It's giving error that "Deleting data in a linked table is not supported by this ISAM.". Is there any other best method to perform these operation on excel file using datagridview. Or simply how can I delete, update record in Excel file using datagridview in C#.