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

[divya chamarti]

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]

Hi

you can download from this url

http://apache.oss.eznetsols.org/jakarta/poi/release/bin/

[divya chamarti]

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]

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]

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

[divya chamarti]

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]

which one POI or jxl.write.*

[GS Chidam]

for POI, Chetan Parekh mentioned url, just refer that.

[divya chamarti]

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]

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]

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]

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.