Wiki Markup |
---|
{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 {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} |
Page History
Overview
Content Tools