Unanswered

Excel Automation

(0) Share

Report

Posted on by Sebastuan

Hey Community,

I want to merge several Excel files which arrives via E-Mail. Excel file 1 arrives as an attachment of an e-mail. Store it on one drive. Excel file 2 arrives. Store it on one drive. Copy worksheet of file 1 to Master file, copy woksheet of file 2 to master file. Send an e-mail with the Master file as an attachment. Is this possible? How?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Sebastuan

If this data is not stored in a table in excel you cannot easily use the excel actions and so I think you need to investigate Office Scripts in Excel. You can write a bespoke typescript / javascript process for Excel that can identify the range of rows in your sheet, return it to your Power Automate via the Excel Script and then write it back https://docs.microsoft.com/en-us/office/dev/scripts/resources/excel-samples.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Sebastuan

How are you getting on?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
Sebastuan 4 on at

Like (1)

Report
Copy link

Link copied!

Thanks, but I think this is too complicated for me. I used Desktop Automation and execute a VBA macro.

Was this reply helpful? Yes No