export html to excel using javascript

How can i export a html-output directly to excel?
hessmacAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CJ_SCommented:
You have to do that using the contenttype, unfortunately you cannot set that from the html's point of view. Can you use a serverside language like asp?

if so, it is rather easy. just add the following code before you write anything else out:
response.contenttype="application/vnd.ms-excel"

CJ
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chops123Commented:
IE 6 has an option under the right-click menu saying
Export to Microsoft Excel.

Maybe you can try that out.

Programatically one would export to Excel only if the data in the HTML file is in a spread-sheet format.But the same also contains HTML tags.

What is the nature of the data you need to export ?

KC
0
hessmacAuthor Commented:
The data is a report containing all kind of figures percentages etc. is build with <TABLE>,<TR>'s and <TD>'s

0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

chops123Commented:
Your data will not be in a spreadsheet format when simply exporting directly..

Have you tried the IE 6 feature of exporting to excel.

If that doesnt work,you may have to parse your HTML file,select each value required from <TD>'s and enter them in specific cells in the Excel sheet

Rgds
KC
0
ahosangFinance Systems DeveloperCommented:
This question has been abandoned. I will make a recommendation to the moderators on its resolution in a week or so. I appreciate any comments that would help me to make a recommendation.
 
In the absence of responses, I may recommend DELETE unless it is clear to me that it has value as a PAQ. Silence = you don't care
 
ahosang
0
ahosangFinance Systems DeveloperCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

split - CJ_S/chops123
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
ahosang
EE Cleanup Volunteer
0
ChmodCommented:
As recommended

Points for chops123 at http://www.experts-exchange.com/Web/Web_Languages/JavaScript/Q_20597735.html

Chmod
Community Support Moderator @Experts Exchange
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
JavaScript

From novice to tech pro — start learning today.