Excel Util
Content Type: Module
Categories: Utility
Overview
This Module Contains
ReadColumnValue- This Java action which allows you to extract values from a specified column in an Excel file (either .xls or .xlsx format) and return them as a comma-separated string. The action reads a defined number of rows from the provided column and includes only non-empty cell values in the resulting string, ensuring a clean output without unnecessary commas.
Write_InCell- This Java action which allows you to write value in specified cell by giving Excel file document, Column and Row Nr as parameter
Parameters:
- FileDocument : The Excel file from which the cell values will be read. The file should be uploaded as a Mendix FileDocument object.
- ColumnNr : The column number (0-based index) , For example, a ColumnNr of 0 corresponds to the first column in the Excel sheet.
- RowNr : Therow number (0-based index) , For example, a RowNr of 0 corresponds to the first row in the Excel sheet.
- No_Of_Row : The number of rows to read from the specified column. This determines how many rows from the top of the Excel sheet will be processed.
Documentation
Dependencies
This module requires installation of Excel Import or Export Module. As Apache POI library is already present there , which is required here.
Typical usage scenario
Extended operations on Excel
Releases
Version: 1.1.0
Framework Version: 9.24.12
Release Notes: Added Write_InCell java action
Version: 1.0.0
Framework Version: 9.24.12
Release Notes: This Module Contains ReadCellValue Java action which allows you to extract values from a specified column in an Excel file (either .xls or .xlsx format) and return them as a comma-separated string. The action reads a defined number of rows from the provided column and includes only non-empty cell values in the resulting string, ensuring a clean output without unnecessary commas.
Parameters:
FileDocument : The Excel file from which the cell values will be read. The file should be uploaded as a Mendix FileDocument object.
ColumnNr : The column number (0-based index) from which the values should be read. For example, a ColumnNr of 0 corresponds to the first column in the Excel sheet.
No_Of_Row : The number of rows to read from the specified column. This determines how many rows from the top of the Excel sheet will be processed.