by Internal Labs
Visit publisher's page
License & Privacy
Studio: 21.10 - 23.4
UiPath Community Support
Excel column width adjustor as per requirements
This workflow detects the duplicate column names and renames it by adding the number of occurrences as suffix.
Contains commonly used Excel activities for row/column processing, and filtering. For example batch row delete, batch row highlight, convert column format to text, filtering, merging and others.
By using this activity we can filter the pivot table in an Excel application
This snippet will convert the passed inputs to Excel column name and row number
Pass the DataTable and Column Name or Column Index and get the Column Letter within an Excel Worksheet.
This activity receives as input the column number index and converts it to column letter (uppercase).
With this activity it is possible to add or substract an integer from a column character to receive the matching column in Excel.
This activity takes DataTable as input and returns a dictionary containing column name and the respective cell name
Select required and optional columns from Excel and convert them to data table.
Convert Excel / DataTable column to HTML format.
This snippet helps to get the cell name with the help of row and column number