Delete Row Form Excle Sheet

Ankit Shivnakr

14y19.9k.NET

Can any one help ... for how to delete a particular row form Excle Sheet.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Veeresh Kumar7y ago
// Delete the 2nd row from the worksheet.
worksheet.Rows[1].Delete();
// Delete the 3rd row from the worksheet.
worksheet.Rows.Remove(2);
// Delete three rows from the worksheet starting from the 10th row.
worksheet.Rows.Remove(9, 3);
// Delete a row that contains the "B2"cell.
worksheet.DeleteCells(worksheet.Cells["B2"], DeleteMode.EntireRow);
Bobby Milligan11y ago
I see you have posted your question in "ASP.NET & Web Development" section, in that case I don't thing that you should use excel interop in .net, MS does not recommend its usage on the server side.

Instead you can try this excel component for .net, for example try something like the following:
ExcelFile excel = ExcelFile.Load("Sample.xlsx");
ExcelWorksheet sheet = excel.Worksheets[0];

sheet.Rows.Remove(4);

excel.Save("Sample.xlsx");
Note that the component can read both xls and xlsx files with C# in the same manner.
Hermes Condez14y ago
try this one. it might help you

                    assuming that you have already a workbook "wkBook"
                    wkSheet = (Worksheet)wkBook.Sheets[1];
                    // single delete
                    Range aRangeSingle = wkSheet.get_Range("A1", "A1");
                    aRangeSingle.Delete(XlDeleteShiftDirection.xlShiftUp);
                    // multi-delete
                    Range aRangeMulti = wkSheet.get_Range("A10", "A25");
                    aRangeMulti.Delete(XlDeleteShiftDirection.xlShiftUp);
Ankit Shivnakr14y ago
No yaar ..
its not working

M attaching my work plz find d code and
let know whats prob.

Before this Paste excle file into D drive
Prasant Jinaga14y ago
Hi Ankit,

I am expecting you want to delete the row in excel in C#

If you are using microsoft Interlop services to read and write Excel file....
Then,Here is the process

string filePath = "C:\\sample.xls";
//give the path of our excel file here

clsExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();
//define excel class

clsExcel.Visible = false;
//set the visible property

clsWorkbook = clsExcel.Workbooks.Open(filePath, 2, false, 5,"", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", false,true, 0, false,true,Microsoft.Office.Interop.Excel.XlCorruptLoad.xlNormalLoad);
//open the workbook for editing

clsWorksheet = (Excel.Worksheet)clsWorkbook.ActiveSheet;
//note that this will work only when you have one worksheet (which is obviously
//the active sheet), in case of multiple worksheets use the name property

Excel.Range range = clsWorksheet.get_Range("A3","A20".ToString());
//setting the range for deleting the rows

range.EntireRow.Delete(Excel.XlDirection.xlUp);
//for deleting the rows; in case of columns use: 'EntireColumn' instead of 'EntireRow'

clsWorkbook.Save();
//save the workbook

clsWorkbook.Close(false, "", false);
//close the workbook

clsExcel.Quit();
//quit the workbook

Hope it helps!!!

Thanks,
Prasant