Pdf file to excel data table

Hi,

image
Data from pdf is extracted and writing into excel but problem is “/” has to written under TFSN and TSSN column for other columns data in not there to extract same table format need to use. I used array row to write data it’s writing like this.


How to write under specified column, please help.

Regards,
Lakshmi

can you please share the wf file and pdf

@Lak_Ui not able to share pdf i can share workflow
pdf to excel.zip (9.7 KB)
Please look on it.

Hello @lakshmi.mp

Use For Each Row Activity Instead of Add Data Row Activity.

Hope This Helps.

Regards,
Saloni

Main.xaml (21.5 KB)
i have updated the wf you shared . Please take a look

@Lak_Ui writing in specified column data not extracting properly

@sb001 where to store the current row data of TTSN, TFSN, TSSN

@lakshmi.mp Its same workflow which you are using,
Just Instead of add Data row Activity use for each row Activity.

Because Add data row activity will add data in Sequence where as using for each row activity you can add data on column where you want to add.

Regards.
Saloni

1 Like

the variables you have declared have proper values right except that it is not writing in the column intended…can you share the excel file you are getting after running through the wf i shared

Hi @Lak_Ui


Its writing now. Thank you

Thanks & Regards,
Lakshmi

1 Like

Please the mark the proper thread as solution

@lakshmi.mp
Please mark it as solution if its worked.

1 Like

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