in reply to Re: Excel File Problem
in thread Excel File Problem

Thanks, that seems to work much better. So I need to close the workbook after I write to it in order to save the changes? The write dosen't work even with the or fixed unless I close the workbook. Is there a way to continue editing the workbook (allow for multiple URLs to be used) after the write?

Replies are listed 'Best First'.
Re^3: Excel File Problem
by liverpole (Monsignor) on May 20, 2006 at 16:12 UTC
    You can read the the documentation, but I'm guessing you will need to close the workbook before the changes take effect.  So your choices are probably limited to:

    1. Closing the workbook at end of the program
    2. Closing it after writing, and (if need be) reading it back with Spreadsheet::ParseExcel.

    s''(q.S:$/9=(T1';s;(..)(..);$..=substr+crypt($1,$2),2,3;eg;print$..$/