以文本方式查看主题

-  计算机科学论坛  (http://bbs.xml.org.cn/index.asp)
--  『 XML基础 』  (http://bbs.xml.org.cn/list.asp?boardid=1)
----  [求助]关于EXCEL2003中的xml映射导出问题请教  (http://bbs.xml.org.cn/dispbbs.asp?boardid=1&rootid=&id=58008)

--  作者：Bingler
--  发布时间：1/13/2008 1:32:00 PM

--  [求助]关于EXCEL2003中的xml映射导出问题请教
请问如何能在excel2003中做好数据,然后导出如下格式的xml文件:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ufinterface xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <voucher_body>
   <entry>
    <entry_id>1</entry_id>
    <account_code>a</account_code>
    <abstract>a</abstract>
    <settlement>a</settlement>
    <document_id>a</document_id>
    <document_date>1970-01-01</document_date>
    <currency>a</currency>
    <unit_price>0</unit_price>
    <exchange_rate1>0</exchange_rate1>
    <exchange_rate2>0</exchange_rate2>
    <debit_quantity>0</debit_quantity>
    <primary_debit_amount>0</primary_debit_amount>
    <secondary_debit_amount>0</secondary_debit_amount>
    <natural_debit_currency>0</natural_debit_currency>
    <credit_quantity>0</credit_quantity>
    <primary_credit_amount>0</primary_credit_amount>
    <secondary_credit_amount>0</secondary_credit_amount>
    <natural_credit_currency>0</natural_credit_currency>
    <auxiliary_accounting>
     <item name="a">a</item>
     <item name="b">b</item>
     <item name="c">c</item>
    </auxiliary_accounting>
    <bill_type>a</bill_type>
    <bill_id>a</bill_id>
    <bill_date>a</bill_date>
    <detail>a</detail>
    <free1>a</free1>
    <freeitem1>a</freeitem1>
    <freeitem2>a</freeitem2>
    <freeitem3>a</freeitem3>
    <freeitem4>a</freeitem4>
    <freeitem5>a</freeitem5>
    <freeitem6>a</freeitem6>
    <freeitem7>a</freeitem7>
    <freeitem8>a</freeitem8>
    <freeitem9>a</freeitem9>
    <freeitem10>a</freeitem10>
    <otheruserdata>
     <cashflowcase>
      <money>0</money>
      <moneyass>0</moneyass>
      <moneymain>0</moneymain>
      <pk_cashflow>a</pk_cashflow>
     </cashflowcase>
    </otheruserdata>
    <subjfreevalue>
     <subjfreevalue1>a</subjfreevalue1>
     <subjfreevalue2>a</subjfreevalue2>
     <subjfreevalue3>a</subjfreevalue3>
     <subjfreevalue4>a</subjfreevalue4>
     <subjfreevalue5>a</subjfreevalue5>
    </subjfreevalue>
   </entry>
   <entry>
    <entry_id>2</entry_id>
    <account_code>b</account_code>
    <abstract>b</abstract>
    <settlement>b</settlement>
    <document_id>b</document_id>
    <document_date>1970-01-01</document_date>
    <currency>b</currency>
    <unit_price>0</unit_price>
    <exchange_rate1>0</exchange_rate1>
    <exchange_rate2>0</exchange_rate2>
    <debit_quantity>0</debit_quantity>
    <primary_debit_amount>0</primary_debit_amount>
    <secondary_debit_amount>0</secondary_debit_amount>
    <natural_debit_currency>0</natural_debit_currency>
    <credit_quantity>0</credit_quantity>
    <primary_credit_amount>0</primary_credit_amount>
    <secondary_credit_amount>0</secondary_credit_amount>
    <natural_credit_currency>0</natural_credit_currency>
    <auxiliary_accounting>
     <item name="a">a</item>
     <item name="b">b</item>
     <item name="c">c</item>
    </auxiliary_accounting>
    <bill_type>b</bill_type>
    <bill_id>b</bill_id>
    <bill_date>b</bill_date>
    <detail>b</detail>
    <free1>b</free1>
    <freeitem1>b</freeitem1>
    <freeitem2>b</freeitem2>
    <freeitem3>b</freeitem3>
    <freeitem4>b</freeitem4>
    <freeitem5>b</freeitem5>
    <freeitem6>b</freeitem6>
    <freeitem7>b</freeitem7>
    <freeitem8>b</freeitem8>
    <freeitem9>b</freeitem9>
    <freeitem10>b</freeitem10>
    <otheruserdata>
     <cashflowcase>
      <money>0</money>
      <moneyass>0</moneyass>
      <moneymain>0</moneymain>
      <pk_cashflow>b</pk_cashflow>
     </cashflowcase>
    </otheruserdata>
    <subjfreevalue>
     <subjfreevalue1>b</subjfreevalue1>
     <subjfreevalue2>b</subjfreevalue2>
     <subjfreevalue3>b</subjfreevalue3>
     <subjfreevalue4>b</subjfreevalue4>
     <subjfreevalue5>b</subjfreevalue5>
    </subjfreevalue> 
   </entry>
   <entry>
    <entry_id>3</entry_id>
    <account_code>c</account_code>
    <abstract>c</abstract>
    <settlement>c</settlement>
    <document_id>c</document_id>
    <document_date>2008-01-01</document_date>
    <currency>c</currency>
    <unit_price>0</unit_price>
    <exchange_rate1>0</exchange_rate1>
    <exchange_rate2>0</exchange_rate2>
    <debit_quantity>0</debit_quantity>
    <primary_debit_amount>0</primary_debit_amount>
    <secondary_debit_amount>0</secondary_debit_amount>
    <natural_debit_currency>0</natural_debit_currency>
    <credit_quantity>0</credit_quantity>
    <primary_credit_amount>0</primary_credit_amount>
    <secondary_credit_amount>0</secondary_credit_amount>
    <natural_credit_currency>0</natural_credit_currency>
    <auxiliary_accounting>
     <item name="a">a</item>
     <item name="b">b</item>
     <item name="c">c</item>
    </auxiliary_accounting>
    <bill_type>c</bill_type>
    <bill_id>c</bill_id>
    <bill_date>c</bill_date>
    <detail>c</detail>
    <free1>c</free1>
    <freeitem1>c</freeitem1>
    <freeitem2>c</freeitem2>
    <freeitem3>c</freeitem3>
    <freeitem4>c</freeitem4>
    <freeitem5>c</freeitem5>
    <freeitem6>c</freeitem6>
    <freeitem7>c</freeitem7>
    <freeitem8>c</freeitem8>
    <freeitem9>c</freeitem9>
    <freeitem10>c</freeitem10>
    <otheruserdata>
     <cashflowcase>
      <money>0</money>
      <moneyass>0</moneyass>
      <moneymain>0</moneymain>
      <pk_cashflow>c</pk_cashflow>
     </cashflowcase>
    </otheruserdata>
    <subjfreevalue>
     <subjfreevalue1>b</subjfreevalue1>
     <subjfreevalue2>b</subjfreevalue2>
     <subjfreevalue3>b</subjfreevalue3>
     <subjfreevalue4>b</subjfreevalue4>
     <subjfreevalue5>b</subjfreevalue5>
    </subjfreevalue>
   </entry>
  </voucher_body>

</ufinterface>

我将上面的xml文件做为xml列表导入EXCEL后,再点击右键->xml->导出时出现如下提示,无法导出,请教大家如何解决?
"列表中的列表"
"不能保留映射的元件与其他元件的关系"

W 3 C h i n a ( since 2003 ) 旗 下 站 点
苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》
 46.875ms