PDF convert with Modern Activities

Help Studio
, ,
1

Hi All,

I am using below modern activities to convert my Excel into pDf but the aligment is not getting added properly in the PDF.

image
image622×673 19.2 KB

Excel has quite a no of columns but needs to be adjusted in one PDF .
image
image1464×223 5.38 KB

PDF getting generated looks like this :-

image
image1920×1080 146 KB

How this can be achieved with this modern activites?

2

Hi @shashank_dullu

Can you please try below sample

image
image900×1031 46.4 KB

Code:

Excel to PDF.txt (478 Bytes)

Sequence.xaml (9.6 KB)

Cheers!!

3

Before converting to PDF you can try formatting the sheet using Format cell activity and define the whole range.

4

@lrtetala - This is not working .
How can I pass the path below line from txt.
ws.ExportAsFixedFormat Type:=xlTypePDF, Filename:=“C:\Users\lrtetala\Documents\UiPath\BlankProcess17\Pdf.pdf”, Quality:=xlQualityStandard

5

@shashank_dullu

Change it to your location it creates the pdf file

If you want to pass the location dynamically then use below

image
image900×1344 59.5 KB

BlankProcess17.zip (710.8 KB)

Cheers!!

6

image
image1920×1080 172 KB

7

@shashank_dullu

If possible can your share your excel file, meanwhile try below code

Excel to PDF new.txt (645 Bytes)

8

Report_test.xlsx (10.4 KB)
Sample excel which needs to be converted

9

@shashank_dullu

Can you try below

image
image900×1384 58.4 KB

Excel to PDF new.txt (489 Bytes)

Output:

ExcelPDF.pdf (52.9 KB)

Sequence.xaml (16.8 KB)

Cheers!!

10

error in new txt

image
image1920×1080 178 KB

11

@shashank_dullu

Can you please extract the below file and change the pdf path and run the bot

BlankProcess17.zip (704.3 KB)

and also can you please check whether in your Excel Macro settings are enabled or not

Click on File->Options->Trust Center->Trust Center Settings->Macro Settings

image

image
image1051×862 23.4 KB

12

Still getting the error @lrtetala - Can we connect via Zoom for this ?

13

Ok @shashank_dullu

Can you share the link of Zoom

14

MeetingID- 9553920440
passcode - 0WFb30

15

@lrtetala - Can you please ping me
That run time error is again causing blocker post excel property to false.

16

Anyother way to achieve this ??