Wiki Markup |
---|
{description} {excerpt}Opens an ExcelWriter template from a {msdn:System.IO.Stream|System.IO.Stream}. An ExcelWriter template is a file created in Microsoft Excel that contains data markers where data source values will be inserted. {excerpt} {signature:C#} public virtual void Open(System.IO.Stream stream) {signature} {signature:vb.net} Public Overridable Sub Open(ByVal stream As System.IO.Stream) {signature} {parameters} {param:templateStream}A {{System.IO.Stream}} object, or a class derived from {{System.IO.Stream}} \(for example, {msdn:System.IO.FileStream|System.IO.FileStream}\). {param} {exceptions} {exception:ArgumentNullException}[Open|ExcelTemplate.Open] will throw this exception if {{null}} \(C\#\) or {{Nothing}} \(VB.NET\) is passed to the method. {exception} {exception:ArgumentException} {exception} {remarks}If your template file is the new Office Open XML \(.xlsx\) format, you can pass it into the [ExcelTemplate.Open|ExcelTemplate.Open] method just as you would a BIFF8 \(.xls\) Excel file. You will need to remember to give the output file a ".xlsx" extension when you call [Save|ExcelTemplate.Save], as ExcelWriter cannot convert .xlsx files to .xls. {remarks} {example}{code:csharp|title=C#} //--- Open an Excel BIFF8 (.xls) file FileStream oFileStream = New FileStream(@"C:\Templates\Template.xls", FileMode.Open); oExcelTemplate.Open(oFileStream); //--- Open an Office Open XML Excel (.xlsx) file FileStream oFileStream = New FileStream(@"C:\Templates\Template.xlsx", FileMode.Open); oExcelTemplate.Open(oFileStream); {code} {code:vb.net|title=vb.net} '--- Open an Excel BIFF8 (.xls) file Dim oFileStream As New FileStream("C:\Templates\Template.xls", FileMode.Open) oExcelTemplate.Open(oFileStream) '--- Open an Office Open XML Excel (.xlsx) file Dim oFileStream As New FileStream("C:\Templates\Template.xlsx", FileMode.Open) oExcelTemplate.Open(oFileStream) {code} {example} |
Page History
Overview
Content Tools