This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 19649
    
  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: 41060
    
  43
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: read an excel file in .xlsx format
 
Similar Threads
How to convert .xls to .xlsx and vice versa using Apache POI api
Read a .xls,.xlsx file format using XSSF
How to read .xlsx sheet from Client Side using poi 3.5
How to read xlsx file from local java file
Problem on opening .XLSX file