+ Reply to Thread
Results 1 to 3 of 3

Import HTML code from a text file.

  1. #1

    Import HTML code from a text file.

    I am getting the html code of a wab page in a variable which I have
    written to a file and saved as a .txt file. I am importing these code
    in excel for further processing.

    Is there a better way to write these code to excel sheet? Each line for
    code should be in new row in column A. Currently opening the file in
    excel writes the code in other columns if the code has indenting.
    Also if I can avoid creating a text file and then importing in Excel,
    it would be better and faster I belive. Can I perse the html code
    directly from the variable and write each line of code in col A new
    rows?


    Thanks.
    Nathpai


  2. #2
    OJ
    Guest

    Re: Import HTML code from a text file.

    Why don;t you save as HTML and then import into Excel as HTML?


  3. #3

    Re: Import HTML code from a text file.

    Thanks for reply.
    I have tried it just now. If I import the html in excel, Nothing is
    imported. Excel just shows the blank sheet. The same file if I open in
    IE, it opens after giving few script errors. But still for the same
    HTML file when opened in excel, shows a blank sheet.

    I have no idea why it happens this way.
    Thanks,
    Nathpai.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1