public class WorkbooksCollection : CollectionBaseEx<IWorkbook>, IList<IWorkbook>, ICollection<IWorkbook>, IParentApplication, ICloneParent, IWorkbooks, IEnumerable<IWorkbook>, IEnumerable

Constructors

WorkbooksCollection(IApplication, Object)

Creates workbook and sets its Application and Parent properties.

Declaration

public WorkbooksCollection(IApplication application, object parent)

Parameters

Type	Name	Description
IApplication	application	Application object for the collection.
System.Object	parent	Parent object for the collection.

Properties

Item[Int32]

Returns a single object from a collection.

Declaration

public IWorkbook this[int Index] { get; }

Parameters

Type	Name	Description
System.Int32	Index

Property Value

Type
IWorkbook

Methods

Close()

Closes the object.

Declaration

public void Close()

Create()

Create new empty workbook and make it active.

Declaration

public IWorkbook Create()

Returns

Type	Description
IWorkbook	Interface on instance of newly created workbook.

Create(Int32)

Create workbook with specified number of empty worksheets.

Declaration

public IWorkbook Create(int sheetsQuantity)

Parameters

Type	Name	Description
System.Int32	sheetsQuantity	Number of worksheets to create.

Returns

Type	Description
IWorkbook	Interface on instance of created workbook.

Exceptions

Type	Condition
System.ArgumentOutOfRangeException	When sheetsQuantity is less than zero.

Create(String[])

Create workbook with names.Length quantity of worksheets. Each worksheet name will be set to corresponding names array element.

Declaration

public IWorkbook Create(string[] names)

Parameters

Type	Name	Description
System.String[]	names	Array of names for each worksheet.

Returns

Type	Description
IWorkbook	Interface on instance of created workbook.

Exceptions

Type	Condition
System.ArgumentNullException	When names array is NULL.
System.ArgumentException	When names does not contain any value.

Open(Stream)

Read workbook from the stream.

Declaration

public IWorkbook Open(Stream stream)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.

Returns

Type	Description
IWorkbook	Newly created workbook.

Open(Stream, ExcelOpenType)

Opens a workbook.

Declaration

public IWorkbook Open(Stream stream, ExcelOpenType openType)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelOpenType	openType	Represents type of the file for open operation.

Returns

Type	Description
IWorkbook	Opened workbook.

Open(Stream, ExcelOpenType, ExcelParseOptions)

Opens a workbook.

Declaration

public IWorkbook Open(Stream stream, ExcelOpenType openType, ExcelParseOptions options)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelOpenType	openType	Represents type of the file for open operation.
ExcelParseOptions	options

Returns

Type	Description
IWorkbook	Opened workbook.

Open(Stream, ExcelOpenType, ExcelVersion)

Opens a workbook.

Declaration

public IWorkbook Open(Stream stream, ExcelOpenType openType, ExcelVersion version)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelOpenType	openType	Represents type of the file for open operation.
ExcelVersion	version

Returns

Type	Description
IWorkbook	Opened workbook.

Open(Stream, ExcelParseOptions)

Read workbook from the stream.

Declaration

public IWorkbook Open(Stream stream, ExcelParseOptions options)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelParseOptions	options	Parse options.

Returns

Type	Description
IWorkbook	Newly created workbook.

Open(Stream, ExcelParseOptions, Boolean, String)

Opens the specified stream.

Declaration

public IWorkbook Open(Stream stream, ExcelParseOptions options, bool isReadOnly, string password)

Parameters

Type	Name	Description
System.IO.Stream	stream	The stream.
ExcelParseOptions	options	Parse options.
System.Boolean	isReadOnly	Indicates is open book in read - only mode.
System.String	password	Represents valid password for opening workbook.

Returns

Type	Description
IWorkbook	Opened workbook.

Open(Stream, ExcelParseOptions, Boolean, String, ExcelOpenType)

Opens the specified stream.

Declaration

public IWorkbook Open(Stream stream, ExcelParseOptions options, bool isReadOnly, string password, ExcelOpenType openType)

Parameters

Type	Name	Description
System.IO.Stream	stream	The stream.
ExcelParseOptions	options	Parse options.
System.Boolean	isReadOnly	Indicates is open book in read - only mode.
System.String	password	Represents valid password for opening workbook.
ExcelOpenType	openType	Represents type of the file for open operation.

Returns

Type	Description
IWorkbook	Opened workbook.

Open(Stream, ExcelParseOptions, Boolean, String, ExcelVersion)

Opens the specified stream.

Declaration

public IWorkbook Open(Stream stream, ExcelParseOptions options, bool isReadOnly, string password, ExcelVersion excelVersion)

Parameters

Type	Name	Description
System.IO.Stream	stream	The stream.
ExcelParseOptions	options	Parse options.
System.Boolean	isReadOnly	Indicates is open book in read - only mode.
System.String	password	Represents valid password for opening workbook.
ExcelVersion	excelVersion

Returns

Type	Description
IWorkbook	Opened workbook.

Open(Stream, ExcelVersion)

Read workbook from the stream.

Declaration

