Page History

{description}
{excerpt}Opens a [Workbook|Workbook] from an [ExcelTemplate|ExcelTemplate] object.{excerpt}
{signature:C#}
 public virtual Workbook Open(ExcelTemplate excelTemplate)

{signature}{signature:vb.net

}
Public Overridable Function Open(ByVal excelTemplate As ExcelTemplate) As Workbook

...

An ExcelTemplate object representing the workbook to open.

{signature}
{parameters}
{param:excelTemplate}An {{ExcelTemplate}} object representing the workbook to open.{param}
{returns}Workbook that is opened.{returns}
{remarks}
If your template file is the new Office Open XML (.xlsx) format, you can pass it into the [ExcelApplication.Open|EW8:ExcelApplication.Open(ExcelTemplate)] 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 |EW8:ExcelApplication.Save]as ExcelWriter cannot convert .xlsx files to .xls

{remarks}


{exceptions}
{exception:System.Exception}If there is a problem creating, opening, or writing to the  file specified, or reading from the {{Workbook}} object.{exception}
{example}{code:csharp|title=C#}

          ExcelTemplate xlt = new ExcelTemplate();

          //--- Do something with template here

          ExcelApplication xla = new ExcelApplication();
          xla.Open(xlt);
        

{code}
{code:vb.net

|title=vb.net

}

          Dim xlt As New ExcelTemplate()

          '--- Do something with template here

          Dim xla As New ExcelApplication()
          xla.Open(xlt)
        {code}

{example}