Syntax for OpenXML in ASP.NET

G

Guest

On a code behing page to an aspx page I want to open a xml file in Excel and
save it as an Excel file. I have following code that is working:

Dim oExcel As New Excel.Application
Dim oBook As Excel.Workbook
oBook = oExcel.Workbooks.OpenXML("C:\Test.xml")

Now I want to apply the stylesheet Test.xsl defined in the XML file as:
<?xml-stylesheet type='text/xsl' href='Test.xsl'?>

Does anyone now the syntax for the OpenXML command?

I have tried:
oBook = oExcel.Workbooks.OpenXML("C:\Test.xml", "Test.xsl")
but it's not working.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,756
Messages
2,569,535
Members
45,008
Latest member
obedient dusk

Latest Threads

Top