How to convert datatable to PDF without using Word automation. please help

Help Studio
1

Hi Team,

I wanted to convert datatable to PDF without using word activity as word is not installed on robot server. Could someone please help on it.

Thanks,
Nancy

2

@Nancy29

If excel is installed then you can use save as pdf in excel

Cheers

3

Hi @Anil_G

I am extracting some column values from excel to datatable and need to copy the datatable to pdf document for mail merge activities.
Should I need to convert datatable to excel again and then save as PDF.

Thanks,

4

Hi @Nancy29

Try this

image
image900Ă—1073 44.1 KB

Yes you need to convert again to different excel because save excel as pdf activity converts total excel as pdf if you dont want to convert all sheets to pdf then my suggestion is create new excel and convert to pdf

5

Hi @Nancy29

No need to convert the datatable to excel, If the datatable is in the excel then you can use the excel activities to save the excel as pdf, for that you can use the Save Excel File As PDF activity.

→ Use the Use excel file activity and pass the excel file path.
→ Inside Use excel file activity insert the Save excel file as PDF activity. Then give the path of the PDF path where you want to save it as pdf.

Check the below image for better understanding,

_2024
_2024884Ă—689 46.4 KB

Hope it helps!!

1 Like
6

Hi @lrtetala

Sure. Will try it.

Thanks

7

Hi @mkankatala

Sure. Will try it.

Thanks.

1 Like
8

@Nancy29

Either you can directly delete the column on excel only or can write the datatable to excel and then save as pdf

cheers

1 Like
9

@Nancy29

Step 1:

  • Build DataTable (if needed)

Step 2:

  • Install Packages:
    • UiPath.Excel.Activities
    • UiPath.PDF.Activities

Step 3:

  • Drag “Export to PDF” activity
  • Configure:
    • Input: DataTable
    • Output: PDF file path

Step 4:

  • Run the workflow

cheers!!

10

Hi @sai_gupta

Export to PDF activity is removed from UiPath Studio, I guess. I couldn’t be able to get the activity.

Thanks

11

@Nancy29

use this instead of export to pdf

System.IO.File.WriteAllText("C:\Path\To\Your\File.pdf", yourTextContent)

cheers…!

1 Like
12

Sure. Thankyou for your inputs

13

Thanks All for your inputs. it helps.

14

@Nancy29

when the solution flag is set to

Can you please share with us a sample of the PDF generated with:
and a screenshot of the used modellings? Thanks

15

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