Extract Data from XML to Excel

[joand]

How can I extract the following (Title, Abstracts and Claims) from an XML file and paste the values to excel?

Title: Micro-negative pressure black liquor gasification method and system.

This is taken from
<titles tsip:action="new"><titleTsxm tsip:input="translation" tsip:lang="en">Micro-negative pressure black liquor gasification method and system.</titleTsxm></titles>


Abstract: The invention claims a micro-negative pressure one black liquid gasification method and device. The method to black liquor as raw material, to oxygen as combustion improver, to vapour is pneuma agent to black liquid pneuma in furnace is reactor to make the black liquor gasification in the high temperature and low micro-negative pressure condition, a rough pneuma for pneuma, pneuma pneuma by waste heat boiler for a heat, and then spraying and spraying, to a H2 and CO as main component of purification gasification pneuma. The invention also claims the application method of the system device. The invention application the system device, black liquor gasification method a lower the micro-negative pressure condition, which avoids the leakage of black liquid pneuma in furnace and gas conveying process, time when the spray gun clogging, it can change process, increase the production efficiency and reduce the production cost.

This is taken from
<abstracts tsip:action="new"><abstractTsxm tsip:input="translation" tsip:lang="en"><tsxm>The invention claims a micro-negative pressure one black liquid gasification method and device. The method to black liquor as raw material, to oxygen as combustion improver, to vapour is pneuma agent to black liquid pneuma in furnace is reactor to make the black liquor gasification in the high temperature and low micro-negative pressure condition, a rough pneuma for pneuma, pneuma pneuma by waste heat boiler for a heat, and then spraying and spraying, to a H2 and CO as main component of purification gasification pneuma. The invention also claims the application method of the system device. The invention application the system device, black liquor gasification method a lower the micro-negative pressure condition, which avoids the leakage of black liquid pneuma in furnace and gas conveying process, time when the spray gun clogging, it can change process, increase the production efficiency and reduce the production cost.</tsxm></abstractTsxm></abstracts>

