BalaReva.Excel.Activities

Random and other categories Community Feed
14

Hi Friends,

I have included the below new custom components in the package.
1.Create Workbook.(Create a new worksheet)
2.Copy to File (Copy the worksheet to another excel file).
3.Copy to WorkBook (Copy the worksheet inside the workbook).
4.HideUnhide the worksheet
5.Protect Unprotect the worksheet

image

Create WorkBook

Properties
image

Sample : CreateWorkbook.zip (18.5 KB)

Copy To File
This activity copies the work sheet to an another excel file. If the another file is not exists, you can set the property “Auto File Creation” = true. It creates the file automatically and copies the worksheet.

Activity
image

Properties
image

Sample : CopyToFile.zip (269.4 KB)

Copy to Workbook

Activity
image

Properties

image

If you are not provide value to the “New Sheet Name” property. It will add the default worksheet name(Sheet1).

sample : CopyToWorkBook.zip (136.7 KB)

HideUnhide (It hides and un-hides the worksheet in the work book)

Properties.

image

Sample :HideUnhide.zip (25.2 KB)

Protect UnProtect (It protects and un-protects the worksheet with password )

Properties.
image

Sample: ProtectUnProtect.zip (25.3 KB)

Let me if you have any errors.
I would be happy to get more suggestions.

Note :
The samples are developed by UiPath Studio version : 2018.3.0-beta.1

Regards
Balamurugan.S

6 Likes