Excel File couldn't open after row insert from data table with Loop

Like (0) Share

Report

Posted on 27 Mar 2025 08:26:34 by P20TEC

All,

I build a PAD flow to extract data from Web and insert set of data (1 row 16 columns) into the last row (around 180 +1 ) of an existing Excel file. I use FOR EACH loop to update the columns. I managed to insert the data into the file for the first time and after second run, flow completes without any error but the Excel file couldnt open. When clicking on the excel file, instance opens but not with the data, all menu, tabs and cells are greyed out. I issued the close instance of excel in the flow and no luck. .

Here are the steps

Launch Excel

Set active excel worksheet

Get first free row on column from excel sheet (To get the row to be inserted)

Loop the data table

Write to Excel Worksheet with write mode on specified cell

End

Save Excel

Close Excel

Any help would be greatly appreciated

Thx

Categories:

Process Advisor

All responses (3)

Answers (0)

VishnuReddy1997 2,297 Super User 2025 Season 1 on 28 Mar 2025 at 10:03:00

Like (0)

Report

Excel File couldn't open after row insert from data table with Loop

Hi ,

Can you also share screenshot of the flow.

Regards,

vishnu Reddy
P20TEC 2 on 28 Mar 2025 at 08:50:59

Like (0)

Report

Excel File couldn't open after row insert from data table with Loop

Hi Vishnu,

Thanks for picking this up!.

i don't get any error. it just don' open the excel file and excel stays like this.
VishnuReddy1997 2,297 Super User 2025 Season 1 on 27 Mar 2025 at 10:39:08

Like (0)

Report

Excel File couldn't open after row insert from data table with Loop

Hu @P20TEC,

what is the error your getting.Can you share the screenshot of the flow and error.

Regards,

Vishnu Reddy