Unhide columns/rows if present in excel sheet

[GaneshPalaniappan]

Hi Community,

Say for example i contain data in sheet from A1:C3

By performing some macro Operation in excel sheet, after the last column(C) and last row(3rd) of my excel data, there is a new data in(D column) and new data in(4th) row will be produced by macro operation and both of the new column and row are hidden in my sheet.
i want to unhide both of them.
How to do it?

Note: last column and row is dynamic.

Can someone send a .xaml file for it please?

[sreejith.ss]

Hey try this one

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(in_Filename)

ws = CType(wb.sheets(in_sheetname), microsoft.Office.Interop.Excel.Worksheet)
ws.Activate

ws.Rows.EntireRow.Hidden = False

xlApp.DisplayAlerts = False
xlapp.Visible = False

wb.save
wb.close

Use this in a invoke code activity

Regards

Sreejith S S

[GaneshPalaniappan]

[GaneshPalaniappan]

[GaneshPalaniappan]

[GaneshPalaniappan]

How to solve this error?
Exception has ben thrown by target of invocation
@sreejith.ss
@Palaniyappan

[sreejith.ss]

Hey @GaneshPalaniappan please try this workflow
Main.xaml (4.9 KB)

The error occured will be due to sheet name mismatch or file name wrong
Please check if the sheet name and file name is correct.

Regards

Sreejith S S