All,
I would like to be able to open a spreadsheet and assign a range of
values to an array. Is there an easy way to do this? I understand how
to assign an array of values to a range, but it doesn't seem to work
the other way. There is no problem with assigning a cell value to a
variable but having trouble with assigning a range of values to an
array.
$application = Win32::OLE->new('Excel.Application','Quit');
$file = "\\\\servername\\share\\spreadsheet.xls";
$book = $application->Workbooks->Open($file);
$sheet = $book->Worksheets("RoleMatrix");
#
## Arrays
#################################
$range = $sheet->Range("Range");
@usermenu = $range->{Value};
Any help would be great!
Thanks,
DaveB
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-admin
