The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
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
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
Join us for a community conversation on Pulse Width Modulation (PWM), a fundamental technique in electric motor control, and explore how different PWM strategies can yield significantly different results. This webinar provides a comparative analysis of various PWM methods and their effects on motor efficiency, torque…
Join us for a community conversation to discover the Advanced Iterative Solver(AIS) in Simcenter Feko and its application to electrically large and computationally demanding electromagnetic models. The session will provide a general overview of how iterative solution methods can help improve efficiency of large scale…
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
