Extract document data (pdf) to excel

Help Activities
, , , ,
1

hola!
sigo con un tema parecido.
tengo este extract document data

The image shows a settings interface for extracting document data using prompts to identify fields such as Invoice, DateInvoice, PO, Country, and tableItem, with options for timeout, auto-validation, and output configuration. (Subtitulado por IA)
The image shows a settings interface for extracting document data using prompts to identify fields such as Invoice, DateInvoice, PO, Country, and tableItem, with options for timeout, auto-validation, and output configuration. (Subtitulado por IA)1335Ă—603 43.7 KB

necsito escribir la informacion en cada cerda correspondiente al excel
A spreadsheet template with headers for invoice details including Invoice#, Date, P.O.#, Shipment, Terms of payment, Quantity Shipped, UOM, Item #, Product Description, Batch/Serial No., and Country of Origin. (Subtitulado por IA)

los datos extraido de la tabla, ya los logro escribir, pero los otros solo se escribe el primer dato
image

help please friends

2

@mively

I am not able convert you language to English but let me try to give some solution,
follow below some video tutorial

1 Like
3

Could you show a screenshot of the Input PDF? (Hide sensitive data, if any)
if it is dummy pdf, could you share it here?

5

hola amigo, ya lo pude solucionar! cualquier cosa cuento contigo!

1 Like
6

una consulta, logré hacerlo de buena forma, pero los datos se repiten todo el tiempo
tengo un for ach

This image shows a sequence of actions in UiPath Studio for iterating through rows in a data table and writing specific values into an Excel sheet along with a log message. (Subtitulado por IA)
This image shows a sequence of actions in UiPath Studio for iterating through rows in a data table and writing specific values into an Excel sheet along with a log message. (Subtitulado por IA)566Ă—698 27.3 KB

y adentro el excel aplication scope en donde escribira los datos
luego escribo los datos de la tabla
The image shows a series of actions in a workflow that extracts data from an Excel sheet titled "Goblus.xlsx" on "Sheet1" and converts specific rows to strings, labeled as item, description, quantity, serial, and price. (Subtitulado por IA)
The image shows a series of actions in a workflow that extracts data from an Excel sheet titled "Goblus.xlsx" on "Sheet1" and converts specific rows to strings, labeled as item, description, quantity, serial, and price. (Subtitulado por IA)424Ă—701 26.1 KB

y voy aumentando la fila

image
image443Ă—126 4.51 KB

se ve asi, cuando deberian ser solo tres datos, ya que eso trae el pdf

This image shows a screenshot of a spreadsheet detailing transactions for modular screwdrivers with columns including invoice number, date, PO number, shipment details, terms of payment, quantity shipped, unit of measure, item number, product description, batch/serial number, country of origin, currency, and package price. (Subtitulado por IA)
This image shows a screenshot of a spreadsheet detailing transactions for modular screwdrivers with columns including invoice number, date, PO number, shipment details, terms of payment, quantity shipped, unit of measure, item number, product description, batch/serial number, country of origin, currency, and package price. (Subtitulado por IA)1499Ă—336 9.85 KB

ayuda

7

a veces escribe los 3 valores bien y otras los va repitiendo.
otra consulta @V_Roboto_V
este invoke es solo para 3 valores o sirve para cuando hay mas valores?

The image displays a snippet of VB.Net code that processes a list of items, extracting specific elements, constructing a string from the remaining list, and adding this data to a DataTable. (Subtitulado por IA)
The image displays a snippet of VB.Net code that processes a list of items, extracting specific elements, constructing a string from the remaining list, and adding this data to a DataTable. (Subtitulado por IA)937Ă—512 22.6 KB

8

he hecho pruebas y esto sucede cuando en el excelya hay datos, y cuando no, lo cual no deberia ser asi ya que tengo que seguir escribiendo datos de otros pdf con la misma estructura ahi :confused:
tambien lo raro es que lo escribe siempre 57 veces

9

It will work for any number of rows.

11

Are you trying to write the data from all PDF to this one Excel? If you are doing that, then you must keep the following things in Mind:

  1. Make sure your flow is Extract data from PDF → InvokeCode to addRows → repeat for every PDF.
  2. At the end, add the entire DataTable to the Excel.

Or

  1. Set dt_Data.Clear() as the first line in the “Invoke Code”, this will make sure that it is empty before processing the data from a new PDF
12

A screenshot of VB.NET code where a DataTable is cleared and rows are modified based on specific string manipulations from a list. (Subtitulado por IA)
A screenshot of VB.NET code where a DataTable is cleared and rows are modified based on specific string manipulations from a list. (Subtitulado por IA)896Ă—654 25.7 KB

cuando agrego
dt_Data.Clear()
al principio, solo me escribe el primer dato, cuando lo saco de la segunda linea, escribe varias vecs los 3 datos

13

then try this:

This assign statement will clear the data table before entering the IF.

The image shows a workflow in UiPath where a DataTable is cloned and an if condition checks if the input data contains a semicolon. (Captioned by AI)
The image shows a workflow in UiPath where a DataTable is cloned and an if condition checks if the input data contains a semicolon. (Captioned by AI)593Ă—218 4.41 KB

15

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