Page History

...

{introducedin:7.1.0.1855

...

}
{description}
{excerpt}Opens a spreadsheet from a SharePoint List Item. 
{excerpt}
{signature:C#}
public static void Open(this ExcelTemplate template, Microsoft.SharePoint.SPListItem listItem, String fileName)

{signature}
{signature:vb.net

}
Public Shared Sub Open(ByVal template As ExcelTemplate, ByVal listItem As Microsoft.SharePoint.SPListItem, ByVal fileName As String)

...

The current ExcelTemplate object which is opening the file

...

SharePoint List Item to which the file is attached

...

The name of the file to open. The file must be a BIFF8 format (Excel 97 or later) .xls or .xlt file or an OOXML format .xlsx, .xlsm, .xltx, or .xltm file.

{signature}
{parameters}
{param:template}The current ExcelTemplate object which is opening the file
{param}
{param:listItem}
SharePoint List Item to which the file is attached
{param}
{param:fileName}The name of the file to open. The file must be a BIFF8 format \(Excel 97 or later\) .xls or .xlt file or an OOXML format .xlsx, .xlsm, .xltx, or .xltm file.
{param}
{exceptions}
{exception:ArgumentNullException}[Open|ExcelTemplate.Open] will throw this exception if {{null}} \(C\#\) or {{Nothing}} \(VB.NET\) is passed to the method.
{exception}
{exception:ArgumentException}
{exception}
{remarks}
{note}This is an extension method for the ExcelTemplate object to be used for opening spreadsheets from SharePoint List Items.  To use this method, you must add a reference to SoftArtisans.OfficeWriter.ExcelWriter.SharePointIntegration.dll{note}

{remarks}