BalaReva.Excel.Activities


#1

The package is for the excel charts (Pie Chart)

Package: BalaReva.Excel.Activities
Author: @balupad14


BalaReva.Excel.Activities Continue
#2

Hi Friends,
I have created a new custom component to generate the pie chart for the excel data. Below I have attached sample with output.

Name Space :

image

Properties :

Sample File :ExcelChartSample.zip (50.3 KB)

The out put is.

Bar Chart

Column Chart

Line Chart

Bar Chart

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

Note : To Know that how to add the Gallery Package into Studio. Please check it below.

Regards
Balamurugan


16. RPA Challenge - Create PieChart From Excel File
Bar,pie,line chart activities
Powerpoint
Is there way to create chart using Excel value?
Excel and pie charts
How can we create a bar graph?
How to read data from the Graphs?
Bar Chart Implementaion in Uipath
#4

Hi Friends,

I have included a new activity that to rename the excel sheet’s name. "Rename Work Sheet."

Namespace :

image

Properties:

image

Sample File : RenameSheet.zip (7.1 KB)

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

Regards
Balamurugan


Save as .xlsx
Rename a Workbook
Renaming an Excel sheet
Renaming a sheet in Excel
Rename Single Excel Sheet
Save as .xlsx
How to rename the specific sheet on excel?
Excel renaming
Rename files using Names from excel sheet
#5

hi balupad14
1
thank you for sharing, I download but “Rename Work Sheet” activity does not have. Can you share it back with me? thank you so much


#6

Hi @duynd9,

Have you achieved the solution to get the activity ?

Regards
Balamurugan.S


#7

Hi @balupad14

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

Best Regards


#8

Hi Friends,

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

Namespace:
image

Column Hide Properties :
image

Row Hide Properties :
image

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


Excel Column Hide/Unhide
How to hide Columns in Xl dynamically
#9

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

image

Output

image

Sample File : PieChartSample.zip (7.5 KB)

Regards
Balamurugan.S


How can we copy the pie charts in power point
How to copy images to powerpoint slides?
#10

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

image


1.Properties Copy Data activity
image

Sample File : CopyData.zip (8.1 KB)


2.Properties of Delete Data activity
image

Sample : DeleteData.zip (6.9 KB)


3.Properties of Clipboard To Datatable activity
image

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


Copying Excel data from one workbook to another
Copy range from excel
How to copy from excel and paste into a web search box?
Copy excel data and paste it in Web mail
Copy one Excel row to another Excel
Excel Process Hung
Copy excel data and paste it in Web mail
Copy specific Rows in Excel
Simple copy paste
Copy Paste from Excel - Outlook
I want to Copy my Data from Excel Cell and Paste it in Web Post?
Copy Columns
How to copy an excel column into new sheet by spliting it
Copy excel workseet
Excel - copy data from files to overview file
How to read specific column in excel file and copy into another excel file
#11

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

Name Space :

image


Merge Cells - Merge the cells inside the excel file.

Properties :

image

Sample File : MergeCells.zip (8.7 KB)


UnMerge Cells- Unmerge the cells inside the excel file.

Properties:

image

Sample : UnMergeCells.zip (8.5 KB)


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

Regards
Balamurugan.S


Search for column value and merge data cells
Excel- row merging
Merge Operation
Can‘t’ read merged cells
Merge Excel cells in Faster way
#12

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

Namespace :
image


Properties :
image

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


access
Export excelToAccess
ExcelToAccess
#13

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

  1. Add Comment for a cell
  2. Delete Comment for a cell
  3. Get Comment from the cell.
  4. Show or Hide the comment in the cell
  5. Add New Sheet
  6. Delete Existing Sheet

image

I will update the samples and documentation very soon…

Regards
Balamurugan.S


#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 (1.3 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 (119.6 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 (119.6 KB)


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

Properties.

image

Sample :HideUnhide.zip (8.1 KB)


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

Properties.
image

Sample: ProtectUnProtect.zip (8.2 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


Need to copy the data from one excel to another excel sheet
Excel Copy Paste Range
Copy data of 1 sheet with color and all the formats to the sheet of other excel?
How to copy data from one excel sheet to another excel sheet
Copy Excel File with Dynamic Sheet Name
How to copy a sheet with format (template) and apply or paste it to another sheet (with existing data)
How do I copy a sheet in excel to another excel file with the format retained exactly from the source sheet to the destination sheet?
Copy Sheet from excel to other excel
Copying sheets from one Excel to another
Copy Excel data with all colors and all format
How to copy sheet by sheet to orther file excel
#15

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
image

1.InsertImage

Properties
image

Activity
image

Samples
SetPassword.zip (15.2 KB)


2.InsertImage

Properties
image

Activity
image

Sample :
InsertImage.zip (36.8 KB)


3.InsertTableFormat

Properties
image

Activity
image

Sample :
InsertTableFormat.zip (17.2 KB)
Output

image


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


Excel Locking and Unlocking
How to set/unlock the password in excel file?
#16

Hi Friends,

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

Get Sheets Name

Namespace
image


Properties
image


Sample : ExcelSheetsName.zip (8.1 KB)

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

Regards
Balamurugan.S


How to read the different sheet names in excel
How to get the Sheet name from Excel
#17

Thank you balamurugan


#18

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.


#19

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.

image

image

image

Regards
Balamurugan.S


#20

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

image


#21

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