Load(String,IPackageFactory,Boolean) Method

Reads a workbook from a file.

Syntax

Visual Basic

'Declaration
 
Public Overloads Shared Function Load( _
   ByVal fileName As String, _
   ByVal packageFactory As IPackageFactory, _
   ByVal verifyExcel2007Xml As Boolean _
) As Workbook

C#

public static Workbook Load( 
   string fileName,
   IPackageFactory packageFactory,
   bool verifyExcel2007Xml
)

Parameters

fileName

The file from which to read the workbook.

packageFactory

An IPackageFactory which can be used to open an IPackage from a stream.

verifyExcel2007Xml

A boolean specifying whether or not to verify the contents of the markup against the rules defined in Part 2 of the 'Office Open XML - Open Packaging Conventions' document (see final draft, ECMA document TC45).

Return Value

The workbook loaded from the file.

Exceptions

Exception	Description
System.ArgumentException	fileName is a path to an invalid Microsoft Excel file.
System.ArgumentException	The file format cannot be determined from the specified file.
System.InvalidOperationException	The format of the workbook data is in an unsupported format.
System.NotSupportedException	packageFactory is null and the workbook being loaded is in an Excel 2007 format and the CLR 2.0 Excel assembly is being used. An Infragistics.Documents.Core.Packaging.IPackageFactory must be specified so the Excel 2007 file package can be accessed.
Infragistics.Documents.Core.DocumentEncryptedException	Occurs when the workbook is encrypted and no password was specified to open the file via WorkbookLoadOptions.OpenPassword.
Infragistics.Documents.Core.EncryptionAlgorithmNotSupportedException	Occurs when the workbook is encrypted with an unsupported encryption algorithm and cannot be decrypted.

Remarks

When loading the workbook, the format will be determined the file extension or by the contents of the file. If the extension is a standard Excel format extension, the workbook will be assumed to be in the corresponding format. Otherwise, the contents of the file will be examined to try to determine the format. The CurrentFormat of the returned workbook will indicate the format the workbook was loaded from.

Note: This method creates a System.IO.FileStream using the FileStream(string, FileMode) overload of the constructor. See the remarks section of this overload for the exceptions that could be thrown.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2