ASP: XLS to XML

[ND]

hi anyone,
is it possible to open a excel file with excel application object and
with saveas() to XML file in asp, without ADO?

[Bob Barrows [MVP]]

ND wrote:

hi anyone,
is it possible to open a excel file with excel application object and
with saveas() to XML file in asp, without ADO?

Without involving Excel itself, or a third-party application (look at
www.aspose.com) this is not possible. It is possible to get Excel
involved via Automation, but Microsoft strongly discourages automating
Office apps in server-side code (see
http://support.microsoft.com/default...;en-us;q257757) so your
options are:

1. Ignore the caveats and automate Excel
2. Use a third-party app
3. Use ADO

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.