The package is for the excel charts (Pie Chart)
Package: BalaReva.Excel.Activities
Author: @balupad14
The package is for the excel charts (Pie Chart)
Package: BalaReva.Excel.Activities
Author: @balupad14
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 :
Properties :
Sample File :ExcelChartSample.zip (77.1 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
Hi Friends,
I have included a new activity that to rename the excel sheet’s name. “Rename Work Sheet.”
Namespace :
Properties:
Sample File : RenameExcelSheet.zip (38.8 KB)
Let me if you have any errors.
I would be happy to get more suggestions .
Regards
Balamurugan
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
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
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
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
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
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
Hi Friends,
I have included the below new custom components in the package.
I will update the samples and documentation very soon…
Regards
Balamurugan.S
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).
HideUnhide (It hides and un-hides the worksheet in the work book)
Properties.
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
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
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
Thank you balamurugan
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.
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
but here default sheet name is also coming.can is it possible that only required sheet come?
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