Delete Row Form Excle Sheet

Question

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

Veeresh Kumar · Answer

// 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 Milligan · Answer

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 Condez · Answer

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 Shivnakr · Answer

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 Jinaga · Answer

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