Re: automatically change line with Perl Win32::OLE (give us a snipplet)

Hi Anonymous!

Could someone help me with a method to let the writing automatically change lines as write "\n" to a text file?

I'd love to help, but I simply don't understand what you want (maybe is it my English -- or yours ;)? Give use a code snipplet (snipplet, I said) of what you accomplished so far, to work with. Then we can comment/modify it to suit your needs. Also sample data will help us help you.

I'm just guessing now, but maybe Storable is what you're looking for.

So long
Flexx

Comment on Re: automatically change line with Perl Win32::OLE (give us a snipplet)

Replies are listed 'Best First'.
Re: Re: automatically change line with Perl Win32::OLE (give us a snipplet) by Anonymous Monk on Sep 14, 2002 at 14:51 UTC
Dear Monks, Thank you for the help. What I really mean is: when next time I go to the excel file I have been writing, I want to automatically write to the next line immediately following all the contents I have finished. I have found a method : my $lnLastRow = $loXlw->WorkSheets('KeyWord')->Cells(1,1)->End(xlDown)->{Row}; which gives you the number of lines already existing in the Excel file. It is kind of what I need cuz I just need to increment the row number and write to it. Besides, I checked the perldoc thing. I have seen the html format of it. It is not what I have been looking for, it does not cover all the possible methods that can be found, like the last one, it is not there. Do they have a java like API that covers all the possible methods or oreilly's perl that explains every methods and the syntax of it? Thank you for all the help. ginger	[reply]

Replies are listed 'Best First'.

Re: Re: automatically change line with Perl Win32::OLE (give us a snipplet)
by Anonymous Monk on Sep 14, 2002 at 14:51 UTC

Dear Monks, Thank you for the help. What I really mean is: when next time I go to the excel file I have been writing, I want to automatically write to the next line immediately following all the contents I have finished. I have found a method : my $lnLastRow = $loXlw->WorkSheets('KeyWord')->Cells(1,1)->End(xlDown)->{Row}; which gives you the number of lines already existing in the Excel file. It is kind of what I need cuz I just need to increment the row number and write to it. Besides, I checked the perldoc thing. I have seen the html format of it. It is not what I have been looking for, it does not cover all the possible methods that can be found, like the last one, it is not there. Do they have a java like API that covers all the possible methods or oreilly's perl that explains every methods and the syntax of it? Thank you for all the help. ginger

[reply]