in reply to New Spreadsheet

First, why not use Excel::Template?

Second, -r checks to see if it's readable by you, not if it exists or is a file. I would use -e or -f, not -r.

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^2: New Spreadsheet
by tc1364 (Beadle) on Dec 08, 2004 at 18:57 UTC
    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?
      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.
      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.