HELP! Alignment ruin when saving Excel as pdf

Help Activities
,
1

Hi, I have a test case to export an excel file to pdf format file. However, the alignment of pdf will be ruin after save it. I attached the format of excel file for assistance.

template1.xlsx (346.8 KB)

2

HI,

Can you elaborate your issue?

In my environment, it seems no problem. (with a little page layout modification.)

image
image1600×665 19.3 KB

Regards,

3

Hello @mizudinhamid

Hope you are using the Excel to pdf activity.

Thanks

4

HI @Yoichi when i export it, it become like this

image
image1915×1040 39.5 KB

Can you share the method you do to achieve that?

5

Hi,

It’s worksheet settings matter.
Can you try to set 1 page at Width in Scale to Fit - PageLayout, as the following, in advance?

image
image1051×462 21.3 KB

Regards,

6

Hi @Yoichi

This page layout cannot be set in advance due to the excel is generated by the system. But your method to change the page layout is working. Thanks! Next question is how to achieve it by using UiPath? I assume the method is to open the excel and indicate to the page layout selectors and finally save it to pdf format?

7

HI,

The following might not be very good approach, but will work.

image
image1075×1366 47.9 KB

It might be better to set WindowMessage as InputMethod than hardware.

Regards,

8

Thanks yoichi

1 Like
9

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