public IWorkbook Open(Stream stream, ExcelVersion version)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelVersion	version	Version of the excel file format.

Returns

Type	Description
IWorkbook	Newly created workbook.

Open(Stream, ExcelVersion, ExcelParseOptions)

Read workbook from the stream.

Declaration

public IWorkbook Open(Stream stream, ExcelVersion version, ExcelParseOptions options)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelVersion	version	Version of the excel file format.
ExcelParseOptions	options

Returns

Type	Description
IWorkbook	Newly created workbook.

Open(Stream, String)

Opens a Workbook using separator.

Declaration

public IWorkbook Open(Stream stream, string separator)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream to open.
System.String	separator	Denotes separator for the CSV file types.

Returns

Type	Description
IWorkbook	Opened WorkBook.

Open(Stream, String, ExcelVersion)

Opens a Workbook using separator.

Declaration

public IWorkbook Open(Stream stream, string separator, ExcelVersion version)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream to open.
System.String	separator	Denotes separator for the CSV file types.
ExcelVersion	version

Returns

Type	Description
IWorkbook	Opened WorkBook.

Open(Stream, String, Int32, Int32)

Opens a Workbook using separator.

Declaration

public IWorkbook Open(Stream stream, string separator, int row, int column)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream to open.
System.String	separator	Denotes separator for the CSV file types.
System.Int32	row	Number of first row to write.
System.Int32	column	Number of first column to write.

Returns

Type	Description
IWorkbook	Opened WorkBook.

Open(Stream, String, Int32, Int32, Encoding)

Opens a Workbook using separator.

Declaration

public IWorkbook Open(Stream stream, string separator, int row, int column, Encoding encoding)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream to open.
System.String	separator	Denotes separator for the CSV file types.
System.Int32	row	Number of first row to write.
System.Int32	column	Number of first column to write.
System.Text.Encoding	encoding	Encoding to use to parse text data.

Returns

Type	Description
IWorkbook	Opened WorkBook.

Open(Stream, String, Encoding)

Opens a Workbook using separator.

Declaration

public IWorkbook Open(Stream stream, string separator, Encoding encoding)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream to open.
System.String	separator	Denotes separator for the CSV file types.
System.Text.Encoding	encoding	Encoding to use to parse text data.

Returns

Type	Description
IWorkbook	Opened WorkBook.

Open(Stream, Encoding)

Opens a Workbook using default separator.

Declaration

public IWorkbook Open(Stream stream, Encoding encoding)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream to open.
System.Text.Encoding	encoding	Encoding to use to parse text data.

Returns

Type	Description
IWorkbook	Opened WorkBook.

OpenAsync(Stream)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, ExcelOpenType)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, ExcelOpenType openType)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelOpenType	openType	Represents type of the file for open operation.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, ExcelOpenType, ExcelParseOptions)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, ExcelOpenType openType, ExcelParseOptions options)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelOpenType	openType	Represents open type for open.
ExcelParseOptions	options	Parse options.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, ExcelParseOptions, Boolean, String)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, ExcelParseOptions options, bool isReadOnly, string password)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelParseOptions	options	Parse options.
System.Boolean	isReadOnly	Indicates is open book in read - only mode.
System.String	password	Represents valid password for opening workbook.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, ExcelParseOptions, Boolean, String, ExcelVersion)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, ExcelParseOptions options, bool isReadOnly, string password, ExcelVersion excelVersion)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelParseOptions	options	Parse options.
System.Boolean	isReadOnly	Indicates is open book in read - only mode.
System.String	password	Represents valid password for opening workbook.
ExcelVersion	excelVersion	Workbook version.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, ExcelVersion)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, ExcelVersion version)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelVersion	version	Workbook version.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, ExcelVersion, ExcelParseOptions)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, ExcelVersion version, ExcelParseOptions options)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelVersion	version	Workbook version.
ExcelParseOptions	options	Parse options.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, String)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, string separator)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
System.String	separator	Current seperator.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, String, ExcelVersion)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, string separator, ExcelVersion version)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
System.String	separator	Current seperator.
ExcelVersion	version	Workbook version.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, String, Int32, Int32)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, string separator, int row, int column)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
System.String	separator	Separator to use.
System.Int32	row	Number of first row to write
System.Int32	column	Number of first column to write.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, String, Int32, Int32, String, Encoding, ExcelVersion)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, string separator, int row, int column, string fileName, Encoding encoding, ExcelVersion version)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
System.String	separator	Separator to use.
System.Int32	row	Number of first row to write.
System.Int32	column	Number of first column to write.
System.String	fileName	Name of the file.
System.Text.Encoding	encoding	Encoding to use to parse text data.
ExcelVersion	version	Workbook version.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, String, Int32, Int32, Encoding)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, string separator, int row, int column, Encoding encoding)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
System.String	separator	Separator to use.
System.Int32	row	Number of first row to write.
System.Int32	column	Number of first column to write.
System.Text.Encoding	encoding	Encoding to use to parse text data.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(Stream, String, Encoding)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenAsync(Stream stream, string separator, Encoding encoding)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
System.String	separator	Current seperator.
System.Text.Encoding	encoding	Encoding to use to parse text data.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, ExcelOpenType)

