Re: Excel to XML


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Re: Excel to XML

  1. #1
    Ken Myers Guest

    Re: Excel to XML


    Did you ever get an answer to this question? I am just starting to look into
    a similar requirement.

    K


    "Mohit Vaswani" <mohitvaswani@hotmail.com> wrote:
    >
    >I need to convert an Excel spreadsheet to XML.
    >
    >Any ideas would be appreciated
    >
    >Mohit



  2. #2
    sean Guest

    Re: Excel to XML


    If you only want data then
    Use ADO and Excel ODBC driver to get the data and then save to xml format

    "Ken Myers" <KenMye@Frontstep.com> wrote:
    >
    >Did you ever get an answer to this question? I am just starting to look

    into
    >a similar requirement.
    >
    >K
    >
    >
    >"Mohit Vaswani" <mohitvaswani@hotmail.com> wrote:
    >>
    >>I need to convert an Excel spreadsheet to XML.
    >>
    >>Any ideas would be appreciated
    >>
    >>Mohit

    >



  3. #3
    Brandon Forest Guest

    Re: Excel to XML


    "sean" <sean@ireland.com> wrote:
    >
    >If you only want data then
    >Use ADO and Excel ODBC driver to get the data and then save to xml format
    >
    >"Ken Myers" <KenMye@Frontstep.com> wrote:
    >>
    >>Did you ever get an answer to this question? I am just starting to look

    >into
    >>a similar requirement.
    >>
    >>K
    >>
    >>
    >>"Mohit Vaswani" <mohitvaswani@hotmail.com> wrote:
    >>>
    >>>I need to convert an Excel spreadsheet to XML.
    >>>
    >>>Any ideas would be appreciated
    >>>
    >>>Mohit

    >>

    >

    I am loading Excel 97 & 2000 spreadsheets into SQL using ADO 2.5. You can
    load an excel spreadsheet into an ADO recordset and use the recordset.save
    adPersistXML method to write it out to either disk or a stream object. Be
    aware that ADO persisted XML is attribute based, which has the schema definition
    followed by the data. This is smaller than element based, but requires an
    XSL transformation.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center