Results 1 to 4 of 4
  1. #1
    only1vivek is offline Member
    Join Date
    Jul 2014
    Posts
    2
    Rep Power
    0

    Default Excel to XML Conversion

    Hi,
    I want to convert Excel to XML which should include text as well as images, shapes ect.
    There is any way we can get openxml (Office Open XML) using POI API ?

    I can able to get xml using Save As option with type "XML Spreadsheet 2003". But its only help to transform text where I m interested in images or at least its location.

    Can any one guide?

    Thanks.

  2. #2
    gimbal2 is online now Just a guy
    Join Date
    Jun 2013
    Location
    Netherlands
    Posts
    4,098
    Rep Power
    6

    Default Re: Excel to XML Conversion

    How does one "convert" binary data such as an image to textual XML?
    "Syntactic sugar causes cancer of the semicolon." -- Alan Perlis

  3. #3
    only1vivek is offline Member
    Join Date
    Jul 2014
    Posts
    2
    Rep Power
    0

    Default Re: Excel to XML Conversion

    I don't want image data in xml but at least its indicating position.
    As I understand POI internally use openxml while processing excel.
    Is there any way to read this xml ?

  4. #4
    gimbal2 is online now Just a guy
    Join Date
    Jun 2013
    Location
    Netherlands
    Posts
    4,098
    Rep Power
    6

    Default Re: Excel to XML Conversion

    Sure. SAX, STAX, JAXP, XPATH, plenty of existing XML technologies available to help you fetch data from an XML document. Its only a Google away.
    "Syntactic sugar causes cancer of the semicolon." -- Alan Perlis

Similar Threads

  1. Excel to Html Conversion using apache poi library
    By agastheswar in forum New To Java
    Replies: 5
    Last Post: 05-09-2014, 11:28 AM
  2. Replies: 0
    Last Post: 01-10-2013, 08:55 AM
  3. Replies: 0
    Last Post: 01-24-2012, 12:58 PM
  4. Replies: 0
    Last Post: 09-22-2011, 12:02 PM
  5. Replies: 0
    Last Post: 10-29-2010, 11:25 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •