Advanced Excel in Outsystems
Application Type

Hello Everyone,

Hope you are doing good.

In Advanced excel can fetch records based on a particular value or a specific column number.

Is it possible to create a structure based on the column names in Excel using Advanced Excel or some other extensions.I have different column names in a different set of Excel.

I appreciate if you could teach me. 

Hi Lavanya Kamalaguru,

Yes, you can create structure and write values into the cell. Instead you can add your template of excel as resource and using advanced excel forge's action you can assign value to column.

Thank you,


Hi @Gayatri Kapadi

Thanks for your valuable time.

 I can do it but having some issues. My template will not be same at all time. For Eg, In my template I have a column name as "Name" but in excel it has "Name "(some space at last) it will not work.

Hi Lavanya Kamalaguru,

you can create a static entity containing the values of heading same as the coloum which you are adding. it wont effect anything and will work perfectly. 


Hi Lavanya Kamalaguru, 

Could you please share the oml?

Hi Lavanya Kamalaguru,

I looked at your problem. just go through this oml. which I am adding.

Thanks n regards,


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