#1 13 Feb 2013 00:14

cgman
Member
Registered: 16 Feb 2009
Posts: 47

Parse XML in order to create excel template for easy editing.

Hi,

i am looking to do something like this article

http://ss64.org/viewtopic.php?id=1572

Basically, I have an xml file with a ton of sections, keys and CDATA sections.
I need to make a template in order to separate the section start into column A,
editable data to column B and the section end into column C.

excel does a horrible job at disallowing multiple delimiting characters (</) together.

My primary text editing tools are NP++ and xmlpad pro, but no such luck finding a plugin
or export function to segregate these xml sections.

Any help is appreciated.

Thanks,

Cgman

Offline

#2 14 Feb 2013 22:28

cgman
Member
Registered: 16 Feb 2009
Posts: 47

Re: Parse XML in order to create excel template for easy editing.

anyone?

Is there any way to tell powershell to move this </Asterisk> to column C, except for the text between <Begin> Asterisk </Begin> and <CDATA[[ Asterisk ]]>?  this information would need to be moved to column B?

Offline

#3 15 Feb 2013 00:52

npocmaka
Member
From: Bulgaria
Registered: 03 Dec 2009
Posts: 421

Re: Parse XML in order to create excel template for easy editing.

In fact xml editing is pretty easy in powershell...
You want to get data from xml and put it in Excel?

With select-xml (http://ss64.com/ps/select-xml.html) you can extract data using xpaths - to get info from cdtata sections ->
http://stackoverflow.com/questions/1274 … powershell

to write data into excel:
http://www.petri.co.il/export-to-excel- … rshell.htm

If you give more information about your xml structure will be easier to help

Offline

Board footer

Powered by FluxBB