Read data in excel file which contains merged cells in outsystems

Sowndhar S

Solved

Question

Application Type

Reactive

Is there any possible way to read data in excel file which contains merged cells in outsystems?

04 Jan 2023

Daniël Kuhlmann

MVP

Solution

Hi Sowndhar,

Did you try?

Probably the build in function to import an excel in a record list will not work, unless it are a complete set of columns of cells merged in to one.

Else you can try the following Forge component that supports more advanced use cases to import and export excel in OutSystems:

Regards,

Daniel

04 Jan 2023

Ramesh subramanian

Hi Sowndhar S ,

I agreed Daniël Kuhlmann. I used advanced excel component and Cell_Merge server action.

if you are facing any issue. please share OML file.

Thanks,

Ramesh

05 Jan 2023

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.