Skip to Content
Technical Articles
Author's profile photo Julien LEONARD

SAP Intelligent RPA 2.0 – How to read table column data in PDF

The Cloud Studio brings a lot of new activities especially with the PDF Library. 

In this blogpost, I will explain you how to retrieve data from a column of a table using Get Table Column Entries (PDF) activity. 

We will use this table as sample:


PDF sample

In this case we want to retrieve the 3 columns. To do this we will use 3 times the activity Get Table Column Entries. But let’s focus on the first column. 

Basic usage: 

For the basic usage of this activity we will use only the parameters columnHeader and textBelowTable :  


Activity parameters

In this case the activity will retrieve the data below the label “Material” until the position of the label “Date”. If you don’t fill textBelowTable the activity will retrieve all the labels until the end of the file. 

In our case here is the section that the activity will cover: 


Area covered by the activity

We can see that the activity will retrieve data that are strictly between the position of the letters “M” and “L”. In our case this not what we want because the activity will retrieve nothing. For extend this, there is leftOffset and rightOffset parameters. 

Offset management: 

We saw the basic behavior of the activity, now we will see how to use offsets to retrieve our data. 

The offset parameters are the number of offsets to add to the header label position: 


Usage of the leftoffset

In our case we want to add a leftoffset to retrieve our values. 


Activity parameters with leftOffset

With this we retrieve all the data of the material column : 


Output of the activity

So, we set 70 to retrieve the data. Now the question is how to guess the number of offsets to add? 

Calculate the offset 

We saw that sometimes we need to add offsets to retrieve column data. Now we will see how to calculate the number of offsets. 

In order to retrieve our values, we need to calculate the left offset to add. We have to use the left position of the label Material and the left position of Items (or the label in the column). 

Thanks to the activity Search Text items: 


Search Text Items output for the label Items


Search Text Items output for the label Materials

Thanks to the timeline once you have tested your automation we can see that the left position of Material is 127.73 and the left position of Items is 70.824. 

So 127.73-70.824= 56.906 we just round up and we have the leftOffset to add: 57. 

You can also let the automation calculate this for you with an expression if you want. 


Now you know how to retrieve data in a PDF table.  


For more information on SAP Intelligent RPA

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Sergio Ferrari
      Sergio Ferrari

      Thanks for the blog Julien.

      I believe the example is taken from the public document SAP Intelligent RPA Cloud Studio User Guide available in here and it may worths to be mentioned for further investigations.


      Kind regards,



      Author's profile photo Julien LEONARD
      Julien LEONARD
      Blog Post Author

      Hi Sergio,

      Actually this example has been added to the User Guide after publication.

      I will add the link to the documentation.




      Author's profile photo Sergio Ferrari
      Sergio Ferrari

      Ops, so it was the other way around ! Thus congrats for the brilliant solution Julien