RE: Exporting data to an excel spreadsheet

[<Vikrant.Verma@alltel.com>]

this is a very old trick and will work. If the required final output is a tabular report.

try this 
	open your faviourite text editor and create a text file. 
	use tab as a column delimiter. 
	save this file as "something.xls"
	open it in excel. Excel will open this as a proper worksheet with one tab.

It is not necessary to have a proper binary file for excel to treat it as a worksheet.
-Vikrant

-----Original Message-----
From: Henri Yandell [mailto:bayard@generationjava.com]
Sent: Tuesday, November 19, 2002 6:00 PM
To: gregory lawson
Cc: JXNie@ups-scs.com; vedulasharma@yahoo.com; ajug-members@ajug.org
Subject: RE: Exporting data to an excel spreadsheet




On Tue, 19 Nov 2002, gregory lawson wrote:

> Hello all,
>
> I thought excel spreadsheets were in a proprietary, binary format. So how
> can the browser simply save the file as *.xls ? Simply making a file
> "filename.xls" make it an excel file ?

Yeah, I dunno what the code above was doing, but it is important that the
mime type be set.

It's proprietary, but hasn't changed that much over last few years so
things like http://jakarta.apache.org/poi are more stable than might be
thought.

Hen