$worksheet->write('3' , '0', '=Results.xls!D4' );
#                 row4  columnA
[download]

That's a good reply. Just a few additional points.

You can install the latest version of Spreadsheet::WriteExcel via PPM as follows:

    C:\> ppm
    PPM> set repository tmp http://homepage.eircom.net/~jmcnamara/perl
    PPM> install Spreadsheet-WriteExcel
    PPM> quit
    C:\>
[download]

Occasionally this won't work and you will have to do the following:     PPM>install http://homepage.eircom.net/~jmcnamara/perl/Spreadsheet-WriteExcel.ppd

it seems the tar.gz is faulty for Spreadsheet::Write. I had a problem in both the Perl Tar module and WinZip.

That's strange. I've never had problems installing the module via perl -MCPAN -e shell.

Also, I can untar the distro using Unix tar or WinZip without problems.

--
John.

Thanks for your advice. As you assumed, as I wrote the code at work, I referred to the most recent documentation from cpan and when I installed it at home I installed the older version from active state, unbeknown to my less observant self.
Thanks heaps for your great advice.
Gerard

While you could try Win32::OLE if you are on a Windows platform with Excel installed, you might have an easier time of it if you use Spreadsheet::ParseExcel to read the cells you want from the original spreadsheet, then just create a new workbook with Spreadsheet::WriteExcel, inserting the cells you want to keep, no formulas required.

A final note on your actual code: besides the usual use strict; and use warnings; (or -w as your version allows) admonitions, I'd suggest you use the write($row, $col, $formula) method format, as then you don't need to do any string manipulation to create the Excel-style cell names in your loop.

Update: I had no trouble at all using WinZip to install the latest tar.gz distribution from CPAN.

--
I'd like to be able to assign to an luser