Unanswered

get data from active sheet from excel

(0) Share

Report

Posted on by Wei Ming Leong

313

Hi all,
Thank you for taking time to read this post.
i am trying with power automate desktop to export data out from excel but i encounter problem whereby my excel Column A / Row 1 to 4 is a merge Cell and from row 5 onwards it contain all the data i need.
I need to dynamic capture the column as the column will alway increase each month when added.

This excel is exported by quickbook for P&L and Balance sheet.

After running PAD it only manage to capture Column 1.

here is my flow in PAD.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @WeiMingLeong

Could you share the flow, it is not visible in your post

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar ,
sorry thought i have added the flow.

i am using the excel example in power automate desktop.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Do you get what you need if you start on row 5 instead of row 1?

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report
Copy link

Link copied!

hi @MichaelAnnis ,
nope it still the same.
i only get column A

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is there a separate first free column command so you could choose row 5 instead of of row 1? I think it’s defaulting to row 1 which is causing it to believe that “column 2” is the first free column, since 1-? Is merged.

the other option is to simply call the column number as column %Month + 2% because that will always be accurate.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (0)

Report
Copy link

Link copied!

Hi @MichaelAnnis ,
thank you for replying my message.
can you provide me a sample of using column number as column %Month + 2%.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like (1)

Report
Copy link

Link copied!

hi @MichaelAnnis & @Nived_Nambiar ,
i found the problem
at the end of the excel there is also another cells that are merge.
i have remove it and was able to get all the data.

Was this reply helpful? Yes No