Problem
ExcelApplication provides programmatic control over Excel files, including the ability to hide worksheet columns. This post covers how to hide a column using the ExcelApplication API.
Solution
To set a column in a worksheet to be hidden, use Worksheet.GetColumnProperties to return a ColumnProperties object and set ColumnProperties.Hidden to true.
For example:
Worksheet.GetcolumnProperties(0).Hidden = true; //Hides column A in Worksheet 
Follow