«

QUESTION:
What options are available for writing a very simple Excel file from Java?

BACKGROUND:
My application requires minimal formatting beyond what a delimited CSV file
could support:
* Colored header row.
* Some "text" cells (some numbers must retain leading zeroes).
* Reasonably sized columns (could be static width by column).

I would like to keep everything as vanilla as possible (i.e., simple code,
no third-party utilities, etc.).

FYI, I am currently using HTML, but Excel 2000 takes 15-minutes to open an
HTML table with about 3,000 rows and 30-columns. When saved as a true Excel
file, Excel opens that file in under 1-second.

Thanks for any help!

Dave

http://jakarta.apache.org/poi/index.html


David McCulloch schrieb:
> QUESTION:
> What options are available for writing a very simple Excel file from Java?
>
> BACKGROUND:
> My application requires minimal formatting beyond what a delimited CSV file
> could support:
> * Colored header row.
> * Some "text" cells (some numbers must retain leading zeroes).
> * Reasonably sized columns (could be static width by column).
>
> I would like to keep everything as vanilla as possible (i.e., simple code,
> no third-party utilities, etc.).
>
> FYI, I am currently using HTML, but Excel 2000 takes 15-minutes to open an
> HTML table with about 3,000 rows and 30-columns. When saved as a true Excel
> file, Excel opens that file in under 1-second.
>
> Thanks for any help!
>
> Dave
>
>

On Sat, 5 Jun 2004 12:39:14 -0500, "David McCulloch" <|@|.|> wrote or
quoted :

>QUESTION:
>What options are available for writing a very simple Excel file from Java?

see http://mindprod.com/jgloss/excel.html it will point you to:


see http://mindprod.com/products.html#CSV for a class to write simple
comma-separated variable files.

To write spreadsheets with embedded formulae, see
http://mindprod.com/jgloss/poi.html


--
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming.
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.

For a "very simple" excel file, all you need to do is set your delimiter to
tabs ('\t') instead of commas, and save the file with an .xls extension.

bort

"David McCulloch" <|@|.|> wrote in message
news:aynwc.37950$...
> QUESTION:
> What options are available for writing a very simple Excel file from Java?
>
> BACKGROUND:
> My application requires minimal formatting beyond what a delimited CSV
file
> could support:
> * Colored header row.
> * Some "text" cells (some numbers must retain leading zeroes).
> * Reasonably sized columns (could be static width by column).
>
> I would like to keep everything as vanilla as possible (i.e., simple code,
> no third-party utilities, etc.).
>
> FYI, I am currently using HTML, but Excel 2000 takes 15-minutes to open an
> HTML table with about 3,000 rows and 30-columns. When saved as a true
Excel
> file, Excel opens that file in under 1-second.
>
> Thanks for any help!
>
> Dave
>
>

"bort" <> wrote in message
news:wYGwc.71194$ able.rogers.com...
>
> For a "very simple" excel file, all you need to do is set your delimiter
to
> tabs ('\t') instead of commas, and save the file with an .xls extension.

nope, the OP wants color

>
> bort
>
> "David McCulloch" <|@|.|> wrote in message
> news:aynwc.37950$...
> > QUESTION:
> > What options are available for writing a very simple Excel file from
Java?
> >
> > BACKGROUND:
> > My application requires minimal formatting beyond what a delimited CSV
> file
> > could support:
> > * Colored header row.
> > * Some "text" cells (some numbers must retain leading zeroes).
> > * Reasonably sized columns (could be static width by column).
> >
> > I would like to keep everything as vanilla as possible (i.e., simple
code,
> > no third-party utilities, etc.).
> >
> > FYI, I am currently using HTML, but Excel 2000 takes 15-minutes to open
an
> > HTML table with about 3,000 rows and 30-columns. When saved as a true
> Excel
> > file, Excel opens that file in under 1-second.
> >
> > Thanks for any help!
> >
> > Dave
> >
> >
>
>