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
{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)
{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}