Create table for excel data and convert to pdf

Hi,
I have a single row of data with column names in the first row. I want to convert this excel file to pdf but the data becomes messy where 6 columns are written on the first page of pdf and the rest 6 on the next page of pdf with spaces in between the different column data.

What I want is, to create a proper table like structure and then print to pdf. Is this possible? How should I go about it?
Any insight would be great!

Thanks.

@Sunny_Jha

Try below steps to do this.

  1. Use Read Range activity to read the data from excel file and it will give output as DataTable. Let’s say dtInput.

  2. And then use Word Application Scope activity.
    a) Inside use Insert DataTable in document activity and pass above DataTable dtInput to it.
    b) And then use Export to PDF document to export it as PDF file.

https://docs.uipath.com/activities/docs/word-insert-data-table

Note: Install UiPath.Word.Activities package to work with Word documents.

Thanks @lakshman this worked!

1 Like

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