Excel documents with WO and POI
Excel documents with WO and POI
- Subject: Excel documents with WO and POI
- From: "Paul-Liviu Petrus" <email@hidden>
- Date: Thu, 20 Mar 2003 11:13:37 +0100
- Thread-topic: Generate PDF and Excel documents
Hi!
I am trying to use POI package (http://jakarta.apache.org/poi) with
WebObjects 5.1 to create a workbook, fill it with data and open it in
Excel. I'm doing something like this:
//import ...
import org.apache.poi.hssf.usermodel.*;
public WOActionResults openWorkbook()
{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet1 = wb.createSheet( "new sheet" );
HSSFSheet sheet2 = wb.createSheet( "second sheet" );
// ... load the spreadsheet with data
WOResponse response = new WOResponse();
// here the workbook should be loaded into the Response. how??
response.setHeader("application/vnd.ms-excel", "content-type");
//...
return response;
}
I can't find a way to transfer the workbook object into the Response
object and then open it. I don't need to save the excel file, only
create and open it, so that the user can save after changing it.
Anyone have a clue? Many thanks in advance.
Paul Petrus
-----Original Message-----
From: Dov Rosenberg [mailto:email@hidden]
Sent: Mittwoch, 19. Mdrz 2003 14:05
To: email@hidden
Cc: email@hidden
Subject: Re: Generate PDF and Excel documents
we started using the POI project from Jakarta Apache. It has classes to
do what you are looking for.
Dov Rosenberg
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.