UiPathGo - BalaReva Excel Activities

Help Marketplace
, ,
89

Hi @balupad14,

Did you have time to check about my question sent last week?

Thanks

Miguel

90

Hi @balupad14
Thank you for your activities.
I am using “insert image at cell” but I am getting an error like “we couldn’t find the item it might have been deleted, moved or renamed”
But file path and image exist.
Can you help me?

1 Like
91

image
image879×409 68 KB

I used this activity in for each.

1 Like
92

Hi Bala! First, fantastic set of activities, very helpful! I am using the “Change Cell Type” activity to change the format to “$#,##0.00_);Red”, which it is doing for the range indicated.

However, just before I do the change, I am writing some numbers (as strings) to the range. When I go back to the workbook, the format is updated, but those cells that were updated with a value in the previous step are still a “text as a number” format. As soon as I change the value or do a hard return, the format changes to the one set. Any thoughts why this is happening?

2020-12-02_17-04-51

The $0.00 values were previously “general” format and updated correct, but the ones boxed in red were the ones updated in my prior step.

Thanks!!

1 Like
93

Hi @Emine_Kaya,

Thank you for using the package. Can you please share a sample xmal and excel file. It will be helpful to investigate.

Thank you
Balamurugan.S

94

Post moved to

95

thank you very much ,

how i can write in multiple excel cells

96

@balupad14 - how do I get the UiPathGoExcel loaded into my packages? I tried downloading the UiPathGo locally, was that correct? When I select it locally, I do not see anything. Thanks,

97

Hi Bala
First Thank u so much for helping community so much, Excellent job.

Need help with bala reva set range activity uipath for font color and forground color keep getting error. used in excel scope but still getting error.

Thanks

98

Hi Mazar,

Thank you for using the package… Now I am in vacation… I will be back in this month end. Apologies for the inconvenience…

Thank you
Balamurugan

99

Hi @balupad14 ,
Great set of activities, it is very helpful for me to build RPA workflow, but i am facing a problem, when i hardcode the unmerge cell E.g “SheetName” & “file path” it works perfectly.
But once i pass a variable into file path and sheet name( I am trying to read all excels in a folder, open each excel and in each sheets unmerge entire excel) Then it occurs The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

100

Hi @mazhussain1 ,

This is the way you can get the package.

image
image1775×955 99.3 KB

image
image1127×740 68.4 KB

Thank you
Balamurugan.S

101

Hi @Aaron_Ko ,

The error does not come from the activity. It is from excel. the below link will help you.

Thank you
Balamurugan.S

102

Hi @balupad14
I am getting the same error as @Emine_Kaya .
I am using relative path to specify image.

1 Like
103

Hi @Masaki
My problem was, image was input argument in workflow also I didn’t give default value or assigned in main file. When I recognized this issue I solved.

Can you check this?

1 Like
104

Hi @Masaki and @Masaki ,

Welcome to UiPath community!

Can you please send me the sample file with workflow?

Thank you
Balamurugan.S

105

Hi @balupad14
Here is my sample file and error screen.
Using absolute path to the image and excel file works fine, but I want to use relative path.

image
image1815×1484 162 KB

Evidence_TakeScreenShot.xaml (11.6 KB)

1 Like
106

@balupad14
Could you answer this?

107

Hi @Masaki,

I have tested it on my side. It is working. The main thing is that I have an English version of OS. I don’t know that how to test your language. Please check your private message.

Thank you
Balamurugan.S

108

is it possible to change a full column finding it by name ?