Re: Module location and Setup Error Message.

[marto]

It'd help if you told us how you downloaded and installed these modules, post formatting also makes things easier to read (How do I post a question effectively?). Since you're using Strawberry perl, why not use cpanm to do all this for you?

cpanm Module::Name

This also installs module dependencies.

[GeoPerl1877]

After trying to install the module cpanm is giving me the following messages

C:\Strawberry\Spreadsheet-Simple-1.0.0>cpan module::Spreadsheet-Simple
+-1.0.0
CPAN: LWP::UserAgent loaded ok (v6.02)
CPAN: Time::HiRes loaded ok (v1.9721)
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
CPAN: YAML loaded ok (v0.73)
CPAN: CPAN::SQLite loaded ok (v0.199)
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Database was generated on Fri, 20 Apr 2018 18:15:04 GMT
Updating database file ...

Gathering information from index files ...
Obtaining current state of database ...
Populating database tables ...
Done!
Warning: Cannot install module::Spreadsheet-Simple-1.0.0, don't know w
+hat it is.
Try the command

    i /module::Spreadsheet-Simple-1.0.0/

to find objects with matching identifiers.

Thanks for your suggestions on using cpanm to install but it's not allowing me to install for some reason

Any further suggestions would be really helpful

Please find below the style and expected output I would like , Although Not identical to the information contained within my xlxs /xls file it's the what i'm requiring

\ [
    [0] {
        error     undef,
        parser    "Spreadsheet::XLSX",
        sheet     {
            Sheet1   1
        },
        sheets    1,
        type      "xlsx",
        version   0.13
    },
    [1] {
        attr     [],
        B1       "Income Statement 2014",
        B2       "Revenue",
        B3       "Cost of goods sold",
        B4       "Gross profit",
        B5       "Financing costs",
        B6       "Tax",
        B7       "Net profit",
        cell     [
            [0] [],
            [1] [],
            [2] [
                [0] undef,
                [1] "Income Statement 2014",
                [2] "Revenue",
                [3] "Cost of goods sold",
                [4] "Gross profit",
                [5] "Financing costs",
                [6] "Tax",
                [7] "Net profit"
            ],
            [3] [
                [0] undef,
                [1] undef,
                [2] 50000,
                [3] 2500,
                [4] 47500,
                [5] 7150,
                [6] 10087.5,
                [7] 30262.5
            ]
        ],
        C2       " $ 50,000.00 ",
        C3       " $ 2,500.00 ",
        C4       " $ 47,500.00 ",
        C5       " $ 7,150.00 ",
        C6       " $ 10,087.50 ",
        C7       " $ 30,262.50 ",
        label    "Sheet1",
        maxcol   3,
        maxrow   7
    }
]
This shows that $workbook is an arrayref, whose first element describe
+s the file, and subsequent elements represent the individual workshee
+ts. The label key pair contains the worksheet name, access it like th
+is:

$workbook->[1]{label}; #Sheet1

[marto]

You're not using cpan correctly, and have not used cpanm either.

cpanm Spreadsheet::Simple

Just provide the module name.