MozillaZine

How to export html table to excel sheet

User Help for Mozilla Firefox
manishsharmagr8
Guest
 

Post Posted March 7th, 2008, 11:50 pm

Hi,

Can any one tell me how to export a html table to excel sheet or save it in excel format.

Thanks,

Manish Sharma

LoudNoise
Moderator

User avatar
 
Posts: 38841
Joined: October 18th, 2007, 1:45 pm
Location: Next door to the west

Post Posted March 8th, 2008, 10:11 am

You cannot from Firefox as such. Excel may have a method of importing tables but that would have to be taken up in one of the Microsoft forums.
Post wrangler
"If you lock this, the Pentium IIs win." - anonymous

trolly
Moderator

User avatar
 
Posts: 39102
Joined: August 22nd, 2005, 7:25 am

Post Posted March 8th, 2008, 11:09 am

One thing that can work is selecting the table, copying it to the clipboard and insert it with "Paste Special".
If it really works depends on many parameters.
Think for yourself. Otherwise you have to believe what other people tell you.
A society based on individualism is an oxymoron. || Freedom is at first the freedom to starve.
Constitution says: One man, one vote. Supreme court says: One dollar, one vote.

RobertJ
Moderator

User avatar
 
Posts: 9235
Joined: October 15th, 2003, 7:40 pm
Location: Chicago IL/Oconomowoc WI

Post Posted March 8th, 2008, 12:31 pm

FF 38.0.5 - FF 39.0b7 - FF42.0a - TB 38.0.1 - TB 38.0b6 - TB 41.0a - Mac OSX 10.10.4 Quad-Core Intel Xeon 5500
Computers I've used: IBM 7094/UNIVAC 1108/IBM 360/DEC PDP11/DEC VAX-11 780/DEC VAXstation 8000/Sun SPARCstation 2/Mac from 1984 to 2015

jscher2000

User avatar
 
Posts: 9586
Joined: December 19th, 2004, 12:26 am
Location: Silicon Valley, CA USA

Post Posted March 8th, 2008, 1:39 pm

If this is for yourself, I suggest using an Excel web query. In Excel (2002-2003):
  • Data > Import External Data > New Web Query
  • Paste the URL and load the page. (This uses the IE rendering engine.)
  • Click the yellow arrow for the table you want and Excel will insert it into your sheet.

Note that this is linked to the web, with cached data. If you update the link, it may discard the cached data.

More info:
http://office.microsoft.com/en-us/excel ... 51033.aspx (Office XP)
http://office.microsoft.com/en-us/excel ... 81033.aspx (Office 2000)
http://msdn2.microsoft.com/en-us/librar ... (office.11).aspx (Office 2003 - technical)

On the other hand, if you want to generate a new page using JavaScript or your server-side code, that probably would get a better response on the mozillaZine Web Development board. If you register on this forum, you can request a moderator to move it over in the "Moderation...Requests" sticky thread here: MozillaZine Site Discussion.

Return to Firefox Support


Who is online

Users browsing this forum: No registered users and 24 guests