Unanswered

Write into Excel sheet

(1) Share

Report

Posted on by AT88

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 (2)

Answers (2)

Verified answer

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report
@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,656 Super User 2025 Season 2 on at

Like (1)

Report
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