ASP: XLS to XML
am 23.10.2007 19:39:26 von djdnareshhi anyone,
is it possible to open a excel file with excel application object and
with saveas() to XML file in asp, without ADO?
hi anyone,
is it possible to open a excel file with excel application object and
with saveas() to XML file in asp, without ADO?
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.aspx?scid=KB;en-us;q257 757) 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.