[Charudatta Joshi]

Hi friends,

 

I want to learn how to create good excel spreadsheets in a java project.

 

Can anyone suggest me where can I find good tutorials.

I have to learn it as quickly as possible.
--
Charudatta.M.Joshi

[Santhi,Jeba]

Yes,

   You can use apache POI library for creating excel spreadsheets. It's a very good one.

You can refer the apache site for this.

 

If you need the sample code please email me.

 

Thanks

Jeba

--

You received this message because you are subscribed to the Google Groups "Bangalore Open Java Users Group- BOJUG" group.
To post to this group, send email to bo...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/bojug?hl=.

--
Thanks,
Santhi

[Kiran Raja]

Yes, POI Library is the best Open Source Excel library available. 

You can get tutorials on POI on the net.

All the best

-Kiran

--

[Tushar Joshi]

Hi Charudatta,

We have used jExcelApi in one of our production code.  You may refer the tutorial [1] for the jExcelApi project [2]. 

This library supports following features as given on their site:

Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks Reads and writes formulas (Excel 97 and later only) Generates spreadsheets in Excel 2000 format Supports font, number and date formatting Supports shading, bordering, and coloring of cells Modifies existing worksheets Is internationalized, enabling processing in almost any locale, country, language, or character encoding (formulas are currently only supported in English, French, Spanish, and German, but more can be added if translated) Supports copying of charts Supports insertion and copying of images into spreadsheets Supports logging with Jakarta Commons Logging, log4j, JDK 1.4 Logger, etc ...and much more

with regards
Tushar

[1] http://www.andykhan.com/jexcelapi/tutorial.html
[2] http://jexcelapi.sourceforge.net/

==============================================
Tushar Joshi, Nagpur
MCSD_NET C#, SCJP, RHCE
Software Engineer and Senior Project Manager @ Infospectrum India Private Limited, VOC Captain for NetBeans, JUGNagpur Leader
http://www.info-spectrum.com
http://www.tusharvjoshi.com
http://wiki.netbeans.org/VoiceOfCommunity
http://www.jugnagpur.com

[Kiran Raja]

Hi,

jExcelApi too is a good excel API Library. But the disadvantage is there are not too many adopters for it. Hence when you are stuck in a issue related to jExcelApi, you dont find much help in the internet or in forums. POI is widely used by java developers so when you are stuck in any how-to issues, you can quickly find answers. So i recommend you going forward with POI Library.

Regards

Kiran