Results 1 to 6 of 6

Thread: how to read html file using vbscript and write it into an excel

Threaded View

  1. #1
    Join Date
    Mar 2013
    Beans
    3

    how to read html file using vbscript and write it into an excel

    Hi,
    I want read a html and write few columns from it into an excel table.
    I am currently using a macro to do it. But need it in VBScript

    Below given is the sample html.
    I want to count the number of fail occurrences for complainace check and oracle table and write it into an excel.

    HTML File:

    Result Detail Time
    INFO TEST STARTED 2/9/2012 4:53:30 AM
    DONE Passed -he webservice call. 2/9/2012 4:53:34 AM
    FAIL
    Failed on compliance check, 2/9/2012 4:55:22 AM
    WARNING Error querying QA-ORA. 2/9/2012 4:55:33 AM
    WARNING Error querying QA-ORA. 2/9/2012 4:55:36 AM
    WARNING Error querying QA-ORA. 2/9/2012 4:55:37 AM
    WARNING Error querying QA-ORA. 2/9/2012 4:55:38 AM
    WARNING Error querying QA-ORA. 2/9/2012 4:55:39 AM
    DONE Passed - the trade was found in the SybaseFund table. 2/9/2012 4:55:42 AM
    FAIL
    Failed - not found in the Oracletable. 2/9/2012 4:55:42 AM
    FAIL
    Failed - not found in the Oracle table.



    Desired Result in Excel:


    ComplianceCheck Oracle
    2/9/2012 1 2
    2/3/2013 0 0






    Last edited by sravs448; March 15th, 2013 at 10:23 PM.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •