Excel columns to xml using paticular xsd
Hi All,
I had parsed the excel sheets which is required and got the columns and rows need to convert to xml with xsd as shown below
B & C are columns of one excel sheet after parsin...
Forum Discussion
@bojanvelevski @alchemiz thanks a lot!! but one thing is how can we add id(which is dynamic) & translatable=“yes” which is constant for first column and translatable="no " which is constant for second column wanted to add attribute to even columns like how u added id attribute to row??
Please could you help
Hi Rashmi,
Here’s an updated poc pipeline where I did some object manipulation to set col attributes id and translatable
For setting up an attribute in an object key name should start with ‘@’ then set the node value to ‘$’
I use regex to determine if col value is translatable or not e.g. value.match(/[a-z]/gi)
canvas 15_2022_12_03.slp (7.2 KB)
Thanks,
EmEm
