You are viewing Version 7 documentation. Looking for Version 6? Click Here »
Excel File Operations
Excel File Handler Function enables efficient management and automation of Excel file tasks. This function allows you to interact with Excel workbooks seamlessly, whether it’s converting file formats, running macros, or processing specific rows, columns, or sheets. By integrating this function into workflows, you can automate repetitive tasks, streamline operations, and ensure data accuracy, making them extremely useful for scenarios where Excel plays a central role.
In the following section, we will define the commands available under this function, along with their configuration details.
- Sort Action: sort
- Remove Duplicate Action: removeDuplicate
- Auto Size Action: autoSize
- Format Action: format
- Get Sheet Number Action: getSheetNumber
- Get Row Data Action: getRowData
- Delete Row Data Action: deleteRowData
- Row Copy Action: rowCopy
- Remove Column Data Action: removeColumnData
- Convert To CSV Action: convertToCSV
- Excel To Xml Action: exceltoxml
- Run External Macros Action: runExternalMacros
- Create New EXCEL File: CREATE_EXCEL
- Get EXCEL Sheet Count: GET_SHEET_COUNT
- Get EXCEL Sheet Row Count: GET_ROW_COUNT
- Load EXCEL File And Store Data: loadexcel
- Get EXCEL Cell Value Using Column Name: getcellvalue
- Set EXCEL Cell Value Using Parameters: setcellvalue
- Get EXCEL Cell Value Using Cell Reference: getCellReference
- Set EXCEL Cell Value Using Cell Reference: setCellReference
- Load EXCEL Table Using Index: loadExcelTable
- Compare Two Excel Files: dataCompare
- Get Excel Cell Color Function: getCellColor
- Get Excel Sheet Color Function: getSheetColor
- Get Column Sum in Excel Handler: getColumnSumExcel
