Results 1 to 4 of 4

Thread: Using StarOffice Java API to read Excel format

  1. #1
    Join Date
    Apr 2010
    Posts
    52

    Using StarOffice Java API to read Excel format

    I would like to work with the StarOffice Java API to read out the Excel format and output to common and absolute XML format, just as the "<sheet><row><cell>a</cell>...". This is to be one of the section of the server-side batch import process of a J2EE based application.

    Do you have any idea with the proper demonstration to do this ? Also, if this could be performed , can this be performed so that so GUI don't need to be functional ?Do you have any suggestion ..

  2. #2
    Join Date
    Apr 2008
    Posts
    2,565

    Re: Using StarOffice Java API to read Excel format

    Yeah , it is possible to do , there is one of the way through which you can do it and for opening and read the values in the excel, you can implement the poi.apache in your code. I have just downloaded the jar file and stat using this jar files specified for POI is poi-contrib-3.0-rc4-20070503.jar, poi-scratchpad-3.0-rc4-20070503.Jar and poi-3.0-rc4-20070503.jar. There is different Jar file jxl.jar that is use for access the excel.

  3. #3
    Join Date
    Jan 2006
    Posts
    3,792

    Re: Using StarOffice Java API to read Excel format

    When getting the excel file, the demo programs may be used "as is" to convert the Excel files to CSV and XML formats in a reasonable method.

    java -jar jxl.jar -csv myspreadsheet.xls

    To get the view of Excel file as XML, obtain the demo as specified.

    java -jar jxl.jar -xml myspreadsheet.xls

    In order to show up the data, the demo uses the classes xlrd/CSV.java and xlrd/XML.java in the same way. For more reliable processing, these classes can be used as the beginning point.

  4. #4
    Join Date
    May 2008
    Posts
    2,945

    Re: Using StarOffice Java API to read Excel format

    The write demo described the functionality retrieval within the JExcelApi to create the excel sheet. The spreadsheet created by the demo contains several fonts, number formatting, date formatting, colours and borders. For generating the the demo spreadsheet, retrieve the JExcelApi as suggested below:

    Code:
    java -jar jxl.jar -write myspreadsheet.xls
    This will create the demo spreadsheet known myspreadsheet.xls in the present working directory. The class is being used to create this spreadheet is jxl/Write.java. It can be used as a beginning point for bespoke processing.

Similar Threads

  1. Cell format errors appears in Excel 2003 but not in Excel 2000
    By @nki$achi in forum MS Office Support
    Replies: 1
    Last Post: 24-01-2012, 05:00 PM
  2. does PS3 read MP4 format?
    By Zadora's in forum Portable Devices
    Replies: 6
    Last Post: 08-06-2011, 03:49 PM
  3. Parameter format not correct in command Prompt Read Only
    By LoknathT in forum Operating Systems
    Replies: 5
    Last Post: 19-10-2010, 02:52 AM
  4. Java will not read input
    By rACHAEL in forum Software Development
    Replies: 5
    Last Post: 16-10-2010, 09:40 AM
  5. Vista cannot read UDF file format
    By GANGSTA in forum Operating Systems
    Replies: 3
    Last Post: 24-04-2009, 08:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,841,394.90481 seconds with 17 queries