Documentation

Read And Store PDF Table Data: pdftable

The Read And Store PDF Table Data function extracts tabular data from a PDF file based on specified top and bottom identifiers. The extracted table data is stored in a variable, which can be used for validation or further automation steps. This function helps in retrieving structured data from PDFs without manual intervention.

Example: Suppose you have a PDF file named EmployeeDetails.pdf located in the folder C:\Data. You need to extract the salary details from the table present in this document. The table is identified by the Top Identifier “Employee Salary Details” and the Bottom Identifier “End of Table.” The extracted data should be stored in a variable for validation in subsequent steps.

Steps to Configure:

1. Add a new step.
2. Select RUN Command from the Action dropdown.
3. In the Parameters section, click Edit.
4. Click on Form, select Functions from the dropdown, and choose Read And Store PDF Table Data.
5. Provide the following parameters:
   • Pdffilepath: Enter the full path of the PDF file containing the table (e.g., C:\Documents\Report.pdf).
   • TopIdentifiers: Specify a unique text that appears above the target table to help locate it (e.g., Employee Salary Details).
   • BottomIdentifier: Specify a unique text that appears below the target table to define its boundary (e.g., End of Table).
   • VarName: Define a variable (e.g., ExtractedTableData) to store the retrieved table data.
6. Click on the Save icon.

Note: While the steps for adding an Action are identical in both views, the display of the steps changes:

Outcome on Execution:

• The defined variable (e.g., ExtractedTableData) will store the entire table data, which can be used for further validation in automation workflows.
• You can reference this variable using syntax ${ExtractedTableData} in subsequent steps.