Known Exceptions Details in Excel Library

8 Dec 202324 minutes to read

The list of known exceptions thrown in Essential XlsIO is listed below.

ApplicationException

Class

Message

Reason

Workbook "Workbook was not created from file." + " That is why workbook file not specified." + " You must use SaveAs method instead." The file name cannot be empty
Worksheet "Can't deselect all worksheets." Can't deselect all worksheets
"Can't find data for MSODrawing" The value of current mso index cannot greater than array drawings count
"Sheet is already protected, before use unprotect method" The property is true the sheet is already protected
"You cannot use this command on a protected sheet The condition is false you cannot use this command on protected sheet

ArgumentException

Class

Message

Reason

Pictures string cannot be empty. Valid filename of the image must be provided.
Shape From center style support only var_1 or var_2 From center style support only var_1 or var_2
strName cannot be null or empty. String cannot be empty
strShapeName - string cannot be empty. String cannot be empty
The rotation value should be between -3600 and 3600 The rotation value should be between -3600 and 3600
Name cannot be null or empty Name of the UserPicture cannot be empty.
Path cannot be null or empty Path of the UserPicture cannot be null or empty.
Path cannot be null or empty Path of the UserTexture cannot be empty.
Shape name cannot be null. Valid name is not found for the shape.
The specified value is out of range TextureHorizontalScale must be >= 21475.
 The specified value is out of range TextureOffsetX must be >= 169056.
 The specified value is out of range TextureOffsetY must be >= 169056.
 The specified value is out of range TextureVerticalScale must be >= 21475.
This method supports only preset textured Custom gradient texture does not support.
TransparencyColor The TransparencyFrom on shape should not be less than 0 and greater than 1.
TextBox "Reference is not valid The value of the string index 0 is equal to "=" the reference is not valid
Workbook "Can't refer to external worksheets" Cannot refer to external workbook
"FileName cannot be empty." The file name cannot be empty
"fileName" String cannot be empty
"name" String cannot be empty
"Names array must contain at least one name." Names array must contain at least one name
"separator" String cannot be empty
"strFileName - string cannot be empty." String cannot be empty
"strName - string cannot be empty" String cannot be empty
"strSheetName" String cannot be empty
"Workbook is protected and password wasn't specified." Workbook is protected and password wasn't specified
"Contains invalid characters Contains invalid characters
"FileName cannot be empty. The file name cannot be empty
Worksheet "arrDataColumns can't be empty" String cannot be empty
"Cannot sets formula value in cell that doesn't contain formula" Cannot sets formula value in cell that doesn't contain formula
"Can't insert column" Cannot insert column given condition is false
"Can't insert row" Cannot insert row given condition is true
"cellFormat" The array extend formats count is not less than cell format index value
"defaultStyle" The XF index value is not equal to minimum value of the integer
"Each range argument should contain a single cell" Each range argument should contain a single cell
"FileName cannot be empty." File name cannot be empty
"Image Path doesn't exist" Image path does not exist
"Ranges do not fit each other" The Ranges do not fit each other
"separator" String cannot be null or empty
"strName - string cannot be empty." String cannot be empty
"Workbook at least must contains one worksheet. You cannot remove last worksheet.", "sheet" Workbook at least must contain one worksheet. You cannot remove last worksheet
"Workbook must contains at least one worksheet. You cannot remove last worksheet.", "sheet" Workbook must contain at least one worksheet. You cannot remove last worksheet
"Invalid column index. The column index is not less than 0 and greater than 0x3fff
"Invalid row index. The row index is not less than 0 and greater than 0xfffff
"separator String cannot be empty
Sheet Name is InValid Sheet Name is InValid

ArgumentNullException

Class

Message

Reason

Workbook "Name can't be NULL." Name can't be NULL
"separator" The string cannot be empty
"styleIndexes" The style index is not equal to null
"password String cannot be empty
Worksheet "Conditions" The condition property is not null and CFExRecords property is not equal to null
"firstColumn" The column index value is not equal to 0 and greater than book maximum column count
"password" The string cannot be empty
"separator" String cannot be empty
"dataSource String cannot be empty

ArgumentOutOfRangeException

Class

Message

Reason

