• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Excel documents with WO and POI
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

  • Prev by Date: RE: Newbie: NonDirect Java - Using Popup Menus in Nib Files
  • Next by Date: Re: sybase Integration With WO
  • Previous by thread: Can't See Latest Messages
  • Next by thread: WO and Sybase Intergration Solved
  • Index(es):
    • Date
    • Thread