Online
 
Sunday, 23 November 2008
 
 

Open Web pages right in Excel | Print |  E-Mail
 

If your users need to analyze data found on a Web site, they might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel 97 can save them a lot of time by letting them open an HTML page in Excel directly from the Web.

The procedure is just a slight modification of the standard file-opening procedure:

1.       Choose Open from the File menu.

2.       In the File Name text box, type the URL of the Web file to open. Note: Be sure to include the prefix http://.

3.       From the Files Of Type drop-down list, select HTML Documents (*.html, *.htm).

4.       Click Open.

Excel opens HTML pages based on the HTML table structure of the page, so some Web design treatments may lead to some weird results in Excel. For pages that cleanly present data in a table format, however, this approach can be a real time-saver.
This entry was posted on . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a comment.
Users' Comments (0)

Comment an article
  Name
  E-mail
   Title
Available characters: 4000
 Notify me of follow-up comments
This image contains a scrambled text, it is using a combination of colors, font size, background, angle in order to disallow computer to automate reading. You will have to reproduce it to post on my homepage
Enter what you see:

No comment posted

Jumbo Coklat
 
Top! Top!