in reply to Re: automatically change line with Perl Win32::OLE (give us a snipplet)
in thread Automatically change line with Perl Win32::OLE

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
  • Comment on Re: Re: automatically change line with Perl Win32::OLE (give us a snipplet)