Please guidance on how to use Extract Structured Data

[22222222asas (그게 뭐라고)]

Hello!

Please explain how to use Extract Structured Data to save multiple pages of a PDF into separate Excel files, one page per Excel file.

EX ) 1 PAGE → First excel, 2 PAGE - > Second excel

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @22222222asas ,
I think you can read file PDF by page
In Range change to 1 for page 1,
… page n

use for loop to get all page,
each loop write to a file excel
Regards
LNV

[rlgandu (Rajyalakshmi Gandu)]

@22222222asas

Get pdfPageCount and save in a variable TotalPageCount
InitpageCount=1
If: InitpageCount<=TotalPageCount
Read Pdf Text:In properties Range Mention InitpageCount.ToString
Generate Datatable
WriteRange activity
InitPageCount=InitPageCount+1

[22222222asas (그게 뭐라고)]

@rlgandu

I’m really sorry

Please provide screenshot with explanation for clearer understanding!

Thank you so much

[22222222asas (그게 뭐라고)]

hi @Nguyen_Van_Luong1
Thank you so much
but
Is there no way to use “Extract Structured Data” for this?

[rlgandu (Rajyalakshmi Gandu)]

@22222222asas

[vidyasreeb (SVR)]

@22222222asas

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

You can try

it will read each page then paste to each excel file

[22222222asas (그게 뭐라고)]

Thank you so much
@Nguyen_Van_Luong1
Is it permissible to use “Extract Structured Data” instead of “read PDF with OCR”?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi,
I think “Extract Structured Data” ok