Re: Reading Excel spreadsheet into variables

2006-08-29 Thread Emil Perhinschi
I don't know about Win32::OLE, but you could use Data::Dumper to print $everything to STDERR and see how it looks inside. print STDERR Dumper $everything; On Mon, 28 Aug 2006 18:43:35 -0400 [EMAIL PROTECTED] (Stephan Gross) wrote: I'm reading in an Excel spreadsheet using Win32::OLE. I

RE: Reading Excel spreadsheet into variables

2006-08-29 Thread Timothy Johnson
One more thing: If you're not already doing so, you should probably start putting use strict; use warnings; at the top of your scripts. It will be a pain in the short term but will help you out later on. -Original Message- From: Stephan Gross [mailto:[EMAIL PROTECTED] Sent:

RE: Reading Excel spreadsheet into variables

2006-08-28 Thread Timothy Johnson
$everything is a scalar reference to an array. You can dereference the array with the '@$everything' notation or the '@{$everything}' notation. (The second one removes any ambiguity about the reference, but 99% of the time the first way is okay.) You can access elements of the array by either