returned for Tags:"Column"
This package contains the nearly more than 30 custom activities. It is related to the Workbook, worksheet and sheet data. In Resource Tab I have attached details of all the components. It helps and makes easy you to do more process into the excel file. All components can configure very user...
This activity has some advance excel features i.e.
-Hide / Show worksheet
-Change font color
-Change font size
-Change font style
-Get last row
-Get last column
Using these activities can create the Pie,Column,Line and Bar graph.
ExtractGraphImage - Extract the all graph as imges.
ExtractHyperLinks - Extract the hyperlink in the cell range.
MoveSheet - Order the excel sheet.
Paste From Clipboard
Get Table Names
Delete contiguous Rows
Excel Column Width
Created a new Awesome Query language for Custom activity on Data table manipulation in simple text using UiPath.
Ex: 1+2+3+4 | Remove-Duplicates | where Salary > 40000 | Order By Salary Desc | Select SNo=Row(SNo), FirstName, LastName, EmployeeName=FirstName&LastName, Salary, EmployeeType ,...
DataTable Column Operations
DataTable Column Operations - composed on 2 activities:
1.) Remove multiple columns - Removes multiple columns from DataTable
Input: 1.)List of Column Names / Indexes to be removed 2.)Input / Output DataTable
This package is to excute the Excel related operation which filtering the Pivot Table by passing the value in column headder.
With this activity it is possible to add or substract an integer from a column character to receive the matching column in Excel.
For example if you add 5 to the column "A" the result would be "F"
This pakcage has the below activities.
1.Change Column DataType - Change the datatype for multiple columns
2.Dictionary To DataTable - Convert the dictionary to datatable
3. ShowDataTable - Show the datatable in the grid . And helps to see the column informaiton.