How to delete multiple excel coloumn in c#

Question

i have tried this for deleting A,B,C coloums but getting error

excelRange.get_Range("A,B,C", Missing.Value);
excelRange.EntireColumn.Delete(Missing.Value);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelRange);

Ganesan C · Answer

Try this. Excel.Range range = (Excel.Range)sheet.get_Range("A:C", Missing.Value); range.EntireColumn.Delete(Missing.Value); System.Runtime.InteropServices.Marshal.ReleaseComObject(range);

Leon D · Answer

You can install Free Spire.XLS library via nuget, and then use the following code to delete columns with ease. Workbook workbook = new Workbook(); workbook.LoadFromFile(@"..\excel.xlsx"); //get the first worksheet Worksheet sheet = workbook.Worksheets[0]; for(int i = 10; i >= 1; i--) { //delete the first 10 columns in the first sheet sheet.DeleteColumn(i); } //save the excel file workbook.SaveToFile("sample.xlsx", ExcelVersion.Version2010);

Ranjith Balan · Answer

HI,deleted now but my coloumn order messed up..how can i re arange? ORIGINAL ........................... "Account_No"; "FIRST_NAME"; "MIDDLE_NAME"; "LAST_NAME"; "Effective_Date"; "Birth_Year"; "SSN"; "Gender"; "Tobacco"; "ADDR_LINE1"; "CITY_NAME"; "ZIP_CODE"; "PCP ID "; "Policy No";/N "Product Offering "; "State"; AFTER I DELETE AND DID SOME OTHER FUNCTION -How can i reorder below coloumns like first one ........................................................................................... POLICY_NO ACCOUNT_NO| FIRST_NAME| MIDDLE_NAME| LAST_NAME| EFFECTIVE_DATE |BIRTH_YEAR |SSN| GENDER| ADDR_LINE1| CITY_NAME| ZIP_CODE| STATE| TOBACCO| PCP ID| PRODUCT OFFERING