Web服务将xml值返回到Excel [英] Webservice returned xml value into Excel

问题描述

我连接到Web服务，它返回一个IXMLDOMNodeList类型变量.看来节点列表的item(0)包含架构，而item(1)包含所有表数据.
如何将这些数据传输到Excel电子表格中?

这是我debug.print results.item(0).xml时返回的结果(结果是IXMLDOMNodeList类型的Web服务的结果)

Hi,

I connect to a web service, and it returns a IXMLDOMNodeList type variable. It looks as though the node list''s item(0) contains the schema, and item(1) contains all the table data.
How can I transfer this data into the excel spreadsheet?

This is what it returns when I debug.print results.item(0).xml (results is the results of the web service in IXMLDOMNodeList type)

<xs:schema id="NewDataSet" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="" 

    xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="v" msdata:UseCurrentLocale="true">
        <xs:complexType>
            <xs:choice minOccurs="0" maxOccurs="unbounded">
                <xs:element name="v">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element name="c0" msdata:Caption="Tag1" type="xs:string" minOccurs="0"/>
                            <xs:element name="c1" msdata:Caption="Tag2" type="xs:string" minOccurs="0"/>
                            <xs:element name="c2" msdata:Caption="Tag3" type="xs:string" minOccurs="0"/>
                            <xs:element name="c3" msdata:Caption="Tag4" type="xs:string" minOccurs="0"/>
                            <xs:element name="c4" msdata:Caption="Tag5" type="xs:string" minOccurs="0"/>
                            <xs:element name="c5" msdata:Caption="Tag6" type="xs:string" minOccurs="0"/>
                            <xs:element name="c6" msdata:Caption="Tag7" type="xs:string" minOccurs="0"/>
                            <xs:element name="c7" msdata:Caption="Tag8" type="xs:string" minOccurs="0"/>
                            <xs :element name="c8" msdata:Caption="Tag9" type="xs:string" minOccurs="0"/>
                            <xs:element name="c9" msdata:Caption="Tag10" type="xs:string" minOccurs="0"/>
                            <xs:element name="c10" msdata:Caption="Tag11" type="xs:string" minOccurs="0"/>
                            <xs:element name="c11" msdata:Caption="Tag12" type="xs:string" minOccurs="0"/>
                            <xs:element name="c12" msdata:Caption="Tag13" type="xs:string" minOccurs="0"/>
                            <xs:element name="c13" msdata:Caption="Tag14" type="xs:string" minOccurs="0"/>
                            <xs:element name="c14" msdata:Caption="Tag15" type="xs:string" minOccurs="0"/>
                            <xs:element name="c15" msdata:Caption="Tag16" type="xs:string" minOccurs="0"/>
                            <xs:element name="c16" msdata:Caption="Tag17" type="xs:string" minOccurs="0"/>
                            <xs:element name="c17" msdata:Caption="Tag18" type="xs:string" minOccurs="0"/>
                            <xs:element name="c18" msdata:Caption="Tag19" type="xs:string" minOccurs="0"/>
                            <xs:element name="c19" msdata:Caption="Tag20" type="xs:string" minOccurs="0"/>
                            <xs:element name="c20" msdata:Caption="Tag21" type="xs:string" minOccurs="0"/>
                            <xs:element name="c21" type="xs:string" minOccurs="0"/>
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
            </xs:choice>
        </xs:complexType>
    </xs:element>
</xs:schema>

这是我debug.print results.item(1).xml时返回的结果(结果是IXMLDOMNodeList类型的Web服务的结果)

This is what it returns when I debug.print results.item(1).xml (results is the results of the web service in IXMLDOMNodeList type)

<diffgr:diffgram xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"><DocumentElement xmlns="">
<v diffgr:id="v1" msdata:rowOrder="0"><c0>DATA1A</c0><c1>DATA2A</c1><c2>DATA3A</c2><c3>DATA4A</c3><c4>DATA5A</c4><c5>DATA6A</c5><c6>DATA7A</c6><c7>DATA8A</c7><c8>DATA9A</c8><c9>DATA10A</c9><c10>DATA11A</c10><c11>DATA12A</c11><c12/><c13>DATA14A</c13><c14>DATA15A</c14><c15>DATA16A</c15><c16/><c17>DATA18A</c17><c18>DATA19A</c18><c19/><c20/><c21>74977LBH9</c21></v>
<v diffgr:id="v2" msdata:rowOrder="1"><c0>DATA1B</c0><c1>DATA2B</c1><c2>DATA3B</c2><c3>DATA4B</c3><c4>DATA5B</c4><c5>DATA6B</c5><c6>DATA7B</c6><c7>DATA8B</c7><c8>DATA9B</c8><c9>DATA10B</c9><c10>DATA11B</c10><c11>DATA12B</c11><c12/><c13>DATA14B</c13><c14>DATA15B</c14><c15>DATA16B</c15><c16/><c17>DATA18B</c17><c18>DATA19B</c18><c19/><c20/><c21>74977LBH9</c21></v>
<v diffgr:id="v3" msdata:rowOrder="2"><c0>DATA1C</c0><c1>DATA2C</c1><c2>DATA3C</c2><c3>DATA4C</c3><c4>DATA5C</c4><c5>DATA6C</c5><c6>DATA7C</c6><c7>DATA8C</c7><c8>DATA9C</c8><c9>DATA10C</c9><c10>DATA11C</c10><c11>DATA12C</c11><c12/><c13>DATA14C</c13><c14>DATA15C</c14><c15>DATA16C</c15><c16/><c17>DATA18C</c17><c18>DATA19C</c18><c19/><c20/><c21>74977LBH9</c21></v>
</DocumentElement></diffgr:diffgram>!

这真的让我发疯了！任何建议都会很棒.谢谢

This is really driving me NUTS! Any suggestions will be great. Thanks

推荐答案

我必须对其进行测试，但是您应该能够简单地将数据另存为xlsx文件并将其加载到Excel 2007中，查看其数据似乎是新的xml文件格式.

I have to test it, but you should be able to simply save that data as an xlsx file and load it into Excel 2007, looking at the data it just appears to be the new xml file format.

这篇关于Web服务将xml值返回到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！