Re^4: Reading Variables in Excel Spreadsheet

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?

Comment on Re^4: Reading Variables in Excel Spreadsheet

Replies are listed 'Best First'.
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
In depends on the Scope of the named range, either Workbook or Worksheet. If they are all Workbook scope and therefore unique the name is sufficient. If Worksheet specific then add the sheetname ie `Sheet1!name` Read more... (2 kB) In Excel use Formulas->NameManager to see the details poj	[reply] [d/l] [select]