Message-ID: <826512524.10359.1711722616096.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10358_29820325.1711722616096" ------=_Part_10358_29820325.1711722616096 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html ExcelTemplate.Open(ExcelApplication, Workbook)

ExcelTemplate.Open(ExcelApplication, Workbook)

Description

=20

Passes a spreadsheet from Exc= elApplication to ExcelTemplate<= /a>.

=20
C#
=20
 public virtual void Open(ExcelApplication excelApplication, Workbook workb=
ook)
=20
=20
vb.net
=20
Public Overridable Sub Open(ByVal excelApplication As ExcelApplication, ByV=
al workbook As Workbook)
=20
=20

Paramet= ers

=20
e= xcelApplication
The instance of=20 ExcelApplication that was used to create the spreadsheet.=20
workbook<= /h6> A=20 Workbook object rep= resenting the Excel file created with=20 ExcelApplication.=20

Excepti= ons

=20
ArgumentNullException
=20 Open will= throw this exception if=20 null (C#) or=20 Nothing (VB.NET) is passed to the method.=20
= ArgumentException
=20

Remarks=20

You can use ExcelApplication to create a document with data= markers (a template) and pass the file to ExcelTemplate to po= pulate the data markers.

=20

If your template file is the new Office Open XML (.xlsx) format, you can= not open it using ExcelApplication in ExcelWriter version 7.=20

Examples<= /h2>=20
C#
=20

          ExcelApplication xla =3D new ExcelApplication();
          Workbook wb =3D xla.Create();
          ExcelTemplate xlt =3D new ExcelTemplate();
          xlt.Open(xla, wb);
        
=20
=20
vb.net
=20

          Dim xla As New ExcelApplication()
          Dim wb As Workbook =3D xla.Create()
          Dim xlt As New ExcelTemplate()
          xlt.Open(xla, wb)
        
=20

------=_Part_10358_29820325.1711722616096--