aspose file tools*
The moose likes Other Open Source Projects and the fly likes from where to download org.apache.poi.hssf.usermodel package??????? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "from where to download org.apache.poi.hssf.usermodel package???????" Watch "from where to download org.apache.poi.hssf.usermodel package???????" New topic
Author

from where to download org.apache.poi.hssf.usermodel package???????

divya chamarti
Ranch Hand

Joined: Jul 28, 2006
Posts: 56
can any body tell me from where to download org.apache.poi.hssf.usermodel package ??? which i want to use to create a xl sheet by making use of java class or is there any other method to create exel sheet my a java class???
please help me
i wil be greatfull if any site for this particular topic will be mention
thanks in advance
GS Chidam
Ranch Hand

Joined: Jul 07, 2006
Posts: 34
Hi

you can download from this url

http://apache.oss.eznetsols.org/jakarta/poi/release/bin/
divya chamarti
Ranch Hand

Joined: Jul 28, 2006
Posts: 56
Thanks a lot!!! GS Chidam
can you tell me this package can be use for creating .xl sheet by making use of java class
regards
GS Chidam
Ranch Hand

Joined: Jul 07, 2006
Posts: 34
You can use

jxl.write.*

using this you can export to excel.

some thing like this

response.setContentType("application/vnd.ms-excel;charset=UTF-8");
response.setHeader("Content-Disposition", "attachment;filename=excelfilename.xls");
WritableWorkbook w = Workbook.createWorkbook(response.getOutputStream());

WritableSheet s = w.createSheet("worksheetname", 0);

WritableFont wfTitle = new WritableFont(
WritableFont.ARIAL, 14);
Label l1;

WritableCellFormat cfTitle = new WritableCellFormat(wfTitle);
l1= new Label(0,0,"abc",cfTitle);
s.addCell(l1);
Chetan Parekh
Ranch Hand

Joined: Sep 16, 2004
Posts: 3636
Divya you can generate .xls file using POI.

Check below article for how to do that.

Learn to Read and Write Microsoft Excel Documents with Jakarta's POI


My blood is tested +ve for Java.
divya chamarti
Ranch Hand

Joined: Jul 28, 2006
Posts: 56
GS Chidam can you tell me some links to study bit more for this particular topic? and the moreover the above listed methos can we use from a simple java class instead of web based application(i mean instead of making use of jsp/servlet/struts)???
GS Chidam
Ranch Hand

Joined: Jul 07, 2006
Posts: 34
which one POI or jxl.write.*
GS Chidam
Ranch Hand

Joined: Jul 07, 2006
Posts: 34
for POI, Chetan Parekh mentioned url, just refer that.
divya chamarti
Ranch Hand

Joined: Jul 28, 2006
Posts: 56
thanks to GS Chidam and to chetan!!!
for jxl.write can you tell me some link???
and which one is better for Java Language?
regards
GS Chidam
Ranch Hand

Joined: Jul 07, 2006
Posts: 34
hi

Actually you are refer this link, you will get clear idea,
choose any one.

http://www.rgagnon.com/javadetails/java-0516.html

thanks
Chidambaram GS
divya chamarti
Ranch Hand

Joined: Jul 28, 2006
Posts: 56
Chidambaram GS !!!
i'll refer to the sites that you people have refer to me for this particular topic , if in case any dificullty i will find out i'll get back to you people
regards
Ernest Friedman-Hill
author and iconoclast
Marshal

Joined: Jul 08, 2003
Posts: 24187
    
  34

As this is not a Java language question, let alone an advanced one, and as we have neither a Google forum nor an Excessive Punctuation forum, I'll move this to our "Other Open-Source Projects" forum, where questions about random third-party open-source libraries belong.


[Jess in Action][AskingGoodQuestions]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: from where to download org.apache.poi.hssf.usermodel package???????