File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other Open Source Projects and the fly likes Suggestion: need a lightweight, Java library for reading and writing to Excel files. Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Reply Bookmark "Suggestion: need a lightweight, Java library for reading and writing to Excel files." Watch "Suggestion: need a lightweight, Java library for reading and writing to Excel files." New topic
Author

Suggestion: need a lightweight, Java library for reading and writing to Excel files.

Monu Tripathi
Rancher

Joined: Oct 12, 2008
Posts: 1365

My team mate is working on a Mobile application which should be able to create, read and write excel files. He needs a lightweight Java library that can help here. He tried using JExcelAPI without much luck.

Suggestions are welcome.

Thanks.


[List of FAQs] | [Android FAQ] | [My Blog] | [Samuh Varta]
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 35240
    
    7
Define "lightweight".

Does "Mobile" mean that the underlying platform is not JSE? If not, what is it?


Android appsImageJ pluginsJava web charts
Monu Tripathi
Rancher

Joined: Oct 12, 2008
Posts: 1365

The platform is Android.

Android can run J2SE libraries (with some effort); since the applications run on a constrained device(mobile phones etc.) it is required that the imported library be small in size.

There are class libraries in Java for working with excel files. We need a stripped down version of such a library that can be used on a Mobile device.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 35240
    
    7
So the other question was also about Android, not JSE? That information would have been vital to mention.

JExcelApi is open source; it should be easy to dig into it to see why it's throwing that exception.

The core POI library is 1.5 MB in size (assuming we're talking about XLS files, not XLSX). A library like ProGuard can likely reduce that. Would that really be too much? (JExcelAPi, of course, is much smaller to begin with.)
Monu Tripathi
Rancher

Joined: Oct 12, 2008
Posts: 1365

Ulf Dittmer wrote:So the other question was also about Android, not JSE? That information would have been vital to mention.

JExcelApi is open source; it should be easy to dig into it to see why it's throwing that exception.

The core POI library is 1.5 MB in size (assuming we're talking about XLS files, not XLSX). A library like ProGuard can likely reduce that. Would that really be too much? (JExcelAPi, of course, is much smaller to begin with.)

Generally, smaller the application size, the better: by default, applications are installed in the phone memory which is only 16 MB on G1(the weakest target handset).

JExcelApi does seem like a better choice and it would be better to look into the source code and figure out the shortcoming.

Will make sure that I dont forget to mention the platform. Thanks for your reply.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Suggestion: need a lightweight, Java library for reading and writing to Excel files.
 
Similar Threads
error printing 10e1 in excel using java
CSV file opening in Excel - cell auto adjustment using JasperReports
Read Excel File
Export to excel in jsp
How to read xlsx file from local java file