Excel File Operations
HuLoop offers a range of Excel file operations to automate file creation, data retrieval, and management. These actions and functions help streamline Excel-related tasks by eliminating manual data handling and enabling seamless integration within automation workflows.
- 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
