Excel Read Rangee

let me check once
few mins pls buddy
Cheers @Sweety_Girl


Do these steps to avoid that @Sweety_Girl

  1. Open a blank workbook in Excel.
  2. Go to File > Options > Trust Center
  3. Click on Trust Center Settings…
  4. Under Macro Settings , make sure Trust access to the VBA project object model is checked.

Okay done…

Can you post the entire error you are getting?

Have you changed the file path and the sheet name? @Sweety_Girl

thanks buddy its working

Hi @Sweety_Girl

Apart from other solutions guys have given, This is another way of doing it from workflow itself…

Check out the sample attached…
Excel with same column name

The result

Here’s the code for it :slight_smile:
I have added some comments as well for you to understand… let know if it’s not clear…
TestData.xlsx (8.8 KB)
ColumnNameCheck.xaml (14.0 KB)

Hope it helps.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.