Copying html table

[dvlkn]

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

[Triblade]

Edit: My post seemed to be nonsense.

*pointing down* What he said...

Edited September 4, 2008 by Triblade

[DaleHohm]

$oTable is an object reference variable, not the table content

See _IEPropertyGet -> innerText or innerHTML

Better yet, you should probably use _IETableWriteToArray

Dale

[dvlkn]

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 ?

[DaleHohm]

Try it and ask questions you may have as a result.

Dale

[dvlkn]

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

[DaleHohm]

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

[dvlkn]

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

[DaleHohm]

Suggest you open a new topic to discuss your array management questions.

Dale