Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

read an excel file in .xlsx format

 
anvi kon
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is it possible to read an excel file in .xlsx format not xls format using JXL?

Please send me some examples .


thanks
 
Paul Clapham
Sheriff
Pie
Posts: 20958
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It tells you the answer to that question right on the project's home page: http://jexcelapi.sourceforge.net/
 
jammy chen
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


use above getting a try or read the offical reference guide from the project url http://jexcelapi.sourceforge.net/
 
Rob Spoor
Sheriff
Pie
Posts: 20511
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
metin lapo
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic