Re: Output to an Excel Document

If your spreadsheet is quite simple, you could just output it as a tab delimitted file with a suffix Excel knows about (xsl?). Excel does a very good job of auto-magically converting tab delimitted files.

-derby

Comment on Re: Output to an Excel Document

Replies are listed 'Best First'.
Re: Re: Output to an Excel Document by thor (Priest) on Mar 12, 2003 at 13:22 UTC
I dunno about xls, but I know that csv will work. thor	[reply]
Re: Re: Output to an Excel Document by joe++ (Friar) on Mar 13, 2003 at 12:22 UTC
Agreed, just be careful if fields starting with a double quote which is not matched later on. This starts an ad-hoc interpretation of the rest of the file as CSV... I was bitten by this just recently. Of course a simple regex will help in this case (pseudo code): `for each $field { $field =~ s/^"//; }` [download] -- Cheers, Joe	[reply] [d/l]