in reply to Re: New Spreadsheet
in thread New Spreadsheet

Guess what... it seems that the -r worked fine and infact the data was getting updated but I needed to close my browser and re-open it. Is there something that can be added to the code to prevent this?

Replies are listed 'Best First'.
Re^3: New Spreadsheet
by dragonchild (Archbishop) on Dec 08, 2004 at 19:42 UTC
    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.

      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.
        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.

        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.

Re^3: New Spreadsheet
by thor (Priest) on Dec 08, 2004 at 19:26 UTC
    Spreadsheet...browser? I'm not getting what one has to do with the other. Are you creating the spreadsheet through a CGI and then downloading it? Or is there some voodoo that allows one to view the contents of a spreadsheet through a browser?

    thor

    Feel the white light, the light within
    Be your own disciple, fan the sparks of will
    For all of us waiting, your kingdom will come

      The new spreadsheet is created in the directory system /web/htdocs .... so when using Internet Explorer and going to it's (new spreadsheet)URL the information is made available.