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
| [reply] |
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] |
Win32::OLE module and around contain great code examples that manipulate Excel different ways, so you should start typing perldoc Win32::OLE
Courage, the Cowardly Dog | [reply]
[d/l] |
where I may get the API of all the possible functions of Win32::OLE?
The Win32::API module itself doesn't have an extensive API. What it does is allow you yo instantiate and manipulate COM objects. So I suspect the question you're really asking is where do I get more details of the methods and properties exposed by the COM objects. Assuming you're using ActivePerl, the type library browser (Internet Explorer only) allows you to select a class and explore the properties and methods it exposes. In some cases it can link through to the help pages for the relevant application.
If that link doesn't work, try accessing it from the ActivePerl section of your start menu.
Failing all that, the Excel scripting help pages are the other place to look.
| [reply] |