Delete Row Form Excle Sheet

Question

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

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.... ThenHere 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(A3A20.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