?
Solved

How saving xml to xls?

Posted on 2003-11-02
3
Medium Priority
?
680 Views
Last Modified: 2006-11-17
I create Object type xml (XMLData) by JavaScript:
      XMLData = new ActiveXObject("msxml2.domdocument.3.0");
      XMLData.async = false;
      XMLData.load("Details2XML.aspx");

              (Details2XML.aspx create the xml)
Now I want giving option to user ,to save this Object (XMLData)
As xls (excel file).
I want that user can named the xls file and can choose the
Path where will be save.

Questions are:
1.how to change xml Object to file excel
2.how to give the optional to user to choose the
Name file and where it will save  

Thanks


0
Comment
Question by:RanSIV
1 Comment
 
LVL 3

Accepted Solution

by:
makc earned 200 total points
ID: 9680571
there are several ways:
a) pure scripting with Excel.Application object (tough);
b) build script a) with XSLT (a bit easier)
c) pure XSLT transformation into importable form. to get an idea what you should get with XSLT, create empty excel book and save-as it as xml table.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Screencast - Getting to Know the Pipeline

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question