Copying Tables from a Website

Posted by amemus on Super User See other posts from Super User or by amemus
Published on 2013-02-21T08:38:58Z Indexed on 2014/08/22 22:25 UTC
Read the original article Hit count: 178

Filed under:

microsoft-excel

|

internet-explorer

|

html

I have difficulty making an Excel-readable file from a table on a Website. The problems very specific to my question are:

I have to use IE 7 to access the site.
Excel is installed in another computer.
The site does not let me view the HTML of the table.

Normally, I would simply select the table I want and drag and drop it to Excel. Or, I would view the page source and copy the HTML data. Both do not work in this case.

Is there any handy tool out there?

© Super User or respective owner

Related posts about microsoft-excel

Connecting to Microsoft Excel using Oracle Data Integrator

as seen on Oracle Blogs - Search for 'Oracle Blogs'
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Topology, Data Server, Physical and Logical Architecture are used here assuming that you understand them in the context of ODI. If you need more details on these elements, please refer to the ODI Tutorial… >>> More
Connect Microsoft Excel To SQL Azure Database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
A number of people have found my post about getting started with SQL Azure pretty useful. But, it's all worthless if it doesn't add up to user value. Database are like potential energy in physics-it's a promise that something could be put in motion. Users actually making decisions based on analysis… >>> More
How to code Microsoft Excel "Shift Cells Up" feature in SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Take a simple table like below: Column Headings: || Agent's Name || Time Logged In || Center || Row 1: Andrew || 12:30 PM || Home Base Row 2: Jeff || 7:00 AM || Virtual Base Row 3: Ryan || 6:30 PM || Test Base Now lets say that a single cell is deleted so the table now looks like this: Column… >>> More
a question on using Microsoft Excel to do data analysis

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone there, Me and my mates have been given an Excel spreasheet,which contains the data of the Census report. The column here corresponds to "Year" (from 2000-2010),the row means "City/Town",the cell is simply the population of a town at a particular year. We are up to doing some analysis… >>> More
Working with PivotTables in Excel

as seen on How to geek - Search for 'How to geek'
PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to create and customize them. Note: This article… >>> More

Related posts about internet-explorer

Windows 8: Is Internet Explorer10 Metro mode disabled? Here is the fix.

as seen on Tech Dreams - Search for 'Tech Dreams'
Are you having issues with Internet Explorer 10 on Windows 8? Is Internet Explorer 10 application not launching in Metro mode and always launching in Desktop mode? Continue reading the post to understand and fix the problem. When Internet Explorer 10 does not launch in Metro mode? On Windows 8 when… >>> More
Our Look at the Internet Explorer 9 Platform Preview

as seen on How to geek - Search for 'How to geek'
Have you been hearing all about Microsoft’s work on Internet Explorer 9 and are curious about it? If you are wanting a taste of the upcoming release then join us as we take a look at the Internet Explorer 9 Platform Preview. Note: Windows Vista and Server 2008 users may need to install a Platform… >>> More
Edit Text in a Webpage with Internet Explorer 8

as seen on How to geek - Search for 'How to geek'
Internet Explorer is often decried as the worst browser for web developers, but IE8 actually offers a very nice set of developer tools. Here we’ll look at a unique way to use them to edit the text on any webpage. How to edit text in a webpage IE8’s developer tools make it easy to make changes… >>> More
Edit Text in a Webpage with Internet Explorer 8

as seen on How to geek - Search for 'How to geek'
Internet Explorer is often decried as the worst browser for web developers, but IE8 actually offers a very nice set of developer tools. Here we’ll look at a unique way to use them to edit the text on any webpage. How to edit text in a webpage IE8’s developer tools make it easy to make changes… >>> More
Jquery Selector not working on Internet Explorer

as seen on Stack Overflow - Search for 'Stack Overflow'
Internet Explorer does not like my Jquery selector. Not sure if it's my weak Jquery skills or general Explorer strangeness. Here is the Code: $("#field_"+index+" #field_Label").val(); [div field_1] <input id="field_Label" //... you get the picture. to explain this.. I have a DIV labeled… >>> More