This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
divya chamarti
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

you can download from this url

http://apache.oss.eznetsols.org/jakarta/poi/release/bin/
 
divya chamarti
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3640
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
which one POI or jxl.write.*
 
GS Chidam
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
for POI, Chetan Parekh mentioned url, just refer that.
 
divya chamarti
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 24208
35
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic