aspose file tools*
The moose likes Java in General and the fly likes read an excel file  in .xlsx format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "read an excel file  in .xlsx format" Watch "read an excel file  in .xlsx format" New topic
Author

read an excel file in .xlsx format

anvi kon
Ranch Hand

Joined: Jan 08, 2010
Posts: 133
Is it possible to read an excel file in .xlsx format not xls format using JXL?

Please send me some examples .


thanks
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

It tells you the answer to that question right on the project's home page: http://jexcelapi.sourceforge.net/
jammy chen
Greenhorn

Joined: Aug 24, 2009
Posts: 25


use above getting a try or read the offical reference guide from the project url http://jexcelapi.sourceforge.net/


Java tutorial
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19670
    
  18

Paul Clapham wrote:It tells you the answer to that question right on the project's home page: http://jexcelapi.sourceforge.net/

And since .xlsx is Excel 2007 and that one's not mentioned, the answer is no.

Apache POI has support for Excel 2007 through XSSF.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
metin lapo
Greenhorn

Joined: Oct 05, 2012
Posts: 2
this solution involves using the zip and stax(read/write xml) api

http://www.mets-blog.com/java-read-excel-xlsx-file-part-1/

Usage:


Source

Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41508
    
  53
I wouldn't call that "a solution". The mere fact that Office 2007 formats are a zipped collection of XML files, and can be treated as such, is not at all the same as what you gain by using a library such as jExcelAPI for Office 2003 files, and POI for Office 2003 and Office 2007 files.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: read an excel file in .xlsx format