Opens a workbook.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, ExcelOpenType openType)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
ExcelOpenType	openType	Represents type of the file for open operation.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, ExcelOpenType, ExcelParseOptions)

Opens a workbook.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, ExcelOpenType openType, ExcelParseOptions options)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
ExcelOpenType	openType	Represents type of the file for open operation.
ExcelParseOptions	options	Parse options.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, ExcelParseOptions, Boolean, String)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, ExcelParseOptions options, bool isReadOnly, string password)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
ExcelParseOptions	options	Parse options.
System.Boolean	isReadOnly	Indicates is open book in read - only mode.
System.String	password	Represents valid password for opening workbook.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, ExcelParseOptions, Boolean, String, ExcelVersion)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, ExcelParseOptions options, bool isReadOnly, string password, ExcelVersion excelVersion)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
ExcelParseOptions	options	Parse options.
System.Boolean	isReadOnly	Indicates is open book in read - only mode.
System.String	password	Represents valid password for opening workbook.
ExcelVersion	excelVersion	Workbook version.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, ExcelVersion)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, ExcelVersion version)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
ExcelVersion	version	Workbook version.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, ExcelVersion, ExcelParseOptions)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, ExcelVersion version, ExcelParseOptions options)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
ExcelVersion	version	Workbook version.
ExcelParseOptions	options	Parse options.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, String)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, string separator)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
System.String	separator	Current separator.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, String, ExcelVersion)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, string separator, ExcelVersion version)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
System.String	separator	Current separator.
ExcelVersion	version	Workbook version.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, String, Int32, Int32)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, string separator, int row, int column)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
System.String	separator	Separator to use.
System.Int32	row	Number of first row to write.
System.Int32	column	Number of first column to write.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, String, Int32, Int32, String, Encoding, ExcelVersion)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, string separator, int row, int column, string fileName, Encoding encoding, ExcelVersion version)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
System.String	separator	Separator to use.
System.Int32	row	Number of first row to write.
System.Int32	column	Number of first column to write.
System.String	fileName	Name of the file.
System.Text.Encoding	encoding	Encoding to use to parse text data.
ExcelVersion	version	Workbook version.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, String, Int32, Int32, Encoding)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, string separator, int row, int column, Encoding encoding)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
System.String	separator	Separator to use.
System.Int32	row	Number of first row to write.
System.Int32	column	Number of first column to write.
System.Text.Encoding	encoding	Encoding to use to parse text data.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenAsync(StorageFile, String, Encoding)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenAsync(StorageFile storageFile, string separator, Encoding encoding)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
System.String	separator	Current separator.
System.Text.Encoding	encoding	Encoding to use to parse text data.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenFromXml(Stream, ExcelXmlOpenType)

Read workbook from xml file.

Declaration

public IWorkbook OpenFromXml(Stream stream, ExcelXmlOpenType openType)

Parameters

Type	Name	Description
System.IO.Stream	stream	Path to xml file.
ExcelXmlOpenType	openType	Xml open type.

Returns

Type	Description
IWorkbook	Returns opened workbook.

OpenFromXml(XmlReader, ExcelXmlOpenType)

Read workbook from xml stream.

Declaration

public IWorkbook OpenFromXml(XmlReader reader, ExcelXmlOpenType openType)

Parameters

Type	Name	Description
System.Xml.XmlReader	reader	Xml reader.
ExcelXmlOpenType	openType	Xml open type.

Returns

Type	Description
IWorkbook	Returns opened workbook.

OpenFromXmlAsync(Stream, ExcelXmlOpenType)

Read workbook from the stream.

Declaration

public Task<IWorkbook> OpenFromXmlAsync(Stream stream, ExcelXmlOpenType openType)

Parameters

Type	Name	Description
System.IO.Stream	stream	Stream with workbook's data.
ExcelXmlOpenType	openType	Represents open type for open.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenFromXmlAsync(XmlReader, ExcelXmlOpenType)

Read workbook from the reader.

Declaration

public Task<IWorkbook> OpenFromXmlAsync(XmlReader reader, ExcelXmlOpenType openType)

Parameters

Type	Name	Description
System.Xml.XmlReader	reader
ExcelXmlOpenType	openType	Represents open type for open.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

OpenFromXmlAsync(StorageFile, ExcelXmlOpenType)

Opens a random-access storage over the file.

Declaration

public Task<IWorkbook> OpenFromXmlAsync(StorageFile storageFile, ExcelXmlOpenType openType)

Parameters

Type	Name	Description
Windows.Storage.StorageFile	storageFile	Provides information about the file and its content, and ways to manipulate them.
ExcelXmlOpenType	openType	Represents type of the file for open operation.

Returns

Type	Description
System.Threading.Tasks.Task<IWorkbook>	Opened workbook.

Implements

System.Collections.Generic.IList<>

System.Collections.Generic.ICollection<>

IParentApplication

ICloneParent

IWorkbooks

System.Collections.Generic.IEnumerable<>

System.Collections.IEnumerable

Extension Methods

DateTimeExtension.ToDateTime(Object)