ExcelHandle

This function is used to handle excel function like to sort the column by names in ascending or descending order, formatting of date in the column, remove duplicate column, and auto size of columns excel sheet.

Action : SORT

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select ExcelHandle function. Select cmd as sort and provide path of file, column name, sheet number and order by asc or des. This sort action used to sort column names in asc or des order.

Action : FORMAT

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select ExcelHandle function. Select cmd as format and provide path of file, column name, sheet number and date format. This format action is used to provide date format to the columns.

Action : REMOVEDUPLICATE

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select ExcelHandle function. Select cmd as removeDuplicate and provide path of file, column name, and sheet number. This removeDuplicate action is used to remove duplicate column.

Action : AUTOSIZE

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select ExcelHandle function. Select cmd as autoSize and provide path of file. This autoSize action is used to set the auto size of columns.