How to select Table 3 of 7 and save to file.

[tommytx]

Can someone offer some advice here, I have an html file that is reporting 7 tables. I need to save table 3 of the group. Obviously I have no idea what I am doing, please help. This particular table has and id="ctl00_SampleContent_Traffic1_gvSourceStats so I could use the id or table number 2... I am counting as 0,1,2,3,4,5,6,7 and using a ($oIE, 2) since I actually need table number 3. Am I even close.. Once I save the extracted table, then I will view just that complete table as it has the stats.. Should I be using the ID since it is available?

$file = FileOpen("savetable.htm", 2)
$oIE = _IECreate ("C:\_____New_Blog_Idea\_download_au3\stats.htm")
$oTable = _IETableGetCollection ($oIE, 2)
For $oTable In $oTables
    FileWrite($file, $oTable.outerHTML & @CRLF)
Next
FileClose($file)

Edited August 11, 2010 by tommytx

[PsaltyDS]

Use whichever method you think is more likely to be stable (not change in the future). You could even use both, getting the table by 0-based index and then verify it's the right one with:

$oIE = _IECreate ("C:\_____New_Blog_Idea\_download_au3\stats.htm")
$oTable = _IETableGetCollection ($oIE, 2)
If @error Or ($oTable.id & "" <> "ctl00_SampleContent_Traffic1_gvSourceStat") Then
     MsgBox(16, "Error", "Table ID mismatch!")
     Exit
EndIf

Note that if you specify an index, the return value is just the object (on success anyway), not a collection. So the For/In loop is not required.

Edited August 11, 2010 by PsaltyDS

[DaleHohm]

Or just

$oTable = _IEGetObjById($oIE, "ctl00_SampleContent_Traffic1_gvSourceStats")

Dale

[tommytx]

Thanks... that sounds like great advice.. I will use it, but I still do not understand how to save the scraped table so that once the single small table has been extracted and saved I can browse to the file and view just the table..

I tried something like this but its not working... I am sure I have not set it up correctly..

FileWrite($file, $oTable.outerHTML & @CRLF) I also added 3 lines to your solution to show you what else I need to accomplish.. I can go in manually and copy the entire small table and save it and it works great in the browser.. but I need to automate it. Isn't there an easy way?

$file = FileOpen("savetable.htm", 2)
$oIE = _IECreate ("C:\_____New_Blog_Idea\_download_au3\stats.htm")
$oTable = _IETableGetCollection ($oIE, 2)
If @error Or ($oTable.id & "" <> "ctl00_SampleContent_Traffic1_gvSourceStat") Then
     MsgBox(16, "Error", "Table ID mismatch!")
     FileWrite($file, $oTable.outerHTML & @CRLF)
     Exit
EndIf
FileClose($file)

Edited August 11, 2010 by tommytx

[DaleHohm]

See _IETableWriteToArray and its examples.

Dale