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. Advertising

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. Replies:
    9
    Views:
    1,350
    Joe Kesselman
    Mar 24, 2006
  2. xavirm

    Problems with OPENXML

    xavirm, May 14, 2009, in forum: .NET
    Replies:
    0
    Views:
    1,552
    xavirm
    May 14, 2009
  3. gabriele renzi
    Replies:
    2
    Views:
    220
    gabriele renzi
    Dec 31, 2005
  4. Ken Bloom
    Replies:
    3
    Views:
    223
  5. Good Night Moon
    Replies:
    9
    Views:
    290
    Rick DeNatale
    Jul 25, 2007
Loading...

Share This Page