Hi,
I am working on an import functionality that involves dynamic columns and grouping of those columns. The columns are grouped, and the group name cells are merged. Please refer to the image below. I want to read the range of this merged area. How can I implement this?
Thanks in advance!
Hi @Swapnaja Patil ,
I have provided a few links below which may help you resolve your issue:
1. SimpleAdvancedExcelDemo Cell Methods
2. OutSystems Forge Component - Advanced Excel Demo
Please take a look and see if they're helpful.
Thanks,
Vipin Yadav
Hi @Vipin Yadav , Thanks for reply. But Using these cell methods I cannot get the cell range of merged cells.
Hi Swapnaja.
I think you will need to unmerge the cells, reading their values and then merge them again.
When you use the action to read the cell value what result are you getting?
Hi @Beatriz Sabino ,
Thanks for your reply. I can read cell value using cell read action, But I want to read range of merged cells. If I use unmerge cells action I need to pass the range to it, I need to read that range>
Swapnaja
The component doesn't support this as far as I am aware. I'll try and look into it in a bit more detail soon.
Hanno
Thanks Hanno for your reply.