BalaReva.Excel.Activities

duynd9 · July 28, 2018, 4:56am

Hi @balupad14

Thanks you so much. I used send hotkey. This is ok.

Best Regards

balupad14 · August 8, 2018, 12:58pm

Hi Friends,

I have included a new activities that to hide or un-hide columns and rows in the excel sheet’s.

Namespace:

Column Hide Properties :

Row Hide Properties :

Sample :
File : ExcelHide.zip (7.8 KB)

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

Regards
Balamurugan.S

balupad14 · August 11, 2018, 12:16am

Hi,
In Excel Charts. I have given a new property called “Image Copy”. It is a provision to save the chart as image. It is very helpful to Insert the image to PowerPoint slide.

Here you have specify the full path like “C:\tmp\chart.png”

Property

Output

Sample File : PieChartSample.zip (7.5 KB)

Regards
Balamurugan.S

balupad14 · August 21, 2018, 12:29pm

Hi Friends,
I have included some new activities in the “BalalReva.Excel.Actities”.

Activities

1.Copy Data activity - It copies the data from Excel Sheet to the clipboard
2.Delete Data activity - It deletes the data in the Excel Sheet
3.Clipboard To Datatable activity - It converts the clipboard to Datatable

Namespace

1.Properties Copy Data activity

Sample File : CopyData.zip (8.1 KB)

2.Properties of Delete Data activity

Sample : DeleteData.zip (6.9 KB)

3.Properties of Clipboard To Datatable activity

Sample : CliplboardToDatatable.zip (8.3 KB)

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

Regards
Balamurugan.S

balupad14 · August 23, 2018, 2:59pm

Hi Friends,
I have included some new activities that merge and unmerge the cells

Name Space :

Merge Cells - Merge the cells inside the excel file.

Properties :

Sample File : MergeCells.zip (24.9 KB)

UnMerge Cells- Unmerge the cells inside the excel file.

Properties:

Sample : UnMergeCells.zip (24.8 KB)

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

Regards
Balamurugan.S

balupad14 · August 30, 2018, 9:18pm

Hi Friends,
I have created a new custom component to export the Excel data to Access

Namespace :

Properties :

Cell Range is an optional property.

Sample : ExcelAccess.zip (6.8 KB)

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

Note :
Inside the package. There is no loop to export the excel to access database.

The sample is developed by UiPath Studio version : 2018.3.0-beta.1

Regards
Balamurugan.S

balupad14 · September 5, 2018, 9:40pm

Hi Friends,
I have included the below new custom components in the package.

Add Comment for a cell
Delete Comment for a cell
Get Comment from the cell.
Show or Hide the comment in the cell
Add New Sheet
Delete Existing Sheet

I will update the samples and documentation very soon…

Regards
Balamurugan.S

balupad14 · September 6, 2018, 10:03pm

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

Create WorkBook

Properties

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

Properties

Sample : CopyToFile.zip (269.4 KB)

Copy to Workbook

Activity

Properties

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.

Sample :HideUnhide.zip (25.2 KB)

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

Properties.

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

balupad14 · September 15, 2018, 11:44am

Hi Friends,

I have included the below new custom components in the package.
1.InsertImage - Inset a image into the excel sheet in specific top and let position.
2.InsertTableFormat - Inset the table format .
3.SetPassword - Can able to set and remove the password to the work book.

Namespace

1.InsertImage

Properties

Activity

Samples
SetPassword.zip (15.2 KB)

2.InsertImage

Properties

Activity

Sample :
InsertImage.zip (36.8 KB)

3.InsertTableFormat

Properties

Activity

Sample :
InsertTableFormat.zip (17.2 KB)
Output

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

balupad14 · September 21, 2018, 7:42pm

Hi Friends,

I have included a new custom component that to take excel sheets name

Get Sheets Name

Namespace

Properties

Sample : ExcelSheetsName.zip (8.1 KB)

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

Regards
Balamurugan.S

sundeeperanti · September 24, 2018, 3:41am

Thank you balamurugan

hareshjindal1 · September 24, 2018, 10:03am

Hi Bala,

I want to copy 2 sheets from one file to another file then how to do that with this activity?

Because i can copy only one sheet with this activity.
Also this activity is creating default sheet1 also when copying to another file.
Please help.

balupad14 · September 24, 2018, 7:37pm

Hi @hareshjindal1

You have to perform 2 times like here I have attached the sample.

ExcelCopySheets.zip (7.7 KB)

If you are using the 2018.2 , can check the screen shots.

Regards
Balamurugan.S

hareshjindal1 · September 24, 2018, 8:08pm

but here default sheet name is also coming.can is it possible that only required sheet come?

balupad14 · September 24, 2018, 9:05pm

HI @hareshjindal1,

I can give you a solution . But in the next release, If the workbook creates a new one. It will not have default worksheet.

Solution.
Use the delete sheet activity which exists in the same package.

Thank you for the feed back.

Regards
Balamurugan.S

Guilherme_Andrade · September 26, 2018, 11:07am

Hello @balupad14,

Is there a way to keep all formatting while using the Activity “CopyToFile” ? I am copying one sheet to another Excel file but losing all tables and colors.

Thank you for your help.

Regards,

Guilherme

balupad14 · September 26, 2018, 12:06pm

Hi, Can you attach the sample file to test at my side. Normally it won’t loose the format.

Regards

Balamurugan.S

Guilherme_Andrade · September 26, 2018, 1:17pm

I solved this issue without needing to copy sheets, nevertheless, thanks for your quick reply !

balupad14 · September 26, 2018, 9:11pm

Hi Friends,

I have included a new activity in this package is called “Remove HyperLink”.

Namespace.

Properties

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

Regards
Balamurugan.S

balupad14 · September 26, 2018, 9:12pm

Hi @hareshjindal1,

I have released a new version 13.0.0. Now it should not have the default sheet while creating the excel file automatically.

Regards
Balamurugan.S

Most Active Users - Yesterday
Anil_G
mpraveen1902
Palaniyappan
Yoichi
tazunnisa.badavide
Nguyen_Van_Luong1
Carla_Munoz
ayushi_jain3
Parvathy
nikhil.girish
More details...