Enter data into cell of an existing excel spreadsheet

[JustKIDn]

Hi all,

Can someone tell me how to use Perl to enter data into an EXISTING excel spreadsheet?

I've looked at Speadsheet::WriteExcel but it's only for new files.

I need to take info from a flat file and plug the data into a cell in excel.

I can get the info from the one file. And if this was a new file I was creating, I could use Spreadsheet::WriteExcel to plug the data into the right cells.

Help!

tgus

 

[macwill]

Hi,
I think you can do this with Win32::OLE . Actually I am pretty sure of it I just have never done it.

check this page out

http://aspn.activestate.com/ASPN/Reference/Products/ActivePerl/faq/Windows/ActivePerl-Winfaq12.html

hope this helps
mac
P.S. if you know anything about parallel ports and perl please help!!!

 

[JustKIDn]

Thanks mac

Unfortunately, I ended up having to do it in an excel macro.

Perl would have been much less code.

I know a little about Perl and a bit about parallel ports. But I'm not sure I can put them together.

I will look into that Win32::OLE thing sometime.

tgus