Skip to main content

WorkbookImportOptions Members

Contains options used for loading (importing) workbooks.

Constructors

Name	Description
WorkbookImportOptions()	Initializes a new instance of the WorkbookImportOptions class with the default settings.

Properties

Name	Description
Csv	Provides access to options specific for importing documents in CSV format.
FallbackFormat	Gets or sets the format that is used if no distinct format can be specified or recognized.
OpenXml	Provides access to options specific to importing documents in OpenXml format (aka default MS Excel 2007 format or .xlsx).
Password	Gets or sets a password used to unprotect a password-protected document during import.
ThrowExceptionOnInvalidDocument	Specifies whether an exception should be thrown when importing an invalid document.
Txt	Provides access to options specific to importing documents in TXT format.
WorksheetNameValidationType	Specifies how to validate worksheet names when importing workbooks.
Xls	Provides access to options specific for importing documents in XLS format (MS Excel 97-2003 binary file format).
Xlsb	Provides access to options used to import documents in the XLSB format (Microsoft Excel 2007-2010 binary file format).
Xlsm	Provides access to options specific to importing documents in OpenXML format with macro support.
Xlsx	Provides access to options specific to importing documents in OpenXml format (aka default MS Excel 2007 format or .xlsx).
Xlt	Provides access to options specific to importing documents from XLT format (Microsoft Excel 97-2003 Template).
Xltm	Provides access to options specific to importing documents from XLM format (MS Excel macro file format).
Xltx	Provides access to options specific to importing documents from XLTX format (MS Excel template).
XmlSpreadsheet2003	Provides access to options used to import documents in XML Spreadsheet 2003 file format.

Name	Description
Assign(BaseOptions)	Copies all settings from the options object passed as a parameter. Inherited from BaseOptions.
BeginUpdate()	Locks the BaseOptions object by disallowing visual updates until the EndUpdate or CancelUpdate method is called. Inherited from BaseOptions.
CancelUpdate()	Unlocks the BaseOptions object after it has been locked by the BeginUpdate method, without causing an immediate visual update. Inherited from BaseOptions.
EndUpdate()	Unlocks the BaseOptions object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from BaseOptions.
Equals(Object, Object) static	Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)	Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode()	Serves as the default hash function. Inherited from Object.
GetType()	Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected	Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static	Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString()	Returns a string representing the currently enabled options. Inherited from BaseOptions.

See Also

WorkbookImportOptions Class

DevExpress.XtraSpreadsheet.Import Namespace

Was this page helpful?

Thanks for your feedback!

How can we improve this help topic?

Add an example/code snippet.

Improve topic clarity.

Improve organization/make it easier to find.

Include additional information/content.

Additional comments/thoughts:

If you have any questions, submit a ticket to our Support Center.

No

Your feedback is appreciated.