I have a Web Page Containing HTML Table? I Want the SameWeb Page To be Putted on to a Excel Sheet?

Question

I have a Web Page. It will Display the Results of A Query in The Form of Table? User Requirement is to Put the Same Result into an Excrl Sheet?
CAn Any One Help Me?

Answer 1

If U use IE 6 or above you can just simple step below.

1. Make sure your ie is version 6 or above
2. You already install Ms Excel
3. from your web browser (ie6), right click anywhere inside the table, select export to excel.
4. new sheet of excel will generate same as HTML table from your web browser. I did use it since a year ago.

Answer 2

You should use an Excel Web Query. It retrieves (and formats) the table into the Excel worksheet. It can also be set up to automatically refresh.

One piece of advice, though -- Web Queries work best with named tables. If you go this route, the Web Query will be more reliable if you create the web page with a name on the resultant table.

For a quick tutorial on use web queries:

http://www.bcentral.co.uk/business-technology/software-tips/excel-web-query-tutorial-tip.mspx

Answer 3

Simple:

Select the entire table on your web page and copy. Then, open MS Excel, and paste. Be careful to select only the table or you may get other content from the web page in your Excel document.

Answer 4

confident, tabular information, that's something which calls for diverse rows and columns to organise and study appropriate. there is frequently little or no tabular information in internet layout, except you take place to be designing a technological expertise or arithmetic website. Geez, the certainty that such loads of individuals gave out fairly undesirable suggestion in this question is disgusting.