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.