[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: Exporting data to an excel spreadsheet
- To: <email@example.com>
- Subject: RE: Exporting data to an excel spreadsheet
- From: <Vikrant.Verma@alltel.com>
- Date: Wed, 20 Nov 2002 09:22:21 -0600
- Thread-Index: AcKQH2guWqOIzjbmS/i45P5z6ubPGQAh+uaQ
- Thread-Topic: Exporting data to an excel spreadsheet
this is a very old trick and will work. If the required final output is a tabular report.
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.
From: Henri Yandell [mailto:firstname.lastname@example.org]
Sent: Tuesday, November 19, 2002 6:00 PM
To: gregory lawson
Cc: JXNie@ups-scs.com; email@example.com; firstname.lastname@example.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