PDF Table extraction not able to write into excel sheet

Hi team,

I had created the workflow pdf table extraction and extraction happing correctly but iam not able write extracted table data into excel sheet its writting just one word "table"which is not related to pdf table extraction.

please find the workflow below
pdftableextraction1.xaml (28.3 KB)

which activity used to extract the tables?

Iam using form extractor

Please check the main file I had attached to it

I am not able to open the xaml file. after extract data table use for each loop to loop the output data table. inside the for each use write range. in sheet name provide variable name

Now you check i will send the file
tableextraction.zip (6.7 KB)

Hi, Due to version error i am getting like below

If u want to get all values including fields and table then you have to use FOR EACH activity. DB (variable) is dataset. so u have to loop it. Inside the loop use write range.
Attached below for ur reference

i tried as you said inside loop write range work book but iam getting error at currentItem

in for each loop properties modify it from object to system.data.datatable.

In the image right side can u see the property panel.

I hope it will resolve your issue. If done mark it as solution. Let me know for any further issues!!!

i don’t why some times its workflow is running sucessfully but now its not running api error message is coming why like this?

send the screenshot of ur error. Previous issue resolved??

yes previous error is solved but check now this error is coming
Screenshot 2024-07-16 132531

Ramya

I tried so many times of document understanding API even though same error iss coming all the time

There is an error in OCR API key inside digitize document. pls check on the API key given correctly.

Happy to help!!! Mark it as Solution if issue resolved

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.