Hide Column in Sheet

[Kunal_Jain]

Hi,
I have a sheet in which I need to Hide a column named “Column1”.
Here I have attached the sheet.
Book1.xlsx (11.0 KB)
Please let me know how to solve this??

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Kunal_Jain ,
You can try
Sub Unhide_All_Rows_Columns()
Columns.EntireColumn.Hidden = True
End Sub

regards,
LNV

[Kunal_Jain]

It will hide Just one Column??
And Do I need to pass it in invoke code activity??

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

This problem have solution

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

How to unhide a column in an Excel spreadsheet, without using an Excel Activity? Use invoke code activity to execute below VB code, 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("Col…

you can try

[Kunal_Jain]

Hi @Nguyen_Van_Luong1
Invoke Code: Exception has been thrown by the target of an invocation.
Getting this Error.
Thanks!!

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Can you share image ?

[Kunal_Jain]

Check this out

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

In here your column is visible, you need hide
→ hidden is true

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Other way is
You can use send hot with “win+r”
type into file path
send hot key “enter”
file open
click to column1
send hot key “ctrl+0”
send hot key “ctrl+S”

[lrtetala (Lakshman Reddy)]

Hi @Kunal_Jain

Please find below xaml for your reference

BlankProcess8.zip (54.6 KB)

O/P:
Book1 (3).xlsx (11.4 KB)

Regards,

[Kunal_Jain]

Hi @lrtetala
Thanks for the update.
It Helped.