When using the Range_CellRead action from the Excel_Library forge component, I see that empty cells are skipped. In the output list, the cells without a value are not present. This leads to inconsistencies when mapping a row from Excel to a structure in OutSystems, because you don't know which columns are empty.
See the attachments for the Excel file I am using and screen shots of the missing cells.
In my opinion, the empty cells should be returned as well. I'd love to hear your opinion!
Hi @Anne de Swart
You can use ListFilter to check if the cell is empty or not.
Also instead of using Excel_Library , you can use Outsystems standard Excel To Record List function
Regards,
Hi @Tom Zhao! Thank you for your response.
We need the empty cells, so we don't want to exclude them from the list. When we use the Range_CellRead action, we expect that empty cells are returned as well when they are within that range.
The Excel To Record List function is not an option in our actual use case, because we have an Excel file with ~1500 records. Therefore, we first find the records that we need (for the specific customer) and then we use the Range_CellRead function to read the cells in the relevant range.