-----Original Message----- From: Wiggins d Anconia [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 3:03 PM To: Moon, John; CGI Beginners Subject: RE: What are you really trying to do? - document type = applicat ion/vnd.ms-excel
Gotcha, please bottom post... > What I'm trying to do is make my new boss happy! They like everything in > Excel. > Picky picky ;-)... manglement (as drieux would say) has its quirks. > 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... > Which absolutely cracks me up, but doesn't surprise me. > Any thoughts would be greatly appreciated... > I haven't used them before, but you may want to look into: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/WriteExcel.pm http://search.cpan.org/~tmtm/Spreadsheet-WriteExcel-FromDB-0.09/lib/Spreadsh eet/WriteExcel/FromDB.pm Presumably your CGI can use one of the above to generate the file on the fly then just print your header and the contents of the file, you may even be able to bypass the local temp storage but I didn't check real closely. Good Luck, http://danconia.org > > -----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> > > > Thanks to all who replied. Looks like I start writing duplicate programs... jwm -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