Claims: 1. a micro-negative pressure one black liquid gasification method, wherein, to black liquor as raw material, to oxygen as combustion improver, to vapour is pneuma agent to black liquid pneuma in furnace is reactor to make the black liquor gasification in the high temperature and low micro-negative pressure condition, a rough pneuma for pneuma, pneuma pneuma by waste heat boiler for a heat, and then spraying and spraying, to a H2 and CO as main component of purification gasification pneuma. 2. According to claim 1. said micro-negative pressure black liquor gasification method, wherein the black liquor is 40-75 % by weight of black liquor. 3. According to claim according to claim 1 or 2 said micro-negative pressure black liquor gasification method, wherein a micro-negative pressure through of pumping action of gasification pneuma variable-frequency compressor, the black liquid pneuma furnace for alkali melting object dissolve tank, a waste heat boiler, a hot air spray cooling tower, spray tower, gas buffering tank is maintained at a one micro-negative pressure status. 4. According to claim 3. said micro-negative pressure black liquor gasification method, wherein a negative pressure value of micro-negative pressure is 80 to IOOkPa0. 5. According to claim 4. said micro-negative pressure black liquor gasification method, wherein the oxygen is oxygen system scene preparation. 6. According to claim 5. said micro-negative pressure black liquor gasification method, wherein a water of steam is sprayed into the black liquid gasification of black liquor in the evaporation furnace produce lower in the high temperature condition. 7. According to claim 6. said micro-negative pressure black liquor gasification method, wherein a high temperature condition of 900-1500 degrees centigrade. 8. The one for a claim to claim 1-7 in any one of said micro-negative pressure black liquor gasification method of system device, wherein the system device comprise oxygen system (12), black liquid pneuma for furnace (I), an alkali melting object dissolve tank (2), a waste heat boiler (4), a hot air spray cooling tower (6), a spray desulfurizing tower (8), a gas buffering tank (9), a variable frequency gasification pneuma compressor (10) and gasification pneuma storage tank (11). 9. According to claim according to claim 8 used for a micro-negative pressure black liquor gasification method of system device, wherein said oxygen system (12) through pipeline and the black liquid pneuma for furnace (I) of oxygen entrance connecting, black liquor atomizing spray gun is installed on the spray gun base of black liquid pneuma for furnace (I) a, pre-heating fuel gas pipeline and the pre-heating fuel gas entrance connecting the oxygen, black liquor and pre-heating fuel gas to the furnace body inner is set with gasification pneuma and alkali melting object discharging pipeline in the liquid pneuma for furnace (I) lower part of side surface, the exhaust pipeline lining resistant, corrosion resistant insulating material, pipeline lower side set with opening, the middle connecting base melting object and dissolve tank (2), the black liquid pneuma for furnace (I) of alkali melting object dissolve into green liquor discharging pipeline of the tail end connecting waste heat boiler (4) to a heat of a gasification pneuma, waste heat boiler (upper part and alkali melting object dissolve hold-up vessel upper part outer side connecting with a hot air discharge pipeline (5) and steam discharge pipeline (3), the two bar pipeline are connect to hot spray cooling tower (6) lower part of the hot air spray cooling tower (6) with cold pneuma discharging pipeline (7), connecting to spray desulfurizing tower (8) of lower part, by desulfurizing tower (8) is pipeline connecting the gas buffering tank (9), a buffering tank (9) is connected with the variable-frequency gasification pneuma compressor (10) is connected with the variable-frequency through gasification pneuma compressor (10) suction effect of the black liquid pneuma for furnace (I), an alkali melting object dissolve tank (2), a waste heat boiler (4), a hot air spray cooling tower (6), a spray desulfurizing tower (8), a gas buffering tank (9) one a micro-negative pressure status, at the same time, the purification is pneuma transfer to gasification pneuma storage tank (11).

This is taken from
<claimed tsip:action="new"><claimsTsxm tsip:input="translation" tsip:lang="en"><claimTsxm tsip:no="1" tsip:type="main" tsxm:num="1">1. a micro-negative pressure one black liquid gasification method, wherein, to black liquor as raw material, to oxygen as combustion improver, to vapour is pneuma agent to black liquid pneuma in furnace is reactor to make the black liquor gasification in the high temperature and low micro-negative pressure condition, a rough pneuma for pneuma, pneuma pneuma by waste heat boiler for a heat, and then spraying and spraying, to a H2 and CO as main component of purification gasification pneuma.</claimTsxm><claimTsxm tsip:no="2" tsxm:num="2">2. According to claim 1. said micro-negative pressure black liquor gasification method, wherein the black liquor is 40-75 % by weight of black liquor.</claimTsxm><claimTsxm tsip:no="3" tsxm:num="3">3. According to claim according to claim 1 or 2 said micro-negative pressure black liquor gasification method, wherein a micro-negative pressure through of pumping action of gasification pneuma variable-frequency compressor, the black liquid pneuma furnace for alkali melting object dissolve tank, a waste heat boiler, a hot air spray cooling tower, spray tower, gas buffering tank is maintained at a one micro-negative pressure status.</claimTsxm><claimTsxm tsip:no="4" tsxm:num="4">4. According to claim 3. said micro-negative pressure black liquor gasification method, wherein a negative pressure value of micro-negative pressure is 80 to IOOkPa0</claimTsxm><claimTsxm tsip:no="5" tsxm:num="5">5. According to claim 4. said micro-negative pressure black liquor gasification method, wherein the oxygen is oxygen system scene preparation.</claimTsxm><claimTsxm tsip:no="6" tsxm:num="6">6. According to claim 5. said micro-negative pressure black liquor gasification method, wherein a water of steam is sprayed into the black liquid gasification of black liquor in the evaporation furnace produce lower in the high temperature condition.</claimTsxm><claimTsxm tsip:no="7" tsxm:num="7">7. According to claim 6. said micro-negative pressure black liquor gasification method, wherein a high temperature condition of 900-1500 degrees centigrade.</claimTsxm><claimTsxm tsip:no="8" tsxm:num="8">8. The one for a claim to claim 1-7 in any one of said micro-negative pressure black liquor gasification method of system device, wherein the system device comprise oxygen system (12), black liquid pneuma for furnace (I), an alkali melting object dissolve tank (2), a waste heat boiler (4), a hot air spray cooling tower (6), a spray desulfurizing tower (8), a gas buffering tank (9), a variable frequency gasification pneuma compressor (10) and gasification pneuma storage tank (11).</claimTsxm><claimTsxm tsip:no="9" tsxm:num="9">9. According to claim according to claim 8 used for a micro-negative pressure black liquor gasification method of system device, wherein said oxygen system (12) through pipeline and the black liquid pneuma for furnace (I) of oxygen entrance connecting, black liquor atomizing spray gun is installed on the spray gun base of black liquid pneuma for furnace (I) a, pre-heating fuel gas pipeline and the pre-heating fuel gas entrance connecting the oxygen, black liquor and pre-heating fuel gas to the furnace body inner is set with gasification pneuma and alkali melting object discharging pipeline in the liquid pneuma for furnace (I) lower part of side surface, the exhaust pipeline lining resistant, corrosion resistant insulating material, pipeline lower side set with opening, the middle connecting base melting object and dissolve tank (2), the black liquid pneuma for furnace (I) of alkali melting object dissolve into green liquor discharging pipeline of the tail end connecting waste heat boiler (4) to a heat of a gasification pneuma, waste heat boiler (upper part and alkali melting object dissolve hold-up vessel upper part outer side connecting with a hot air discharge pipeline (5) and steam discharge pipeline (3), the two bar pipeline are connect to hot spray cooling tower (6) lower part of the hot air spray cooling tower (6) with cold pneuma discharging pipeline (7), connecting to spray desulfurizing tower (8) of lower part, by desulfurizing tower (8) is pipeline connecting the gas buffering tank (9), a buffering tank (9) is connected with the variable-frequency gasification pneuma compressor (10) is connected with the variable-frequency through gasification pneuma compressor (10) suction effect of the black liquid pneuma for furnace (I), an alkali melting object dissolve tank (2), a waste heat boiler (4), a hot air spray cooling tower (6), a spray desulfurizing tower (8), a gas buffering tank (9) one a micro-negative pressure status, at the same time, the purification is pneuma transfer to gasification pneuma storage tank (11).</claimTsxm></claimsTsxm></claimed>

Here's the full XML:


<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE tsip SYSTEM "../dtd/cXml.dtd"><tsip xmlns="http://schemas.xxx.com/ts/20041221/tsip" xmlns:cals="http://CALS-URI" xmlns:docdb="http://schemas.xxx.com/ts/20041221/docdb" xmlns:dwpi="http://schemas.xxx.com/ts/20041221/dwpi" xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:tsip="http://schemas.xxx.com/ts/20041221/tsip" xmlns:tsxm="http://schemas.xxx.com/ts/20041221/tsxm" xmlns:wila="http://schemas.xxx.com/ts/20041221/wila" xmlns:xhtml="http://www.w3.org/1999/xhtml" tsip:action="new" tsip:date="2014-06-16" tsip:dtdVersion="25"><memberPatents tsip:action="new"><patent tsip:action="new" tsip:cc="CN" tsip:ki="A" tsip:se="103818879"><accessions tsip:action="new"><accession tsip:src="wila" tsip:type="key">CN-103818879-A</accession><accession tsip:src="tscm" tsip:type="tscmKey">CN-103818879-A-20140528</accession></accessions><updates tsip:action="new"><update tsip:src="wila" tsip:type="pubw">201422</update><update tsip:src="wila" tsip:type="uw">201422</update></updates><assignees tsip:action="new"><assignee><assigneeTotal tsip:form="original">Guangxi University, CN</assigneeTotal><name><nameTotal tsip:form="original">Guangxi University</nameTotal></name><address><addressTotal>CN</addressTotal><countryCode>CN</countryCode></address></assignee></assignees><inventors tsip:action="new"><inventor><inventorTotal tsip:form="original">LI, Shi-qiang, CN</inventorTotal><name><nameTotal tsip:form="original">LI, Shi-qiang</nameTotal></name><address><addressTotal>CN</addressTotal><countryCode>CN</countryCode></address></inventor><inventor><inventorTotal tsip:form="original">NONG, Guang-zai, CN</inventorTotal><name><nameTotal tsip:form="original">NONG, Guang-zai</nameTotal></name><address><addressTotal>CN</addressTotal><countryCode>CN</countryCode></address></inventor><inventor><inventorTotal tsip:form="original">DENG, Zhuo, CN</inventorTotal><name><nameTotal tsip:form="original">DENG, Zhuo</nameTotal></name><address><addressTotal>CN</addressTotal><countryCode>CN</countryCode></address></inventor><inventor><inventorTotal tsip:form="original">CHEN, Yi-yi, CN</inventorTotal><name><nameTotal tsip:form="original">CHEN, Yi-yi</nameTotal></name><address><addressTotal>CN</addressTotal><countryCode>CN</countryCode></address></inventor></inventors><agents tsip:action="new"><agent><agentTotal>Guangxi Nanning Huibo Patent Agent Co., Ltd., CN</agentTotal><name><nameTotal tsip:form="original">Guangxi Nanning Huibo Patent Agent Co., Ltd.</nameTotal></name><address><addressTotal>CN</addressTotal><countryCode>CN</countryCode></address></agent><agent><agentTotal>ZHU, Ping-qiu, CN</agentTotal><name><nameTotal tsip:form="original">ZHU, Ping-qiu</nameTotal></name><address><addressTotal>CN</addressTotal><countryCode>CN</countryCode></address></agent></agents><publications tsip:action="new"><publication tsip:lang="zh" tsipages="8"><documentId><number tsip:form="original">103818879</number><number tsip:form="tsip">103818879</number><countryCode>CN</countryCode><kindCode>A</kindCode><date>2014-05-28</date></documentId><publicationFirst><date>2014-05-28</date></publicationFirst><classificationIpc tsip:action="new"><ipc>C01B-3/36</ipc></classificationIpc></publication></publications><applications tsip:action="new"><application tsip:cc="CN" tsip:ki="A" tsipriorityCode="A2" tsip:se="103818879"><applicationId><number tsip:form="original">201410061669.1</number><number tsip:form="tsip">010061669</number><countryCode>CN</countryCode><applicationYear>2014</applicationYear><date>2014-02-24</date></applicationId></application></applications><priorities tsip:action="new"><priority><applicationId><number tsip:form="original">201310697263.8</number><number tsip:form="tsip">010697263</number><countryCode>CN</countryCode><applicationYear>2013</applicationYear><date>2013-12-16</date></applicationId></priority></priorities>******Data tsip:action="new"><patentCounts tsip:countryCount="1" tsipublicationCount="1"/><noveltyDate><date>2013-12-16</date></noveltyDate><priorityFirst><date>2013-12-16</date></priorityFirst><applicationFirst><date>2014-02-24</date></applicationFirst><documentFlag>1PUB, ABEN, ACEN, AG, CNA, FLD, MCEN, OS, PRAI</documentFlag><numberClaims tsip:lang="en">9</numberClaims>*******Data><classificationIpcCurrent tsip:action="new"><ipc tsip:classLevel="A" tsipffice="CN" tsiposition="F" tsip:rank="A" tsip:scope="I" tsip:type="main" tsip:version="2006-01-01">C01B-3/36</ipc></classificationIpcCurrent><classificationIpc tsip:action="new"><ipc tsip:classLevel="A" tsipffice="CN" tsiposition="F" tsip:rank="A" tsip:scope="I" tsip:type="main" tsip:version="2006-01-01">C01B-3/36</ipc></classificationIpc><titles tsip:action="new"><titleTsxm tsip:input="translation" tsip:lang="en">Micro-negative pressure black liquor gasification method and system.</titleTsxm></titles><abstracts tsip:action="new"><abstractTsxm tsip:input="translation" tsip:lang="en"><tsxm>The invention claims a micro-negative pressure one black liquid gasification method and device. The method to black liquor as raw material, to oxygen as combustion improver, to vapour is pneuma agent to black liquid pneuma in furnace is reactor to make the black liquor gasification in the high temperature and low micro-negative pressure condition, a rough pneuma for pneuma, pneuma pneuma by waste heat boiler for a heat, and then spraying and spraying, to a H2 and CO as main component of purification gasification pneuma. The invention also claims the application method of the system device. The invention application the system device, black liquor gasification method a lower the micro-negative pressure condition, which avoids the leakage of black liquid pneuma in furnace and gas conveying process, time when the spray gun clogging, it can change process, increase the production efficiency and reduce the production cost.</tsxm></abstractTsxm></abstracts><claimed tsip:action="new"><claimsTsxm tsip:input="translation" tsip:lang="en"><claimTsxm tsip:no="1" tsip:type="main" tsxm:num="1">1. a micro-negative pressure one black liquid gasification method, wherein, to black liquor as raw material, to oxygen as combustion improver, to vapour is pneuma agent to black liquid pneuma in furnace is reactor to make the black liquor gasification in the high temperature and low micro-negative pressure condition, a rough pneuma for pneuma, pneuma pneuma by waste heat boiler for a heat, and then spraying and spraying, to a H2 and CO as main component of purification gasification pneuma.</claimTsxm><claimTsxm tsip:no="2" tsxm:num="2">2. According to claim 1. said micro-negative pressure black liquor gasification method, wherein the black liquor is 40-75 % by weight of black liquor.</claimTsxm><claimTsxm tsip:no="3" tsxm:num="3">3. According to claim according to claim 1 or 2 said micro-negative pressure black liquor gasification method, wherein a micro-negative pressure through of pumping action of gasification pneuma variable-frequency compressor, the black liquid pneuma furnace for alkali melting object dissolve tank, a waste heat boiler, a hot air spray cooling tower, spray tower, gas buffering tank is maintained at a one micro-negative pressure status.</claimTsxm><claimTsxm tsip:no="4" tsxm:num="4">4. According to claim 3. said micro-negative pressure black liquor gasification method, wherein a negative pressure value of micro-negative pressure is 80 to IOOkPa0</claimTsxm><claimTsxm tsip:no="5" tsxm:num="5">5. According to claim 4. said micro-negative pressure black liquor gasification method, wherein the oxygen is oxygen system scene preparation.</claimTsxm><claimTsxm tsip:no="6" tsxm:num="6">6. According to claim 5. said micro-negative pressure black liquor gasification method, wherein a water of steam is sprayed into the black liquid gasification of black liquor in the evaporation furnace produce lower in the high temperature condition.</claimTsxm><claimTsxm tsip:no="7" tsxm:num="7">7. According to claim 6. said micro-negative pressure black liquor gasification method, wherein a high temperature condition of 900-1500 degrees centigrade.</claimTsxm><claimTsxm tsip:no="8" tsxm:num="8">8. The one for a claim to claim 1-7 in any one of said micro-negative pressure black liquor gasification method of system device, wherein the system device comprise oxygen system (12), black liquid pneuma for furnace (I), an alkali melting object dissolve tank (2), a waste heat boiler (4), a hot air spray cooling tower (6), a spray desulfurizing tower (8), a gas buffering tank (9), a variable frequency gasification pneuma compressor (10) and gasification pneuma storage tank (11). .</claimTsxm><claimTsxm tsip:no="9" tsxm:num="9">9. According to claim according to claim 8 used for a micro-negative pressure black liquor gasification method of system device, wherein said oxygen system (12) through pipeline and the black liquid pneuma for furnace (I) of oxygen entrance connecting, black liquor atomizing spray gun is installed on the spray gun base of black liquid pneuma for furnace (I) a, pre-heating fuel gas pipeline and the pre-heating fuel gas entrance connecting the oxygen, black liquor and pre-heating fuel gas to the furnace body inner is set with gasification pneuma and alkali melting object discharging pipeline in the liquid pneuma for furnace (I) lower part of side surface, the exhaust pipeline lining resistant, corrosion resistant insulating material, pipeline lower side set with opening, the middle connecting base melting object and dissolve tank (2), the black liquid pneuma for furnace (I) of alkali melting object dissolve into green liquor discharging pipeline of the tail end connecting waste heat boiler (4) to a heat of a gasification pneuma, waste heat boiler (upper part and alkali melting object dissolve hold-up vessel upper part outer side connecting with a hot air discharge pipeline (5) and steam discharge pipeline (3), the two bar pipeline are connect to hot spray cooling tower (6) lower part of the hot air spray cooling tower (6) with cold pneuma discharging pipeline (7), connecting to spray desulfurizing tower (8) of lower part, by desulfurizing tower (8) is pipeline connecting the gas buffering tank (9), a buffering tank (9) is connected with the variable-frequency gasification pneuma compressor (10) is connected with the variable-frequency through gasification pneuma compressor (10) suction effect of the black liquid pneuma for furnace (I), an alkali melting object dissolve tank (2), a waste heat boiler (4), a hot air spray cooling tower (6), a spray desulfurizing tower (8), a gas buffering tank (9) one a micro-negative pressure status, at the same time, the purification is pneuma transfer to gasification pneuma storage tank (11).</claimTsxm></claimsTsxm></claimed></patent></memberPatents></tsip>

 

[pgc01]

Hi

This worked for me. I wrote the xml into a file to test the code. Try like this first.

----------------------------------------------
How I tested

Opened the Notepad and copied there all the full XML text that you posted at the end of your post.
Deleted from the code:

<!DOCTYPE tsip SYSTEM "../dtd/cXml.dtd">

because I don't have the dtd's and also I don't need them for the test.
Saved the file as text.xml in C:\tmp

---------------------------------------------

Ran this code. It writes the result in A1, down, in the active sheet.

See if this helps:

Set the reference: Microsoft XML, v6.0

Sub test()
Dim oXMLDoc As MSXML2.DOMDocument
Dim oItems As MSXML2.IXMLDOMSelection
Dim oItem As MSXML2.IXMLDOMElement
Dim sPathname As String
Dim lRow As Long

sPathname = "c:\tmp\test.xml"
Set oXMLDoc = New MSXML2.DOMDocument

oXMLDoc.Load sPathname

' get the text from abstractTsxm
Set oItems = oXMLDoc.getElementsByTagName("abstractTsxm")
Range("A1").Value = oItems(0).Text

' get the text from titleTsxm
Set oItems = oXMLDoc.getElementsByTagName("titleTsxm")
Range("A2").Value = oItems(0).Text

' get the text from all the claimTsxm items
Set oItems = oXMLDoc.getElementsByTagName("claimTsxm")
lRow = 2
For Each oItem In oItems
    lRow = lRow + 1
    Range("A" & lRow).Value = oItem.Text
Next oItem

End Sub

 

[pgc01]

Sorry, I had the wrong test code. The post is now OK.

 

[joand]

a ok so that's how you get the elements. thanks a lot pgc01!

 

[pgc01]

You're welcome. Thanks for the feedback.

a ok so that's how you get the elements...

Well, ... one of the ways.