How To Hide A Column In An Excel Spreadsheet, Without Using An Excel Activity?

[system]

How can I hide columns in an Excel spreadsheet without using Excel Activities?

• Hide a column in an Excel spreadsheet without using an Excel Activity.

This can be done by using the VB code below within an Invoke Code Activity:

Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
Dim ws As Microsoft.Office.Interop.Excel.Worksheet
xlApp = New Microsoft.Office.Interop.Excel.Application
wb=xlApp.Workbooks.Open("Excel file location")
ws = CType(wb.Sheets("Excel sheet name"),Microsoft.Office.Interop.Excel.Worksheet)
ws.Activate
ws.Range("Column(s) to Hide (e.g. B:B or B:P)").Columns.EntireColumn.Hidden=True
xlApp.Visible=False
wb.save
wb.close