Results 1 to 6 of 6

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

  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.

  2. #2
    Join Date
    Mar 2013
    Beans
    3

    VBSCRIPT: Read from html and write to an excel using vbscript

    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







  3. #3
    Join Date
    Mar 2011
    Location
    19th Hole
    Beans
    1,273
    Distro
    Ubuntu 13.10 Saucy Salamander

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

    I don't mean to be unfriendly, but why on earth are you posting in a Linux forum? Wouldn't a Windows forum better suit your needs?
    Newb: How far must I jump to clear the ledge halfway down?
    Guru: It's bad to jump off cliffs. Let's look at better options.
    Newb: Stop harping about "best practices" and just tell me.


  4. #4

    Re: VBSCRIPT: Read from html and write to an excel using vbscript

    I have done stuff like this in Perl, but have no VBScript experience (and plan to keep it that way). You may wish to ask at Daniweb or Stack Overflow, where you'd be likely to find more VBScript experience than here at UF.

    That said, if you post the code you're working on it's still possible someone here can help you fix it. You do have some code, right?

  5. #5
    Join Date
    Dec 2005
    Beans
    19,335
    Distro
    Ubuntu 13.10 Saucy Salamander

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

    Merged threads. Please do not cross post. Thank you.
    Learning is not attained by chance, it must be sought for with ardor and attended to with diligence. Abigail Adams ( 1744 - 1818 ), 1780;

    My blog Poetry and More Free Ubuntu Magazine

  6. #6
    Join Date
    Aug 2011
    Location
    47°9′S 126°43W
    Beans
    1,868
    Distro
    Kubuntu 12.10 Quantal Quetzal

    Re: VBSCRIPT: Read from html and write to an excel using vbscript

    Quote Originally Posted by trent.josephsen View Post
    You do have some code, right?
    *cough*

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
  •