🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Parsing Xml From Excel field

User: "elio_rizkallah"
New Altair Community Member
Updated by Jocelyn

Dear all, 

I have an excel sheet that contains a column called ColumnSet that comtains xml data. 

How could i parse the xml data from this column in the .xls file?

 

 

Regards,

Elio

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "sgenzer"
    Altair Employee

    hello @elio_rizkallah - welcome to the community.  Yes for sure.  Is there a different XML in each cell in the column?  That would be a little weird but you can deal with it.  Basically what I would do is use Read Excel, grab that column you want and convert it to text, loop examples and Write Document for each XML cell contents.  Then use Loop Files on those XML documents and use Read XML inside.


    Scott