PageSetup Parts array must have only three elements. The header/footer string should have 3 parts.
The string is too long. Reduce the number of characters used. The header/footer value exceeds the characters limit.
Zoom value must be between 10 and 400 percent. The zoom value in page setup should me within the given limit.
Shape BottomRowOffset The BottomRowOffset should not be less than 0.
Height The Height should not be less than 0.
iColumn1 The column should not be less than 1 and greater than maximum column count.
iColumn2 The column should not be less than 1 and greater than maximum column count.
iPixels The pixels should not be less than 0 and greater than row height.
Can't be less than zero. The iPixels should not be less than 0.
iRow1 The row value should not be less than 1 and greater than maximum row count.
iRow2 The row value should not less than 1 and greater than maximum row count.
LeftColumnOffset The LeftColumnOffset should not be less than 0.
RightColumnOffset The RightColumnOffset should not be less than 0.
scaleHeight The ScaleHeight should not be less than 0.
scaleWidth The ScaleWidth should not be less than 0.
TopRowOffset The TopRowOffset should not be less than 0.
Value The Transparency should not be less than 0 and greater than 1.
Weight The Weight should not be less than 0 and greater than maximum line weight value.
Width The Width should not be less than 0.
iPixels can't be less than zero. The iPixels should not be less than 0
Gradient degree is out of range The gradient range should not be less than -1 and greater than 1.
Transparency The Transparency on shape should not be less than 0 and greater than 1.
TransparencyFrom The TransparencyFrom value on shape should not be less than 0 and greater than 1.
TransparencyTo The TransparencyTo value on shape should not be less than 0 and greater than 1.
Workbook "ActiveSheetIndex" The sheet value is not less than 0 and greater than list object count
"Array cannot contain more than 4 selection records" Array cannot contain more than 4 selection records
"DisplayedTab", "Displayed tab must be greater than zero and less than Worksheets count" Displayed tab must be greater than zero and less than Worksheets count
"fileName" The file name cannot be empty
"fullName" String cannot be empty
"index" Value cannot be less than 0 and greater than Count
"index", "Index cannot be less than 0 and larger than Palette colors array size." Index cannot be less than 0 and larger than Palette colors array size
"index", "Value cannot be less than 0 and greater than Count - 1." Value cannot be less than 0 and greater than Count - 1
"iRef" The reference index value is not less than or equal to extern sheet reference and less than 0;
"iReferenceIndex", "Value cannot be less than 0 and greater than arrRefs.Count - 1" Value cannot be less than 0 and greater than arrRefs.Count - 1
"iStartIndex" The start index value is not less than stro0 and greater than color count
"maxCount" The XF index value is not less than or equal to 0
"PasswordToOpen", "Password too long. Maximum password length is 15 characters." Password too long. Maximum password length is 15 characters
"referenceIndex", "Value cannot be less than 0 and greater than arrRefs.Count - 1" Value cannot be less than 0 and greater than arrRefs.Count - 1
"sheetsQuantity", "Quantity of worksheets must be greater than zero." Quantity of worksheets must be greater than zero
string.Format( "index is {0}, Count is {1}", index, List.Count) Index value is not less than 0 and not greater than equal to list count
string.Format("index is {0}, Count is {1}", index, count) Index value is not less than 0 and not greater than equal to list count
Worksheet "Apostrophe can't be used as first and/or last character of the worksheet's name." Apostrophe can't be used as first and/or last character of the worksheet's name
"Chart index" Index value is not less than 0 and not greater than equal to list count
"column index" The column index value is not equal to 0 and greater than book maximum column count
"Column", "Column index cannot be larger then 256 or less then one" Column index cannot be larger than 256 or less than one
"columnIndex", "Value cannot be less than 0 and greater than 255" Value cannot be less than 0 and greater than 255
"count" The count is not less than 0
"drawingItemName" The string name cannot be empty
"firstColumn" The column index value is not equal to 0 and greater than book maximum column count
"firstRow" The row index value is not equal to 0 and greater than book maximum rows count
"iColumn can't be less than 1" iColumn can't be less than 1
"iColumnCount", "Value cannot be less 1 and greater than max column index" Value cannot be less 1 and greater than max column index
"iColumnIndex", "Column index is out of range." Column index is out of range
"iColumnIndex", "Value cannot be less 1 and greater than max column index." Value cannot be less 1 and greater than max column index.
"iColumnIndex", "Value cannot be less than 1 and greater than m_book.MaxColumnCount." Value cannot be less than 1 and greater than m_book.MaxColumnCount
"iCondFmtPos" The index value is not less than 0
"iCustomPropertyPos" Index value is not less than 0 and not greater than equal to list count
"iDValPos" The integer value is not less than 0
"index < 0" The index value is not less than 0
"index" Index value is not less than 0 and not greater than equal to list count
"index", "Value cannot be less than 0 and greater than Count - 1." Value cannot be less than 0 and greater than Count - 1
"iNewIndex" Index value is not less than 0 and not greater than equal to list count
"iOldIndex" Index value is not less than 0 and not greater than equal to list count
"iRowIndex" The row index value is not equal to 0 and greater than book maximum rows count
"iRowIndex", "Value cannot be less 1 and greater than max row index." Value cannot be less 1 and greater than max row index
"iRowIndex", "Value cannot be less than 1 and greater than m_book.MaxColumnCount." Value cannot be less than 1 and greater than m_book.MaxColumnCount
"iSSTIndex" The shared string index value is not less than 0 or greater than book inner shared string count
"iStartIndex" The index value is not less than 0
"Length of the password can't be more than " + DEF_MAX_PASSWORDLEN The password length value is greater than default maximum password length
"maxCount" The index value is not less than or equal to 0
"range" The range of the row and column is not equal to range of the last column and last row
"rowIndex" The row index value is not less than 1 and greater than book maximum count
"Standard Row Height" The standard row height value is not less than 0
"Text value cannot be null or empty" Text value cannot be null or empty
"Text value cannot be null or empty. First symbol must be '#'" Text value cannot be null or empty. First symbol must be '#'
"Text value cannot be null or empty. First symbol of formula cannot be '='" Text value cannot be null or empty. First symbol of formula cannot be '='
"Value cannot be less 1 and greater than max column index." Value cannot be less 1 and greater than maximum column index
"Value does not valid error string." Given value does not contains dictionary
"Worksheets collection does not contain specified worksheet." Worksheets collection does not contain specified worksheet
"Zoom", "Zoom must be in range from 10 till 400." Zoom must be in range from 10 till 400.
strParentItemName The string name cannot be empty
Column value cannot be less than 0 and greater than 255 Value cannot be less than 0 and greater than 255
End Row Index cannot be greater than max row index Value cannot be greater than max row index
firstColumn The column index value is not equal to 0 and greater than book maximum column count
firstRow The row index value is not equal to 0 and greater than book maximum rows count
Length of the password can't be more than password length The password length value is greater than default maximum password length
Row Index value cannot be less than 1 and greater than max row index The row index value is not equal to 0 and greater than book maximum rows count
Standard Column Width. The standard column width value is not less than 0 and greater than default maximum column width
Value cannot be less 1 and greater than max column index. Value cannot be less 1 and greater than max column index
Value cannot be less 1 and greater than max row index. Value cannot be less 1 and greater than max row index
Value must be 0 to 3 Value must be 0 to 3
string.Format("index is {0}, Count is {1}", index, List.Count) Index value is not less than 0 and not greater than equal to list count

