Known Exceptions Details in Excel Library
29 Nov 202424 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 |