Re^3: Reading Variables in Excel Spreadsheet

You can read the values using the name

for my $nm (in $Book->Names){
  my $rng = $ws->Range($nm);
  printf "%s %s\n", $nm->{'Name'},$rng->{'Value'};
}
[download]

poj

Comment on Re^3: Reading Variables in Excel Spreadsheet Download Code

Replies are listed 'Best First'.
Re^4: Reading Variables in Excel Spreadsheet by Anonymous Monk on Jan 15, 2018 at 16:50 UTC
Many thanks but there is something not quite right. In the 2nd line there is $ws. What is this variable since it is not defined in the original Perl?	[reply]
Re^5: Reading Variables in Excel Spreadsheet by poj (Abbot) on Jan 15, 2018 at 16:54 UTC
`$ws` is the worksheet, do you have multiple worksheets ? poj	[reply] [d/l]
Re^6: Reading Variables in Excel Spreadsheet by merrymonk (Hermit) on Jan 15, 2018 at 17:05 UTC
In this test case no. However, in 'production' yes.	[reply]
Re^7: Reading Variables in Excel Spreadsheet by poj (Abbot) on Jan 15, 2018 at 18:01 UTC