Article View: borland.public.jbuilder.java.api
Article #1627Re: build a excel file
From: Jonathan Sachs
Date: Thu, 08 Nov 2001 14:17
Date: Thu, 08 Nov 2001 14:17
24 lines
2341 bytes
2341 bytes
"Florent PALISSON" <florent.palisson@atosorigin.com> wrote: >I would like to know if someone understands the method to generate >a excel file in Java. One large constraint would be that the Web server >is under UNIX. I haven't done this with Java or with Excel, but I've been through the mill with other platforms and Word. The brief answer is, you don't. Microsoft's Office document formats are so complex that attempting to generate them is ill-advised. You could implement a rather small subset that meets the needs of your application. Microsoft does not consider these file formats public, though, and is liable to make unannounced changes that break your code. There are some viable alternatives. You can write a file in comma-delimited form if you don't need formatting, or in RTF if you do, and convert it at the other end. Or you can write an application that creates a data file in your own format, and write an Excel macro that reads the file and "types" the contents into a spreadsheet. If you need to automate the process, concentrate on ways to automate the conversion within Excel. Send email to jsachs177 at earthlink dot net.
Technical Details
Message-ID:
<p74lutgbjiqpqq7nknd8ee70natfpescvi@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed1.earthlink.net!newsfeed.earthlink.net!newsmaster1.prod.itd.earthlink.net!newsread2.prod.itd.earthlink.net.POSTED!not-for-mailReferences:
<3bea77c8$1_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 1089d0,50b5daef2e58f7e7 X-Google-Attributes: gid1089d0,public X-Google-ArrivalTime: 2001-11-08 06:17:08 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed1.earthlink.net!newsfeed.earthlink.net!newsmaster1.prod.itd.earthlink.net!newsread2.prod.itd.earthlink.net.POSTED!not-for-mail From: Jonathan Sachs <nobody@nospam.net> Newsgroups: borland.public.jbuilder.java.api Subject: Re: build a excel file Organization: Sand River Software, Inc. Reply-To: See@Message.Text Message-ID: <p74lutgbjiqpqq7nknd8ee70natfpescvi@4ax.com> References: <3bea77c8$1_1@dnews> X-Newsreader: Forte Agent 1.7/32.534 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 24 Date: Thu, 08 Nov 2001 14:17:13 GMT NNTP-Posting-Host: 66.1.132.83 X-Complaints-To: abuse@earthlink.net X-Trace: newsread2.prod.itd.earthlink.net 1005229033 66.1.132.83 (Thu, 08 Nov 2001 06:17:13 PST) NNTP-Posting-Date: Thu, 08 Nov 2001 06:17:13 PST X-Received-Date: Thu, 08 Nov 2001 06:13:04 PST (newsmaster1.prod.itd.earthlink.net)