• 0 Vote(s) - 0 Average
• 1
• 2
• 3
• 4
• 5
 QM Problem HTML TABLE HarishChand Junior Member Posts: 27 Threads: 10 Joined: Sep 2010 09-24-2010, 01:33 PM I have simple html table I have 5 row and 5 column How I can capture particular column : then get value of corresponding column Reply Reply Gintaras Administrator Posts: 11,002 Threads: 128 Joined: Dec 2002 09-24-2010, 01:44 PM Can you give link to the web page? Reply Reply HarishChand Junior Member Posts: 27 Threads: 10 Joined: Sep 2010 09-24-2010, 01:55 PM Suppose: http://www.w3schools.com/html/html_tables.asp Exp: I have Bananas in excel I have 2 column Name: Bananas, Mango, Apples I want get percentage value of bananas... and store to different -2 string variable Reply Reply Gintaras Administrator Posts: 11,002 Threads: 128 Joined: Dec 2002 09-24-2010, 02:02 PM Example with other page. Table with 6 columns. http://www.quickmacros.com/help/Tables/IDP_ASCII.html Macro Macro1461 Code: ```out HtmlDoc d.InitFromWeb("http://www.quickmacros.com/help/Tables/IDP_ASCII.html") ARRAY(str) a d.GetTable(1 a) ;;get the second table int i for i 0 a.len 6 ;;6 columns ,out a[i+4] ;;5-th column``` Reply Reply Gintaras Administrator Posts: 11,002 Threads: 128 Joined: Dec 2002 09-24-2010, 02:15 PM With fruits. Macro Macro1463 Code: ```out HtmlDoc d.InitFromWeb("http://www.w3schools.com/html/html_tables.asp") ARRAY(str) a d.GetTable(8 a) int i for i 0 a.len 2 ,out "%s=%s" a[i] a[i+1]``` Reply Reply HarishChand Junior Member Posts: 27 Threads: 10 Joined: Sep 2010 09-24-2010, 04:23 PM MY table is nested: Error occour table not found
Assignment Activities
Activity Type:
Date of Activity:

********************************************************I USE GIVEN BELOW TABLE****************************************** Activities History
9/23/2010 3:33:20 PM9/23/2010 3:33:26 PMKim AmandusShortlistSubmitted to Ecam (exempt)
9/23/2010 3:33:02 PM9/23/2010 3:33:09 PMKim AmandusReview
9/23/2010 12:00:00 AM9/22/2010 4:16:37 PMarchana sagarVendor message to clientResubmitted at significant reduced rate. Please reconsider.
9/22/2010 4:15:40 PM9/22/2010 4:15:44 PMarchana sagarData Modified Pay Rate:43.6900 OT Pay Rate:43.6900 DT Pay Rate:43.6900 Bill Rate:54.6900 OT Bill Rate:54.6900 DT Bill Rate:54.6900 Inclusive Rate:54.6900 OT Inclusive Rate:54.6900 DT Inclusive Rate:54.6900 Exempt:True ShiftPremium:False Transition:False PayRoll:False
9/21/2010 4:16:13 PM9/21/2010 4:16:15 PMKim AmandusRejected
Reason : Rejected - Agile-1
Comment : Rate too high- BR cannot exceed \$50/hr
9/21/2010 3:53:44 PM9/21/2010 3:53:44 PMarchana sagarReview
**************************************************************************************
Reply Reply Gintaras Administrator Posts: 11,002 Threads: 128 Joined: Dec 2002 09-25-2010, 06:39 AM If table not found, probably wrong index used with GetTable. To get table index: 1. Open the web page in Internet Explorer. 2. Got to Quick Macros and open 'Find HTML element' dialog. It is in floating toolbar, 'Window, control' menu. 3. Capture the table. 4. If captured correctly, Tag must be TABLE. Index shows table index. Use it with GetTable. Reply Reply Gintaras Administrator Posts: 11,002 Threads: 128 Joined: Dec 2002 09-25-2010, 06:53 AM Your table has id attribute. It can be used as table name. Then don't need index. Macro Macro1458 Code: ```out HtmlDoc d.InitFromInternetExplorer(win("" "IEFrame")) ARRAY(str) a d.GetTable("AssignmentActivityHistory_dgAssignmentActivity" a) int i for i 0 a.len 5 ,out a[i+4] ;;5-th column``` Reply Reply « Next Oldest | Next Newest »

Forum Jump:

Users browsing this thread: 1 Guest(s)