Need help with Modules!

dudydude has asked for the wisdom of the Perl Monks concerning the following question:

Hi people from Perlmonks! I have a huge question. I'm in a project right now that requires me to deal with Excel spreadsheet! I have done some coding in Perl and it works perfectly bu in Windows Environment. When I try to do it in Unix system is just don't work because there is a module missing called Win32/OLE.

I downloaded the module, but my question is: Is there any way to include the package without installing it at all? If installing is a must then, is there a way to do it without being the root?!

Comment on Need help with Modules!

Replies are listed 'Best First'.
Re: Need help with Modules! by Marshall (Canon) on Jun 27, 2011 at 17:44 UTC
Win32/OLE is not going to run on your Unix system. Object Linking and Embedding (OLE) is a Microsoft technology. On the Win32 platform, you can control what Excel is doing via OLE. The same program is not possible on Unix because Excel does not run on Unix. There are modules that can manipulate a .XLS file directly. That way it is not necessary to have Excel running. Spreadsheet::WriteExcel is one of them. There could be and probably are others.	[reply]
Re^2: Need help with Modules! by Anonymous Monk on Jun 28, 2011 at 06:48 UTC
How to install Win32::OLE under Linux?	[reply]
Re: Need help with Modules! by Corion (Patriarch) on Jun 27, 2011 at 17:36 UTC
Win32::OLE will only work on Windows. Which is why it has the OS name in its module name (Win32). See Spreadsheet::ParseExcel and Spreadsheet::WriteExcel. Also, Yes, even you can use CPAN, App::cpanminus and local::lib.	[reply]
Re^2: Need help with Modules! by dudydude (Novice) on Jun 27, 2011 at 18:16 UTC
The links that you provided to me is kind of vague, they talk in general terms. To put it simple I don't even understand the half of what they are saying. If I install any of those packages then what? Then how am I supposed to include the one that I want? Thank you for your time	[reply]
Re^3: Need help with Modules! by Corion (Patriarch) on Jun 27, 2011 at 18:21 UTC
The modules allow you to do on Unix (and Windows) to manipulate Excel files. I already told you that your existing approach of reusing Excel will not work on Unix, because Excel (and the technology used to communicate with Excel) does not run on Unix. You will need to look at the modules I linked, and install those, maybe first on your Windows machine, and rework your program to use these modules. Then you will need to install these modules on your target machine(s) as well. If you feel overwhelmed by this, contact your system administrator on how to install modules.	[reply]
Re^4: Need help with Modules! by dudydude (Novice) on Jun 27, 2011 at 20:36 UTC
A reply falls below the community's threshold of quality. You may see it by logging in.