What I'm trying to do is make my new boss happy! They like everything in Excel.
I have a BUNCH of CGI scripts on a SUN Unix generating tons of very nice HTML pages from data in an Oracle database.... I "need" to alternately be able to generate the same pages in an Excel spreadsheet... Any thoughts would be greatly appreciated... Thanks, jwm -----Original Message----- From: Wiggins d Anconia [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 1:51 PM To: Moon, John; CGI Beginners Subject: Re: document type = application/vnd.ms-excel > I am trying to generate a web page with : > print $q->header("application/vnd.ms-excel"), > > This tries to launch Excel but I get the error: > "File cannot be opened because: A declaration was not closed Line 1, > Position 1 <" > > When I use: > print $q->header("text/html"), > > The page displays correctly and I do not see any "open" or "unclosed" > HTML... > If you print an excel header then you have to print excel formatted output, not HTML. There is no automatic conversion on either side of the connection (at least without a pretty nice plugin that I don't think has been written yet). There is a chance you could print an excel header and then output comma delimited data but I would be surprised if excel is that smart. What are you really trying to do? http://danconia.org -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>