Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Description

Excerpt

Opens a Workbook from an ExcelTemplate object.

Signature
C#
C#
 public virtual Workbook Open(ExcelTemplate excelTemplate)
Signature
vb.net
vb.net
Public Overridable Function Open(ByVal excelTemplate As ExcelTemplate) As Workbook
Parameters
Param
excelTemplate
excelTemplate

An ExcelTemplate object representing the workbook to open.

Returns

Workbook that is opened.

{remarks}
If your template file is the new Office Open XML (.xlsx) format, you can pass it into the ExcelApplication.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 as ExcelWriter cannot convert .xlsx files to .xls

Exceptions
Exception
System.Exception
System.Exception

If there is a problem creating, opening, or writing to the file specified, or reading from the Workbook object.

Example
Code Block
csharp
csharp
titleC#

          ExcelTemplate xlt = new ExcelTemplate();

          //--- Do something with template here

          ExcelApplication xla = new ExcelApplication();
          xla.Open(xlt);
        
Code Block
vb.net
vb.net
titlevb.net

          Dim xlt As New ExcelTemplate()

          '--- Do something with template here

          Dim xla As New ExcelApplication()
          xla.Open(xlt)