UiPathGo - BalaReva Excel Activities

Help Marketplace
, ,
63

I just try it, but the problem still exist.I use the package from uipath forum with “Latest Package : BalaReva.Excel.Activities.2020.0.1.nupkg (57.9 KB)”.The problem is it still export a pdf in multipale page not in one page.My excel is 2016.
There is a similar activity, [ ExceltoPDFConversion . Activities 1.1.7 ].It can export a excel in one page when i select the “RemovePageBreaks”.Url:RPA Listings - Collections, Integration Packs | UiPath Marketplace
image

1 Like
64

I expect a pdf like this:

image
image1208×361 73.3 KB

but it export a pdf like this(col9-col18 display in a anther page):

image
image1328×487 65.2 KB

2 Likes
65

Hi @41192104,

Can you share the excel file please. Because in the excel export activity , it has an option cell range. It may help you to export in particular range.

Thank you
Balamurugan.S

1 Like
66

I don’t find few activities mentioned here. Example: Formatting the cells in Balareva excel package
Format Cells- Format the cell or cell range - Alignment –

2 Likes
67

Hi @Aish,

Please check version . For your reference .

image
image1805×805 112 KB

Regards
Balamurugan.S

1 Like
68

Thanks Bala for quick reply.When I try to check for the version 202000.0.0 in drop down I don’t find it. I find only one version i.e., 10.0.0

2 Likes
69

Hi ,
202000.0.0 is a testing version. The latest is 2019.10.1. Check that you have the version 2019.10.1.

Thank you
Balamurugan.S

1 Like
70

No Bala I don’t find. Attached screenshot

image
image1907×717 105 KB

1 Like
71

Hi ,
You have selected only the dependencies. Select connect and see the package.

image
image1125×682 88.3 KB

Thank you
Balamurugan.S

1 Like
72

Dear All,
Here I have attached the sample project and video for Merge and unmerge cells.

image
image1871×832 70.9 KB

Sample : MergeUnmerge.zip (33.1 KB)

Regards
Balamurugan.S

1 Like
73

Hi balareva,
is it possible to merge the same value instead? for example instead of 1 Spain value on the first row, it duplicated through the whole row up till the next different value (portugal).
Also what if the range is dynamic?
Thanks

Regards,
Thery Tendyan

1 Like
74

Hi @balupad14,

I try to use your activity “Auto Columns” of your package, as indicate here:

However, my table into my Excel is not extended.
Did you if this activity is adapted to my requirement?
Thanks.

Best regards,

Miguel

1 Like
75

Hi @MigT,

Can you share a sample excel file please ?

Thank you
Balamurugan.S

1 Like
76

Hi @balupad14,

Finally I find a solution to my issue.
Thanks

Miguel

2 Likes
77

Hi @balupad14 i am facing this error on change cell type. excptn image

1 Like
78

HI @pravupada,

Can you share a sample excel file with workflow to see ?

And also take a look this video.

Thank you
Balamurugan.S

1 Like
79

thanks @balupad14 for replying
but i found the solution
The excel files were currupted

1 Like
80

Hi @balupad14 could you help, I’m trying to export an excel to pdf, there are multiple sheets in the workbook, but output pdf only has first sheet, how do I export all?

Capture
Capture300×522 13.1 KB

81

Hello Bala,

I am using Excel 2007. I am getting error as “Value does not fall within the range”

Regards,
SLKT

82

At I gave only to export single sheet. So you can export each sheet as each pdf. and then you can combine everything as a single pdf.

Thank you
Balamurugan.S