Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
OLE with MSIE
 |
- !! Getting started with MSIE !!!
- !! Webpage Element Explorer !!
- Accessing Download File Dialog Box
- Accessing New IE Window
- Analyze HTML Sample Code
- Automate Input into Form
- Automate name change in Yahoo Mail Account
- BeforeNavigate2 Example
- Calander in MSIE
- Cannot Find Form Name
- Check a Radio Button on Web Page
- Check Checkbox in Web Page
- Check if URL is Open in IE
- Click Form Buttons
- Click on Button with No Name and No ID
- Click on Input Type Image
- Convert HTML Hex to Unicode String
- Dealing with iFrames
- Delete Temporary Internet Files Cache
- Determine if Check box is checked on Webpage
- DHMTL Type Ahead Search
- DHTML Download Webpage Complete
- DHTML Reference Link
- Display a Browser Print Preview Page
- Display data in a Columnar or Grid format
- Distinguish between IE window and a Windows Explorer window
- Download Complete Webpage
- Embed an Active X Object into MSIE
- Example of Using the IE Object Interface.
- Example of using the IE Object Interface
- ExecCommand Saveas dialog problem
- Execute a Java Script from a Webpage
- Execute JScript function via OLE
- Extract Column from HTML Table
- Fiind Unnamed Form
- Find a Link in a Webpage then Click on it
- Find Current MSIE Window Object Handle
- Fire a ONMOUSEOVER MSIE Event via Ole
- Geocoder Return Latitude and Longitude for an Address
- Get Current Open MSIE Screen
- Get Data From a Webpage
- Get Objects in MSIE Form
- Get page contents in IE
- Get text from HTML pages
- Get Webpage Links
- Getting an OLE document handle for an open MSIE window
- Gmail Login
- Go Back to Previous Web Page
- Grab Url of Active Window
- How to Access Frame Object in InternetExplorer
- How to Check a Checkbox When They All Have the Same Name
- How to Click on a URL link on a Web Page
- How to Launch IE with Several Tabs
- How to Test if Page is Loaded under IE4
- HTML Analysis
- HTML Extender Replacement code
- HTML to Text conversion with Internet Explorer 5
- IE Analyzer
- IE9 Click or Focus Methods Fail
- Ignore Java script code in webbpage
- Insert Data into IE Web Form INPUT Controls
- Internet Explorer No Title Bar Or Options
- Internet Explorer OLE Developer Scripts
- Inventory Frames
- Launch Application from HTML Page
- List Links on a Webpage
- Locate a String on a Webpage
- Log onto the WebBoard via OLE
- MSIE Context menu Example
- MSIE Download URL Example
- MSIE OLE Popup Killer
- Navigate Url Error
- OLE - Reading a web page
- OLE Event Examples
- OLE Get User Input from HTML Form
- OLE HTTPS Download with Client Certificate
- OLE MSIE Enter Userid and Password
- OLE MSIE Hints
- OLE to Return Links and Anchors on Webpage
- Open MSIE with OLE
- Quick Explanation of the Internet Application Object Model
- Read Java Script From a Web Page
- Reading Text in Multiple MSIE Frames
- Remove Title Bar from IE
- Save As Complete Web Page
- Saving data with MSIE and OLE
- See What Buttons Pushed in MSIE
- Select Option and Button Example
- Set Focus on HTML Form Control
- Setting Focus on an HTML Control
- SHDOCVW dll
- Spanish OLE-MSIE UDFs
- UAC Manifest Setting Triggers 1129 Error
- URL monitor
- Use DHTML to Create a Dialog to View a Report
- Users Collection of OLE MSIE Scripts
- Using MSIE from a WinBatch front end
- Using WB OLE to Automate MSIE and Dynamic HTML
- WebPage Inventory
- WebPage Link Lister
- WindowOnTop Problem With IE9
- Working with Multiple Tabs in Internet Explorer
- Zoom IE Window
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Extract Column from HTML Table
Question:
There is a html page that has one table element of 50 rows and 6 columns. I need complete column 3 to be extracted into list or array variable. I need some advice.Answer:
without seeing the HTML I can only suggest a likely course. Something like this maybe...
mycolumn = 3
cellList = browserdoc.GetElementsByTagName("TD")
column3 = ""
For x = 0 To cellList.length-1
If x+1 mod mycolumn == 0
thiscell = cellList.item(x)
column3 = ItemInsert(thiscell.innerText, -1, column3, "|")
ObjectClose(thiscell)
EndIf
Next
ObjectClose(cellList)
Message("Debug", column3)
User Response:
; Use MSIE browser to parse a table from within htm file.
oBrowser = ObjectOpen("InternetExplorer.Application")
oBrowser.visible = @FALSE
oBrowser.silent = @TRUE
oBrowser.offline = @TRUE
oBrowser.navigate(sFileHTM)
While ((oBrowser.busy)||(oBrowser.readystate!=4))
TimeDelay(1)
EndWhile
oDocument = oBrowser.Document
oListTABLE = oDocument.GetElementsByTagName("TABLE")
iDim1 = oListTABLE.length
; Convert the one and only table in this document into a CSV file.
oTable = oListTABLE.item(0)
oListTR = oTable.GetElementsByTagName("TR")
iDim1 = oListTR.length
iHighDim1 = iDim1-1
For ii=0 To iHighDim1
sCSV = ""
oThisTR = oListTR.item(ii)
oListTD = oThisTR.GetElementsByTagName("TD")
iDim2 = oListTD.length
If iDim2
iHighDim2 = iDim2-1
For ik=0 To iHighDim2
oThisTD = oListTD.item(ik)
sCSV = ItemInsert(StrCat('"',StrTrim(oThisTD.innerText),'"'),-1,sCSV,";")
ObjectClose(oThisTD)
Next
sCSV = StrCat(sCSV,@CRLF)
udfFilePutAppend(sFileCSV1,sCSV)
EndIf
ObjectClose(oListTD)
ObjectClose(oThisTR)
Next
ObjectClose(oListTR)
ObjectClose(oTable)
ObjectClose(oListTABLE)
ObjectClose(oDocument)
oBrowser.quit
ObjectClose(oBrowser)
Article ID: W16117
File Created: 2004:03:30:15:42:56
Last Updated: 2004:03:30:15:42:56