web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Write into Excel sheet

Power Automate

Answered

Write into Excel sheet

(1) Share

Report

Report

Posted on by AT88

34

Hello,

I am trying to extract table data from a PDF file. The "ExtractedPDFTables" variable contains many tables, but I want to write data only from index 4 onwards into an Excel sheet because the data up to index 3 is not structured. Please advise me on how to resolve this.

.

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@AT88

Try below approach:

Code:
Pdf.ExtractTablesFromPDF.ExtractTables PDFFile: $'''C:\\Boot\\platform.pdf''' MultiPageTables: True SetFirstRowAsHeader: True ExtractedPDFTables=> ExtractedPDFTables Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance LOOP LoopIndex FROM 0 TO ExtractedPDFTables.Count STEP 1 IF LoopIndex >= 4 THEN Excel.GetFirstFreeColumnRow Instance: ExcelInstance FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: ExtractedPDFTables[LoopIndex].Datatable Column: $'''A''' Row: FirstFreeRow END END

How to copy/paste the above code into your PAD?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Verified answer

VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AT88 ,

Please find the solution.

Code:
Please Copy the below code to your flow.
Pdf.ExtractTablesFromPDF.ExtractTables PDFFile: $'''C:\\Users\\Desktop\\Power Automate Desktop\\Practice\\PDF\\Input\\pdf tables.pdf''' MultiPageTables: True SetFirstRowAsHeader: True ExtractedPDFTables=> ExtractedPDFTables Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance SET LoopNumber TO 0 LOOP FOREACH CurrentItem IN ExtractedPDFTables IF LoopNumber >= 4 THEN Excel.GetFirstFreeColumnRow Instance: ExcelInstance FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CurrentItem Column: $'''A''' Row: FirstFreeRow END Variables.IncreaseVariable Value: LoopNumber IncrementValue: 1 END Excel.CloseExcel.CloseAndSave Instance: ExcelInstance

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No

Join the conversation