1
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?
amemus
Posted 2013-02-21T08:38:58.920
Reputation: 11
In Excel, you can have it directly import tables from a web page. From the data ribbon, you can select "From Web". It will allow you to use a embedded instance of IE to access/configure your site. Once your in, you can select the table(s) you want it to import. – ttaylor1218 – 2018-03-01T01:44:35.057
Can you explain why yo have to use IE7? – Gunnish – 2013-02-21T10:31:06.917
It has to be IE in order to access; electronic certificate and so on. I don't know if I can upgrade IE without much trouble with the site. – amemus – 2013-02-21T11:50:58.023
2I don't understand, the point that
site does not let me view the HTML of the table, can you elaborate, is it a flash based site or something like that ? – Ankit – 2013-02-21T12:14:25.593Are you able to copy and paste the table data into a text file? – CharlieRB – 2013-02-21T12:51:18.380
@Lamb "View page source" for the page where the table is on does not get table. It only show JavaScript or something. Yes, I can copy and paste the table into a text file but a lot of cells in the wrong columns. – amemus – 2013-02-21T13:11:45.987
Actually, I can copy and paste the table into a vBulletin-powered forum. I can take out the table coded in vBulletin codes. I would switch to another computer, post the table in the edit post window of the forum , drag and drop the preview into Excel. It's really a big trouble. – amemus – 2013-02-21T13:17:57.247
(If your situation permits) It would be easier for someone to help if you can provide the link to the page. – Ankit – 2013-02-21T13:40:59.667
It's a banking service, so no can do. – amemus – 2013-02-22T02:11:53.530