Message-ID: <1999349915.8345.1711642912535.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8344_676805661.1711642912535" ------=_Part_8344_676805661.1711642912535 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html ExcelTemplate.Open(System.IO.Stream)

ExcelTemplate.Open(System.IO.Stream)

Descrip= tion

=20

Opens an ExcelWriter template from a System.IO.Stream. An ExcelWriter template is a file created = in Microsoft Excel that contains data markers where data source values will= be inserted.

=20
C#
=20
 public virtual void Open(System.IO.Stream stream)
=20
=20
vb.net
=20
Public Overridable Sub Open(ByVal stream As System.IO.Stream)
=20
=20

Parameters

= =20
templateStre= am
A=20 System.IO.Stream object, or a class derived from=20 System.IO.Stream (for example,=20 System.IO.FileStream).=20

Exceptions

= =20
Argum= entNullException
=20 Open will= throw this exception if=20 null (C#) or=20 Nothing (VB.NET) is passed to the method.=20
ArgumentE= xception
=20

Remarks

If you= r template file is the new Office Open XML (.xlsx) format, you can pass it = into the=20 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=20 Save, as = ExcelWriter cannot convert .xlsx files to .xls.=20

Examples

=20
C#
=20

          //--- Open an Excel BIFF8 (.xls) file
          FileStream oFileStream =3D New FileStream(@"C:\Templates\Tem=
plate.xls", FileMode.Open);
          oExcelTemplate.Open(oFileStream);

          //--- Open an Office Open XML Excel (.xlsx) file
          FileStream oFileStream =3D New FileStream(@"C:\Templates\Tem=
plate.xlsx", FileMode.Open);
          oExcelTemplate.Open(oFileStream);
        
=20
=20
vb.net
=20

          '--- 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.xls=
x", FileMode.Open)
          oExcelTemplate.Open(oFileStream)
        
=20
------=_Part_8344_676805661.1711642912535--