Hello AE1602,

Welcome to the Monastery. Can you show us your code that the script is failing?

From the error BEGIN failed--compilation aborted at ./CreInventoryFromExcel.pl line 35. is complaining for line 35. On your sample of code the Begging is on line 3.

Update: See sample of code bellow this assumption is not correct.

From a quick view are you sure that push(@INC, $ENV{'PWD'}."/lib"); runs the same on WindowsOS and LinuxOS? Do you mean pwd on LinuxOS maybe?

Sample:

$ PWD PWD: command not found $ pwd /home/user
#!/usr/bin/perl use strict; use warnings; print "\$ENV{PWD} is:\t" . $ENV{PWD} . "\n"; __END__ $ perl test.pl $ENV{PWD} is: /home/user

Also you do need to use #!/usr/bin/perl -w the -w on your shebang while you use use warnings.

I assume that your code is running on WindowsOS but not on LinuxOS. Taken in consideration this assumption be aware that 6 Ways the Linux File System is Different From the Windows File System LinuxOS is case sensitive and WindowsOS is not. Double check the file names and please prepare a small sample of executable script that demonstrates the problem. We can not replicate your problem based on the given information.

I would recommend prepare a small dir that you import and from there load one module that simply reads the excel file. If this works then the rest should work.

Looking forward to your update.

BR / Thanos

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

In reply to Re: Read Excel file via Perl by thanos1983
in thread Read Excel file via Perl by AE1602

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.