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.
This package's activities are to make easy to do many things in Excel.
Excel Column Width
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.
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
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.