in reply to Re^2: New Spreadsheet
in thread New Spreadsheet

If you're using a browser, then there is no reason to create a file on your server, then serving that file. You can stream the buffer to the web browser.

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Replies are listed 'Best First'.
Re^4: New Spreadsheet
by tc1364 (Beadle) on Dec 08, 2004 at 20:06 UTC
    I am not really sure about what you have mentioned because this is my first time doing anything with the web. My time has pend spent crunching and formating data (middle person). The data is already on the server but needs to be put together in a spreadsheet so that my client's client's can review from the web.
[reply]
      Reading the docs for Spreadsheet::WriteExcel, I find: 
      For CGI programs you can also use the special Perl filename '-' which 
+will
redirect the output to STDOUT:

    my $workbook  = Spreadsheet::WriteExcel->new('-');

See also, the cgi.pl program in the examples directory of the distro.

      [download]

      Excel::Template provides the output() method (similar to HTML::Template) which, with the appropriate Content-Type declaration, will allow for streaming straight to the web.

      Being right, does not endow the right to be rude; politeness costs nothing.
      Being unknowing, is not the same as being stupid.
      Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
      Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

[reply]
[d/l]

In Section Seekers of Perl Wisdom