Excel Read Rangee

let me check once
few mins pls buddy
Cheers @Sweety_Girl

Sure

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…
Capturejjj

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
image

The result
image

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.

3 Likes

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