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,
Gayatri
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.
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.
thanks
Could you please share the oml?
I looked at your problem. just go through this oml. which I am adding.
Thanks n regards,
Prince