How to Delete a Column Programmatically?

c# excel excel-interop
Aximili picture Aximili · Aug 19, 2010 · Viewed 26.4k times · Source

How does one delete a column (or multiple columns) in Excel?

eg. How to delete column C and shift the rest left?

Answer

Aximili picture Aximili · Aug 19, 2010

Here is the solution to make it clearer (thanks to Leniel for the link)

Excel.Range range = (Excel.Range)sheet.get_Range("C1", Missing.Value);
range.EntireColumn.Delete(Missing.Value);
System.Runtime.InteropServices.Marshal.ReleaseComObject(range);

Related questions

Optimal way to Read an Excel file (.xls/.xlsx)

I know that there are different ways to read an Excel file: Iterop Oledb Open Xml SDK Compatibility is not a question because the program will be executed in a controlled environment. My Requirement : Read a file to a DataTable / …

Read More
Closing Excel Application Process in C# after Data Access

I'm writing an application in C# that opens an Excel template file for read/write operations. I want to when user closes the application, excel application process has been closed, without saving excel file. See my Task Manager after multiple …

Read More
How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?

What I want to do I'm trying to use the Microsoft.Office.Interop.Excel namespace to open an Excel file (XSL or CSV, but sadly not XSLX) and import it into a DataSet. I don't have control over the worksheet …

Read More