excel - Changing the page layout using Office Web Components -


I am using Office Web Components to fill an Excel template with prices. The template is in Excel xml format, which includes all the relevant field and layout options, including the page layout, the scenario in this situation. I am filling this template with some real areas using the code given below.

  obz spreadsheet = set the server. Create Object ("OWC11.Spreadsheet") objSpreadsheet.XMLURL = Server.MapPath ("xml") & amp; "\ MR1_Template.xls" 'Fill cells with values.' Response.ContentType = "application / vnd.ms-excel" Response.AddHeader "content-displacement", "inline; filename =" & amp; StrfileNaam Response.write objSpreadsheet.xmlData   

After the new Excel file has been saved, the page layout options have been exhausted. I have seen the API document for OWC but can not get the option to specify the scenario page-layout

I'm not sure that you are entering the right data. XMLLL looks like a strange method to pass in an XSL template?

If you are converting it to XSL, then why not use DOMXmlDocument as this article:

Cut and paste for ease: Load the new XSL Transforms' Stylesheet as the slow XSLT

  Xslt.load (Server.MapPath (".") And "excel2csv.xsl") The slow document is the 'xmldata string' as the new XmlDocument, use the file doc.Load (fileName). Doc.LoadXml (xmlData) 'Create an XmlTextWriter that outputs a file as a filename of the filename string file = Server.MapPath (".") & Amp; XmlWriter = New XmlTextWriter (filename, nothing) as the "Book.csv" Dim author. Transform data and send output to console Xslt.Transform (doctor, nothing, author, nothing) Writer Closed ()  

Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -