Hi all, I'm collecting system configuration and inventory informa

[d3funct]

Hi all,

I'm collecting system configuration and inventory information and formatting it for output to a .xls file. What I want to know is how can I use a perl script to automatically update the .xls file from my unix machine to my windows .xls file? Is it possible, I've heard most anything is possible with perl. Thanks for the help.

Jon [sig]<p>Jon Zimmer<br><a href=mailto:b0rg@pcgeek.net>b0rg@pcgeek.net</a><br><a href=

http://www.aetea.com>

Aetea Information Technology</a><br>The software required `Windows 95 or better', so I installed Linux.<br>
[/sig]

 

[fortytwo]

Hi Jon,

I believe that it is possible to import a comma delimited text file into excell. Unless you know how to create the structure of excell files directly it might be worth looking into this option as perl is very good IMO at creating text files. There are probably other ways, I just can't think of any

fortytwo [sig]<p>fortytwo<br><a href=mailto:will@hellacool.co.uk>will@hellacool.co.uk</a><br><a href=

http://www.hellacool.co.uk>my

test site</a><br> [/sig]

 

[goBoating]

hello d3funct,
Perl can get into (read/write) EXCEL files via the OLE module. It takes a little playing around with to figure out how to navigate inside the xls file. You might get some clues at

http://savage.net.au/Perl-tutorials.html,

tutorial number 6. [sig]<p> <br><a href=mailto: > </a><br><a href= > </a><br> keep the rudder amid ship and beware the odd typo[/sig]