Bug in AutoFit Column Activity of Bala Reva

[Ahmed_Nizamuddin (Ahmad Nizamuddin)]

Dear @balupad14,

I’m using AutoFit colums activity, this activity works fine when the given sheet name exist in excel. But it pops up message box with message ‘Invalid Sheet Name’ when the given sheet name doesn’t exist in the excel. So can you please fix this issue.

BalaReva.Excel.Activities version is 2020.2.1

Thanks In Advance ,
Ahmed

[Pablito (Pawel Wozniak)]

Hi @Ahmed_Nizamuddin,
I think you should tag @balupad14 here

@balupad14,
Hi Could you assist here?

[balupad14 (Balamurugan)]

Hi @Ahmed_Nizamuddin,

You didn’t show the properties of the Autofit columns. Check it the sheet is exist or not.

Here I have attached a sample for you.

Before :

After :

Properties :

Sample :

AutofitColumn.zip (29.5 KB)

Thank you @Pablito

Regards
Balamurugan.S

[Ahmed_Nizamuddin (Ahmad Nizamuddin)]

@Pablito thank you for helping us to reach out him.

@balupad14, thanks for the quick response,

Here we were performing some negative-test on this activity before using it, we found that it is popping up the message box with above mentioned error.

The error is not our concern, but the message box. Usually whenever some error occurs in any activity, it logs the error message in console and stops the execution of the process.

If we are using this activity, the process won’t end if there is a message box due to any error.

Please Advice.

Thanks ,
Ahmed

[balupad14 (Balamurugan)]

Really I thank you very much @Ahmed_Nizamuddin. Like you, we are getting a boost for component development. It is a very good encouragement for providing feedback about components. I have added the “ContinueOnError” property in all components of this package. When setting it as true, It will not throw the exception. I have updated the package.

Regards
Balamurugan.S

[donghai (zhaodonghai)]

Hi @balupad14
I use the balareva.excel.Activites=2020.1.0
Sometimes “the invalid sheetname” box will be shown.
The Activity is ChangeCellType.
If the box is shown, the process will pending and close by humans.
How to resolve it?
Thanks!

[balupad14 (Balamurugan)]

Hi ,

But the latest version is 2020.3.0. can you send me the sample please.

Thank you
Balamurugan.S

[donghai (zhaodonghai)]

Hi
I have looked for it in https://marketplace.uipath.com/ yesterday, and the version is 2020.1.0.
How to download the latest version?
The sample is very simple, maybe on changecelltype activity.
Thank you.

[balupad14 (Balamurugan)]

hi @donghai ,

Can you share your manage and package?

Thank you
Balamurugan.S

[donghai (zhaodonghai)]

Hi
Look at this, pls.

Thanks
Donghai Zhao

[balupad14 (Balamurugan)]

Hi @donghai ,

Missing this one.

Thank you
Balamurugan.S

[donghai (zhaodonghai)]

I got it!
Thank you very much!