dvlkn Posted September 4, 2008 Share Posted September 4, 2008 (edited) Hello I am having another web page manipulation issue again This time I want to copy a html table and paste it in notepad for e.g. $oFrame = _IEFrameGetObjByName ($oIE, "main") $oTable = _IETableGetCollection ($oFrame, 6) clipPut ($oTable) WinActivate ("Untitled - Notepad") Send ("^v") Would this work ? Because for now, it's only pasting a "0" in my notepad file and I wonder maybe clipPut cannot not "work" with that data ? Or I could be picking the wrong table so I am trying every numbers at the moment Any help appreciated Edited September 4, 2008 by dvlkn Link to comment Share on other sites More sharing options...
Triblade Posted September 4, 2008 Share Posted September 4, 2008 (edited) Edit: My post seemed to be nonsense. *pointing down* What he said... Edited September 4, 2008 by Triblade My active project(s): A-maze-ing generator (generates a maze) My archived project(s): Pong3 (Multi-pinger) Link to comment Share on other sites More sharing options...
DaleHohm Posted September 4, 2008 Share Posted September 4, 2008 $oTable is an object reference variable, not the table content See _IEPropertyGet -> innerText or innerHTML Better yet, you should probably use _IETableWriteToArray Dale Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model Automate input type=file (Related) Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded Better Better? IE.au3 issues with Vista - Workarounds SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead? Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble Link to comment Share on other sites More sharing options...
dvlkn Posted September 4, 2008 Author Share Posted September 4, 2008 I see, thanks for pointing me in the right direction. As for the array, is there a limit to the amount of data that can be written to it ? And suppose I need to perform arithmetic operations and wish to display it alongside the copied/pasted table, would that be possible ? Link to comment Share on other sites More sharing options...
DaleHohm Posted September 4, 2008 Share Posted September 4, 2008 Try it and ask questions you may have as a result. Dale Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model Automate input type=file (Related) Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded Better Better? IE.au3 issues with Vista - Workarounds SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead? Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble Link to comment Share on other sites More sharing options...
dvlkn Posted September 6, 2008 Author Share Posted September 6, 2008 (edited) OK is there another way to capture a html table from a web page ? Because if I use any of the functions above, the data comes out just as plain text i.e. it loses its "table alignment" I don't want to use the _IEwritetoarray as well because there is simply too much data to work with. I gotta send it to a spreadsheet like excel for e.g. Edited September 6, 2008 by dvlkn Link to comment Share on other sites More sharing options...
DaleHohm Posted September 6, 2008 Share Posted September 6, 2008 (edited) Working with the array should not be that tough. This approach may be what you are looking for however: #include <IE.au3> $oIE = _IE_Example("table") $oTable = _IETagnameGetCollection($oIE, "table", 0) $sTable = _IEPropertyGet($oTable, "outerhtml") $oIE2 = _IECreate() _IEBodyWriteHTML($oIE2, $sTable) _IEAction($oIE2, "selectall") _IEAction($oIE2, "copy") ClipGet() ; you can now paste into Excel If you want to avoid a secutiry warning about script accessing your clipboard, you may wnat to use SEND commands with ^a ^c instead of the _IEAction functions. Dale Edited September 6, 2008 by DaleHohm Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model Automate input type=file (Related) Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded Better Better? IE.au3 issues with Vista - Workarounds SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead? Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble Link to comment Share on other sites More sharing options...
dvlkn Posted September 10, 2008 Author Share Posted September 10, 2008 (edited) That works nicely, thank you. I tried a bit more with the 2D array like you advised me... my problem is that I have to copy several tables from the web, not just one. How can I add the following tables to the same array ? I fooled around with the _ArrayAdd function but to no avail *edit* I need to be more explicit. I have like 80 html tables I want to copy. So far, my table.au3 correctly logins, navigate to the page, parse the html table and write it to the array. Now I am trying to make it continue to navigate to the next page and thus the desired table & add it to the array. Each table has 20 rows. Edited September 10, 2008 by dvlkn Link to comment Share on other sites More sharing options...
DaleHohm Posted September 10, 2008 Share Posted September 10, 2008 Suggest you open a new topic to discuss your array management questions. Dale Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model Automate input type=file (Related) Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded Better Better? IE.au3 issues with Vista - Workarounds SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead? Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now