| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 802 人关注过本帖
标题:EXCEL转换成XML
只看楼主 加入收藏
Csharp屌丝
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2012-6-20
收藏
 问题点数:0 回复次数:1 
EXCEL转换成XML
有一个问题困扰我好几天了,求大神指点
我现在需要把一个EXCEL按一个XML模版的格式转换成对应的XML
excel部分内容如下,表完全没有按照单元格去填
                                                                                                                                                                                               

*** PURCHASE ORDER ***                                                            INVOICE TO:                                                                                    *** PURCHASE ORDER ***                                               

                                                                                                                                                                                               

                        Hardee County School Board                                                                                                                                                                       

                                                                                                                                                                                               

                        P.O. Box 1678                                                                                                                                                                       

                        Wauchula, FL  33873                                                                                                                                                                       

                        Phone:  863-773-9058    Fax:  863-773-4673                                                                                                                                                                       

                                                                                                                                                                                               

SHOW PO NUMBER ON ALL SHIPPING CONTAINERS,                                                                                                                                            PO NUMBER:                            12F-000099                       

                                                                                                                                                                                               

PACKING LISTS, INVOICES AND CORRESPONDE                                                                                                                                                PO DATE:                        08/01/2011                       

                                                                                                                                                                                               

VENDOR:                            ULLRICHS PITCHER PUMP                                                                    2731                                                    PAGE:                    Page 1 of 1                       

                                                                                                                                                                                               

PO AMOUNT:                            4,800.00                                                                                                TIMES PRINTED:                                            3                       

                                                                                                                                                                                               

STATUS AND DATE:                                        Reencumbered                                    01/12/2012                                                                PO EXPIRES:                                    10/30/2011               

                                                                                                                                                                                               

        ULLRICHS PITCHER PUMP                                                                            2731                                SHIP TO:                                FOOD SERVICE - CENTRAL                                          

                                                                                                                                                                                               

        WATER CONDITIONING SERVICE                                                                                                                                                                                       

                                                                                                                                                                                               

                                                                                                                    1009 NORTH 6TH AVENUE                                                                           

        409 GOOLSBY STREET                                                                                                                                                                                       

                                                                                                                    Wauchula FL 33873                                                                           

        Wauchula FL 33873                                                                                                                                                                                       

                                                                                                                    United States                                                                           

        United States                                                                                                                                                                                       

                                                                                                                                                                                               

                                                                                                                                                                                               

                                                                                                    PHONE:                    (863)773-9058                                    FAX:                (863)773-0069                  

                                                                                                    EMAIL:                                                                                          

                                                                                        ATTENTION:                                Barbara Jernigan                                                                       

                                                                                                                                                                                               

                                                                    DELIVERY DATE:                                                    8/1/2011                                                                       
要求的输出格式如下,汉字忽略
<?xml version="1.0" encoding="utf-8" ?>
<PO_Data 01/08/2011>
  <Vendors>
    <Vendor Vendor_Number="">
      <Name1></Name1>
      <Name2></Name2>
      <Contact></Contact>契约
      <Phone></Phone>
      <Address1></Address1>
      <Address2></Address2>
      <Address3></Address3>
      <City></City>
      <State></State>
      <Zip></Zip>
      <Country></Country>
      <Category></Category>
      <DUNS></DUNS>
      <Misc>
        <Field1></Field1>领域
        <Field2></Field2>
        <Field3></Field3>
      </Misc>
    </Vendor>
  </Vendors>
  <POs>

求大神指点啊,给点思路,最好详细点,不胜感激
搜索更多相关主题的帖子: 格式转换 EXCEL 
2012-06-20 12:24
Csharp屌丝
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2012-6-20
收藏
得分:0 
EXCEL的表没弄好,给你们看一个图片吧
图片附件: 游客没有浏览图片的权限,请 登录注册
2012-06-20 12:26
快速回复:EXCEL转换成XML
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.021070 second(s), 10 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved