Last post Jul 08, 2009 07:27 AM by suthish nair
Jul 08, 2009 01:27 AM|mmmisa83|LINK
I found out there are ways to Select, Insert, and Update Excel file by using OLEDB. But the limitation is that we can not delete a record.
My idea is to delete row (instead of record). The question is how to programmatically delete row in excel, by id selected?
For example, I have the following Excel records:
I want to delete the row where id = 3. I can grab the id, but have no idea how to delete the row which contains the id 3.
Jul 08, 2009 06:46 AM|qwe123kids|LINK
Import the excel in dataset and Modify as u want Again export it into Excel format
Check the above Link
Jul 08, 2009 06:56 AM|mudassarkhan|LINK
You will need to take help of interop Excel library
Jul 08, 2009 07:27 AM|suthish nair|LINK
Delete Excel Rows