11 packages
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...
More information
This activity has some advance excel features i.e.
-Hide / Show worksheet
-Delete worksheet
-Change font color
-Change font size
-Change font style
-Bold
-Column Autofit
-Get last row
-Get last column
Using these activities can create the Pie,Column,Line and Bar graph.
This package's activities are to make easy automation in Excel.
Excel Column Width
1. AllColumnAutoFit
2. ColumnAutoFit
3. SetColumnWidth
This package 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.
This package is to excute the Excel related operation which filtering the Pivot Table by passing the value in column headder.
AwesomeDataTable
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 ,...
More information
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
Output: 1.)Status...
More information
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 package gives the cell names of all the columns present in the Datatable.