ExcelWorkbookNotSavedException

Class

Message

Reason

Workbook "Object cannot be disposed." + " Save workbook or set property ThrowNotSavedOnDestroy to false. Save workbook or set property ThrowNotSavedOnDestroy to false

FileNotFoundException

Class

Message

Reason

Shape File represents by current path doesn't exist File represents by current path doesn't exist.
Workbook "File could not be found. Please verify the file path." "File could not be found.
string.Format("File {0} could not be found. Please verify the file path.", filename) The file name is not there in given file path the exception will throw

InvalidRangeException

Class

Message

Reason

Worksheet Can't copy to destination range The destination array formula not separator the cannot copy to destination range

NotSupportedException

Class

Message

Reason

Shape This property can be set only when Gradient Style is selected. This property can be set only when Gradient Style is selected.
This property supports only if pattern style is checked This property supports only if pattern style is checked.
This property supports only if pattern style is checked This property supports only if texture style is checked.
This property support only if defined user texture of picture This property support only if defined user texture of picture.
"This property supports only if Checked Solid style." This property supports only if Solid style is checked
"This shape doesn't support fill properties." The m_bSupportOption is false the fill format not supported
"This shape doesn't support line properties." The m_bSupportOption is false the line format not supported
HyperLink The shape is not equal to AutoShape, picture, textbox does not supported in hyperlink
This property supported only if checked preset color type Supports only Excel gradient preset.
This property supports only if checked one color gradient Supports only Excel gradient preset.
This variant doesn't support center shading style. The shape object doesn't support center shading style.
Workbook "Name of worksheet must be unique in a workbook." Name of worksheet must be unique in a workbook
"Not supported encryption type." This property is not supported for encryption type
"Weak encryption algorithm is not supported." Weak encryption algorithm is not supported.
Worksheet Name of worksheet must be unique in a workbook Name of worksheet must be unique in a workbook