Syntax for OpenXML in ASP.NET

Discussion in 'ASP .Net' started by =?Utf-8?B?TWlja2U=?=, Sep 29, 2004.

  1. 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.
     
    =?Utf-8?B?TWlja2U=?=, Sep 29, 2004
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ben
    Replies:
    3
    Views:
    1,523
  2. Replies:
    1
    Views:
    1,138
    Kevin Spencer
    Aug 10, 2005
  3. Replies:
    5
    Views:
    745
    =?Utf-8?B?Q3VydF9DIFtNVlBd?=
    Sep 14, 2005
  4. Andrea Raimondi
    Replies:
    1
    Views:
    723
  5. Replies:
    9
    Views:
    2,034
    Joe Kesselman
    Mar 24, 2006
  6. xavirm

    Problems with OPENXML

    xavirm, May 14, 2009, in forum: .NET
    Replies:
    0
    Views:
    1,796
    xavirm
    May 14, 2009
  7. Amelyan
    Replies:
    2
    Views:
    364
    Amelyan
    Apr 25, 2005
  8. Jamie Sutherland

    Help with vb.net Maths syntax in asp.net

    Jamie Sutherland, Oct 25, 2007, in forum: ASP .Net Web Controls
    Replies:
    1
    Views:
    287
    Phil H
    Oct 25, 2007
Loading...