Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{description}
{excerpt}Opens an existing Excel spreadsheet.{excerpt}
{signature:C#}
 public virtual Workbook Open(System.String fileName)
{signature}{signature:vb.net}
Public Overridable Function Open(ByVal fileName As String) As Workbook
{signature}
{parameters}
{param:fileName}The path and name of the file to open. The path can be relative or  absolute. The file must be a OOXML format \(Excel 2007 or later\) .xlsx file or BIFF8 format \(Excel 97 or later\) .xls file.{param}
{returns}A [Workbook|Workbook] object representing the file opened.{returns}
{exceptions}
{exception:System.Exception}If the file cannot be found or opened, or if ExcelWriter cannot parse the file as a OOXML or BIFF8 file.{exception}
{remarks}ExcelWriter supports  Excel's OOXML \(Excel 2007 or later\) and BIFF8 \(Excel 97 or later\) format only.  Do not use  this method  to open BIFF7 \(Excel 95\) files.

{remarks}
{example}{code:csharp|title=C#}

          Workbook wb = xla.Open(@"C:\Reports\Report.xlsx");
        {code}
{code:vb.net|title=vb.net}
Dim wb As Workbook = xla.Open("C:\Reports\Report.xlsx"){code}

{example}