Re^2: Reading Variables in Excel Spreadsheet

I tried to use both the exmaples you sent. Sadly I do not have Excel::Writer with the version of Perl I use. Therefore I could not make much headway.

Comment on Re^2: Reading Variables in Excel Spreadsheet

Replies are listed 'Best First'.
Re^3: Reading Variables in Excel Spreadsheet by thanos1983 (Parson) on Jan 15, 2018 at 15:39 UTC
Hello Anonymous Monk, I assume you are the same user with merrymonk. You could install the module Excel::Writer::XLSX. In case you do not want to install the module (for any reason) you can use your own Excel sheet with the module Spreadsheet::Read to read the file and search for the value (reference) and it will return the column data. Give it a try and let me know if it works for you. BR / Thanos Seeking for Perl wisdom...on the process of learning...not there...yet!	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: Reading Variables in Excel Spreadsheet
by thanos1983 (Parson) on Jan 15, 2018 at 15:39 UTC

Hello Anonymous Monk,

I assume you are the same user with merrymonk. You could install the module Excel::Writer::XLSX.

In case you do not want to install the module (for any reason) you can use your own Excel sheet with the module Spreadsheet::Read to read the file and search for the value (reference) and it will return the column data.

Give it a try and let me know if it works for you.

BR / Thanos

Seeking for Perl wisdom...on the process of learning...not there...yet!

[reply]
[d/l]
[select]