Represents diagonal crosshatch pattern.

Represents diagonal stripe pattern.

Represents 6.25% gray pattern

Represents 12.5% gray pattern

Represents 25% gray pattern.

Represents 50% gray pattern.

Represents 75% gray pattern.

Represents horizontal stripe pattern.

Represents no background.

Represents reverse diagonal stripe pattern.

Represents solid pattern.

Represents thick diagonal crosshatch pattern.

Represents thin diagonal crosshatch pattern.

Represents thin diagonal stripe pattern.

Represents thin horizontal crosshatch pattern.

Represents thin horizontal stripe pattern.

Represents thin reverse diagonal stripe pattern.

Represents thin vertical stripe pattern.

Represents vertical stripe pattern.

Enumerates the border line and diagonal line types.

Represents bottom border line.

Represents the diagonal line from top left to right bottom.

Represents the diagonal line from bottom left to right top.

Represents left border line.

Represents right border line exists.

Represents top border line.

Only for dynamic style,such as conditional formatting.

Only for dynamic style,such as conditional formatting.

Enumerates strategies for handling calculation precision. Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calculated as the expected result. Such as formula "=-0.45+0.43+0.02", when calculating operands by '+' operator directly, the result is not zero. For such kind of precision issue, some special strategies may give the expected result.

No strategy applied on calculation. When calculating just use the original double value as operand and return the result directly. Most efficient for performance and applicable for most cases.

Rounds the calculation result according with significant digits.

Uses decimal as operands when possible. Most inefficient for performance.

Enumerates a cell's border type.

Represents thin dash-dotted line.

Represents thin dash-dot-dotted line.

Represents dashed line.

Represents dotted line.

Represents double line.

Represents hair line.

Represents medium dash-dotted line.

Represents medium dash-dot-dotted line.

Represents medium dashed line.

Represents no line.

Represents medium line.

Represents slanted medium dash-dotted line.

Represents thick line.

Represents thin line.

Specifies how to apply style for the value of the cell.

Not formatted.

Only formatted with the cell's original style.

Formatted with the cell's displayed style.

Gets the displayed string shown in ms excel. The main difference from DisplayStyle is this option also considers the effect of column width. If the column width is too small to show the formatted string completely, "#" may be shown, just like what ms excel does.

Cell value is boolean.

Cell value is datetime.

Cell contains error value

Blank cell.

Cell value is numeric.

Cell value is string.

Cell value type is unknown.

Automatic color.

It's automatic color,but the displayed color depends the setting of the OS System.

Not supported.

The RGB color.

The color index in the color palette.

The theme color.

Represents consolidation function.

Represents Sum function.

Represents Count function.

Represents Average function.

Represents Max function.

Represents Min function.

Represents Product function.

Represents Count Nums function.

Represents StdDev function.

Represents StdDevp function.

Represents Var function.

Represents Varp function.

Represents Distinct Count function.

Only valid for PivotTable with Data Module created since by 2013.

Specifies the axis position for a range of cells with conditional formatting as data bars.

Display the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction. When all values are positive or all values are negative, no axis is displayed.

Display the axis at the midpoint of the cell regardless of the set of values in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction.

No axis is displayed, and both positive and negative values are displayed in the left-to-right direction.

Specifies the border type of a data bar.

The data bar has no border.

The data bar has a solid border.

Specifies how a data bar is filled with color.

The data bar is filled with solid color.

The data bar is filled with a color gradient.

Specifies whether to use the same border and fill color as positive data bars.

Use the color specified in the Negative Value and Axis Setting dialog box or by using the ColorType and BorderColorType properties of the NegativeBarFormat object.

Use the same color as positive data bars.

Specifies how to group dateTime values.

Group by day.

Group by hour.

Group by Minute.

Group by Month.

Group by Second.

Group by Year.

Represents the directory type of the file name.

Represents an MS-DOS drive letter. It is followed by the drive letter. Or UNC file names, such as \server\share\myfile.xls

Indicates that the source workbook is on the same drive as the dependent workbook (the drive letter is omitted)

Indicates that the source workbook is in a subdirectory of the current directory.

Indicates that the source workbook is in the parent directory of the current directory.

Represents whether and how to show objects in the workbook.

Show all objects

Show placeholders

Hide all shapes.

Dynamic filter type.

Shows values that are above average.

Shows values that are below average.

Shows last month's dates.

Shows last quarter's dates.

Shows last week's dates.

Shows last year's dates.

Shows the dates that are in January, regardless of year.

Shows the dates that are in October, regardless of year.

Shows the dates that are in November, regardless of year.

Shows the dates that are in December, regardless of year.

Shows the dates that are in February, regardless of year.

Shows the dates that are in March, regardless of year.

Shows the dates that are in April, regardless of year.

Shows the dates that are in May, regardless of year.

Shows the dates that are in June, regardless of year.

Shows the dates that are in July, regardless of year.

Shows the dates that are in August, regardless of year.

Shows the dates that are in September, regardless of year.

Shows next month's dates.

Shows next quarter's dates.

Shows next week's dates.

Shows next year's dates.

None.

Shows the dates that are in the 1st quarter, regardless of year.

Shows the dates that are in the 2nd quarter, regardless of year.

Shows the dates that are in the 3rd quarter, regardless of year.

Shows the dates that are in the 4th quarter, regardless of year.

Shows this month's dates.

Shows this quarter's dates.

Shows this week's dates.

Shows this year's dates.

Shows today's dates.

Shows tomorrow's dates.

Shows the dates between the beginning of the year and today, inclusive.

Shows yesterday's dates.

Encryption Type. Only used by excel2003. We will encrypt 2007/2010 workbook using SHA AES the same as Excel does, and this EncryptionType will be ignored.

Office 97/2000 compatible.

Represents all error check type.

check for calculation errors

check for references to empty cells

check the format of numeric values

check formulas with references to less than the entirety of a range containing continuous data

check formulas that are inconsistent with formulas in neighboring cells.

check the format of date/time values

check for unprotected formulas

whether to perform data validation

Ignore errors when cells contain a value different from a calculated column formula.

Represents custom exception type code.

Invalid chart setting.

Invalid data type setting.

Invalid data validation setting.

Invalid data validation setting.

Invalid file format.

Invalid formula.

Invalid data.

Invalid operator.

Incorrect password.

Out of MS Excel limitation error.

Invalid page setup setting.

Invalid pivotTable setting.

Invalid drawing object setting.

Invalid sparkline object setting.

Invalid worksheet name.

Invalid worksheet type.

The process is interrupted.

The file is invalid.

Permission is required to open this file.

Unsupported feature.

Unsupported stream to be opened.

Files contains some undisclosed information.

File content is corrupted.

Represents the file format types.

Comma-Separated Values(CSV) text file.

Office Open XML SpreadsheetML file (macro-free).

Office Open XML SpreadsheetML Macro-Enabled file.

Office Open XML SpreadsheetML Template (macro-free).

Office Open XML SpreadsheetML Macro-Enabled Template.

Office Open XML SpreadsheetML addinMacro-Enabled file.

Tab-Separated Values(TSV) text file.

Tab-Separated Values(TSV) text file, same with Tsv

HTML format.

MHTML (Web archive) format.

Open Document Sheet(ODS) file.

Excel97-2003 spreadsheet file.

Excel 2003 SpreadsheetML file.

The Excel Binary File Format (.xlsb)

Represents unrecognized format, cannot be loaded.

PDF (Adobe Portable Document) format.

XPS (XML Paper Specification) format.

Represents a TIFF file.

SVG file.

Represents an Excel95 xls file.

Represents an Excel4.0 xls file.

The file format is not supported

Represents an Excel3.0 xls file.

The file format is not supported

Represents an Excel2.1 xls file.

The file format is not supported

Represents a pptx file.

The file format is not supported Only for detecting file type.

Represents a docx file.

The file format is not supported Only for detecting file type.

Data Interchange Format.

Represents a doc file.

The file format is not supported Only for detecting file type.

Represents a ppt file.

The file format is not supported Only for detecting file type.

Represents a email file.

The file format is not supported Only for detecting file type.

Represents the MS Equation 3.0 object.

The file format is not supported Only for detecting file type.

Represents the embedded native object.

The file format is not supported Only for detecting file type.

Represents MS Visio VSD binary format.

The file format is not supported Only for detecting file type.

Represents MS Visio 2013 VSDX file format.

The file format is not supported Only for detecting file type.

Represents a docm file.

The file format is not supported Only for detecting file type.

Represents a dotx file.

The file format is not supported Only for detecting file type.

Represents a dotm file.

The file format is not supported Only for detecting file type.

Represents a pptm file.

The file format is not supported Only for detecting file type.

Represents a Potx file.

The file format is not supported Only for detecting file type.

Represents a Potm file.

The file format is not supported Only for detecting file type.

Represents a ppsx file.

The file format is not supported Only for detecting file type.

Represents a ppsm file.

The file format is not supported Only for detecting file type.

Represents office open xml file(such as xlsx, docx,pptx, etc).

The file format is not supported Only for detecting file type. If the office open xml file is encrypted, it could not be detected as xlsx ,docx, pptx,etc.

Represents an ODT file.

The file format is not supported Only for detecting file type.

Represents a ODP file.

The file format is not supported Only for detecting file type.

Represents an ODF file.

The file format is not supported Only for detecting file type.

Represents an ODG file.

The file format is not supported Only for detecting file type.

Represents a simple xml file.

The file format is not supported Only for detecting file type.

Excel97-2003 spreadsheet template.

Represents an OTT file.

The file format is not supported Only for detecting file type.

Represents a BMP file.

The file format is not supported Only for detecting file type.

Represents an ots file.

Represents Numbers 9.0 file format by Apple Inc.

Represents Numbers 9.0 file format by Apple Inc.

Represents markdown document.

Represents embedded graph chart.

Represents OpenDocument Flat XML Spreadsheet (.fods) file format.

Represents StarOffice Calc Spreadsheet (.sxc) file format.

Represents a OTP file.

The file format is not supported. Only for detecting file type.

Represents Numbers 3.5 file format since 2014 by Apple Inc

The file format is not supported. Only for detecting file type.

Windows Enhanced Metafile.

Windows Metafile.

JPEG JFIF.

Portable Network Graphics.

Gif

Json

Sql

Rrepesents XHtml file.

Custom Filter operator type.

Represents LessOrEqual operator.

Represents LessThan operator.

Represents Equal operator.

Represents GreaterThan operator.

Represents NotEqual operator.

Represents GreaterOrEqual operator.

Represents no comparison.

Begins with the text.

Ends with the text.

Contains the text.

Not contains the text.

Enumerates the font underline types.

Represents no underline.

Represents single underline.

Represents double underline.

Represents single accounting underline.

Represents double accounting underline.

Represents Dashed Underline

Represents Thick Dash-Dot-Dot Underline

Represents Thick Dash-Dot Underline

Represents Thick Dashed Underline

Represents Long Dashed Underline

Represents Thick Long Dashed Underline

Represents Dash-Dot Underline

Represents Dash-Dot-Dot Underline

Represents Dotted Underline

Represents Thick Dotted Underline

Represents Thick Underline

Represents Wave Underline

Represents Double Wave Underline

Represents Heavy Wave Underline

Represents Underline Non-Space Characters Only

Conditional format rule type.

This conditional formatting rule compares a cell value to a formula calculated result, using an operator.

This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.

This conditional formatting rule creates a gradated color scale on the cells.

This conditional formatting rule displays a gradated data bar in the range of cells.

This conditional formatting rule applies icons to cells according to their values.

This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.

This conditional formatting rule highlights unique values in the range.

This conditional formatting rule highlights duplicated values.

This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text.

This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.

This conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values.

This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.

This conditional formatting rule highlights cells that are completely blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.

This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.

This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.

This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.

This conditional formatting rule highlights cells containing dates in the specified time period. The underlying value of the cell is evaluated, therefore the cell does not need to be formatted as a date to be evaluated. For example, with a cell containing the value 38913 the conditional format shall be applied if the rule requires a value of 7/14/2006.

This conditional formatting rule highlights cells that are above or below the average for all values in the range.

Condition value type.

The minimum/ midpoint / maximum value for the gradient is determined by a formula.

Indicates that the maximum value in the range shall be used as the maximum value for the gradient.

Indicates that the minimum value in the range shall be used as the minimum value for the gradient.

Indicates that the minimum / midpoint / maximum value for the gradient is specified by a constant numeric value.

Value indicates a percentage between the minimum and maximum values in the range shall be used as the minimum / midpoint / maximum value for the gradient.

Value indicates a percentile ranking in the range shall be used as the minimum / midpoint / maximum value for the gradient.

Indicates that the Automatic maximum value in the range shall be used as the Automatic maximum value for the gradient.

Indicates that the Automatic minimum value in the range shall be used as the Automatic minimum value for the gradient.

Represents the command type of header and footer.

The text.

Current page number

Page count

Current date

Current time

Sheet name

File name without path

File path without file name

Picture

Represents five types of html cross string.

Display like MS Excel,depends on the next cell. If the next cell is null,the string will cross,or it will be truncated

Display the string like MS Excel exporting html.

Display HTML cross string, this performance for creating large html files will be more than ten times faster than setting the value to Default or FitToCell.

Display HTML cross string and hide the right string when the texts overlap.

Only displaying the string within the width of cell.

Represents the options for exporting html data.

Export file to html which only contains table part.

Export all the data to html.

Represents two types of showing the hidden columns in html.

Hidden the hidden columns in html page.

Remove the hidden columns in html page.

Represents two types of showing the hidden rows in html.

Hidden the hidden rows in html page.

Remove the hidden rows in html page.

Represents the type of target attribute in HTML tag.

Opens the linked document in a new window or tab

Opens the linked document in the parent frame

Opens the linked document in the same frame as it was clicked (this is default)

Opens the linked document in the full body of the window

Icon set type for conditional formatting. The threshold values for triggering the different icons within a set are configurable, and the icon order is reversible.

3 arrows icon set.

3 gray arrows icon set.

3 flags icon set.

3 signs icon set.

3 symbols icon set (circled).

3 Symbols icon set (uncircled).

3 traffic lights icon set (unrimmed).

3 traffic lights icon set with thick black border.

4 arrows icon set.

4 gray arrows icon set.

4 ratings icon set.

4 'red to black' icon set.

4 traffic lights icon set.

5 arrows icon set.

5 gray arrows icon set.

5 quarters icon set.

5 rating icon set.

3 stars set

5 boxes set

3 triangles set

None

CustomSet. This element is read-only.

3 smilies. Only for .ods.

3 color smilies. Only for .ods.

Represents the options to filter data when loading workbook from template.

Load nothing for sheet data

Load all

Load cells whose value is blank

Load cells whose value is string

Load cells whose value is numeric(including datetime)

Load cells whose value is error

Load cells whose value is bool

Load cells value(all value types) only

Load cell formulas.

Generally defined Name objects(DefinedNames) also need to be loaded when loading formulas because they may be referenced by formulas. So Formula or CellData option should work with DefinedNames option together(Formula|DefinedNames or CellData|DefinedNames) for most scenarios.

Load cells data including values, formulas and formatting

Load charts

Load shapes

Load merged cells

Load conditional formatting

Load data validations

Load pivot tables

Load tables

Load hyperlinks

Load settings for worksheet

Load all data of worksheet, such as cells data, settings, objects, ...etc.

Load settings for workbook

Load settings for workbook and worksheet

Load XmlMap

Load structure of the workbook

Load document properties

Load defined Name objects

Load VBA projects

Load styles for cell formatting

Load pictures

Load OleObjects

Load revision logs

Represents the load file format.

Represents recognizing the format automatically.

Comma-Separated Values(CSV) text file.

Represents Office Open XML spreadsheetML workbook or template, with or without macros.

Tab-Separated Values(TSV) text file.

Represents a tab delimited text file, same with Tsv

Represents a html file.

Represents a mhtml file.

Open Document Sheet(ODS) file.

Represents an Excel97-2003 xls file.

Represents an Excel 2003 xml file.

Represents an xlsb file.

Open Document Template Sheet(OTS) file.

Represents a numbers file.

Represents OpenDocument Flat XML Spreadsheet (.fods) file format.

Represents StarOffice Calc Spreadsheet (.sxc) file format.

Represents a simple xml file.

Represents unrecognized format, cannot be loaded.

Image

Json

Represents look at type.

Cell value Contains the find object.

Cell value Starts with the find object.

Cell value ends with the find object.

Cell value is same as the find object.

Represents look in type.

If the cell contains a formula, find object from formula,else find it from the value.

Only find object from the formatted values.

Only find object from the values of cells which do not contains formula.

Only find object from the comments.

Only find object from formulas.

Only find object from the original values.

Default option for cells model.

This option is applied for all versions.

Memory performance preferrable. With this option the data will be held in compact format so for common scenarios it may give lower memory cost. However, this option also may degrade R/W performance a bit in some special cases.

This option is available since v 8.0.0.

Represents category type of cell's number formatting.

General

Text

Number

Date or Date and Time

Time

Fraction

Scientific

Represents the operator type of conditional format and data validation.

Represents Between operator of conditional format and data validation.

Represents Equal operator of conditional format and data validation.

Represents GreaterThan operator of conditional format and data validation.

Represents GreaterOrEqual operator of conditional format and data validation.

Represents LessThan operator of conditional format and data validation.

Represents LessOrEqual operator of conditional format and data validation.

Represents no comparision.

Represents NotBetween operator of conditional format and data validation.

Represents NotEqual operator of conditional format and data validation.

Represents print orientation constants.

Landscape orientation

Portrait orientation

Represents paper size constants.

Letter (8-1/2 in. x 11 in.)

Letter Small (8-1/2 in. x 11 in.)

Tabloid (11 in. x 17 in.)

Ledger (17 in. x 11 in.)

Legal (8-1/2 in. x 14 in.)

Statement (5-1/2 in. x 8-1/2 in.)

Executive (7-1/4 in. x 10-1/2 in.)

A3 (297 mm x 420 mm)

A4 (210 mm x 297 mm)

A4 Small (210 mm x 297 mm)

A5 (148 mm x 210 mm)

JIS B4 (257 mm x 364 mm)

JIS B5 (182 mm x 257 mm)

Folio (8-1/2 in. x 13 in.)

Quarto (215 mm x 275 mm)

10 in. x 14 in.

11 in. x 17 in.

Note (8-1/2 in. x 11 in.)

Envelope #9 (3-7/8 in. x 8-7/8 in.)

Envelope #10 (4-1/8 in. x 9-1/2 in.)

Envelope #11 (4-1/2 in. x 10-3/8 in.)

Envelope #12 (4-1/2 in. x 11 in.)

Envelope #14 (5 in. x 11-1/2 in.)

C size sheet

D size sheet

E size sheet

Envelope DL (110 mm x 220 mm)

Envelope C5 (162 mm x 229 mm)

Envelope C3 (324 mm x 458 mm)

Envelope C4 (229 mm x 324 mm)

Envelope C6 (114 mm x 162 mm)

Envelope C65 (114 mm x 229 mm)

Envelope B4 (250 mm x 353 mm)

Envelope B5 (176 mm x 250 mm)

Envelope B6 (176 mm x 125 mm)

Envelope Italy (110 mm x 230 mm)

Envelope Monarch (3-7/8 in. x 7-1/2 in.)

Envelope (3-5/8 in. x 6-1/2 in.)

U.S. Standard Fanfold (14-7/8 in. x 11 in.)

German Standard Fanfold (8-1/2 in. x 12 in.)

German Legal Fanfold (8-1/2 in. x 13 in.)

B4 (ISO) 250 x 353 mm

Japanese Postcard (100mm � 148mm)

9? � 11?

10? � 11?

15? � 11?

Envelope Invite(220mm � 220mm)

US Letter Extra 9 \275 x 12 in

US Legal Extra 9 \275 x 15 in

US Tabloid Extra 11.69 x 18 in

A4 Extra 9.27 x 12.69 in

Letter Transverse 8 \275 x 11 in

A4 Transverse 210 x 297 mm

Letter Extra Transverse 9\275 x 12 in

SuperA/SuperA/A4 227 x 356 mm

SuperB/SuperB/A3 305 x 487 mm

US Letter Plus 8.5 x 12.69 in

A4 Plus 210 x 330 mm

A5 Transverse 148 x 210 mm

B5 (JIS) Transverse 182 x 257 mm

A3 Extra 322 x 445 mm

A5 Extra 174 x 235 mm

B5 (ISO) Extra 201 x 276 mm

A2 420 x 594 mm

A3 Transverse 297 x 420 mm

A3 Extra Transverse 322 x 445 mm

Japanese Double Postcard 200 x 148 mm

A6 105 x 148 mm

Japanese Envelope Kaku #2

Japanese Envelope Kaku #3

Japanese Envelope Chou #3

Japanese Envelope Chou #4

11in � 8.5in

420mm � 297mm

297mm � 210mm

210mm � 148mm

B4 (JIS) Rotated 364 x 257 mm

B5 (JIS) Rotated 257 x 182 mm

Japanese Postcard Rotated 148 x 100 mm

Double Japanese Postcard Rotated 148 x 200 mm

A6 Rotated 148 x 105 mm

Japanese Envelope Kaku #2 Rotated

Japanese Envelope Kaku #3 Rotated

Japanese Envelope Chou #3 Rotated

Japanese Envelope Chou #4 Rotated

B6 (JIS) 128 x 182 mm

B6 (JIS) Rotated 182 x 128 mm

12 x 11 in

Japanese Envelope You #4

Japanese Envelope You #4 Rotated

PRC 16K 146 x 215 mm

PRC 32K 97 x 151 mm

PRC 32K(Big) 97 x 151 mm

PRC Envelope #1 102 x 165 mm

PRC Envelope #2 102 x 176 mm

PRC Envelope #3 125 x 176 mm

PRC Envelope #4 110 x 208 mm

PRC Envelope #5 110 x 220 mm

PRC Envelope #6 120 x 230 mm

PRC Envelope #7 160 x 230 mm

PRC Envelope #8 120 x 309 mm

PRC Envelope #9 229 x 324 mm

PRC Envelope #10 324 x 458 mm

PRC 16K Rotated

PRC 32K Rotated

PRC 32K(Big) Rotated

PRC Envelope #1 Rotated 165 x 102 mm

PRC Envelope #2 Rotated 176 x 102 mm

PRC Envelope #3 Rotated 176 x 125 mm

PRC Envelope #4 Rotated 208 x 110 mm

PRC Envelope #5 Rotated 220 x 110 mm

PRC Envelope #6 Rotated 230 x 120 mm

PRC Envelope #7 Rotated 230 x 160 mm

PRC Envelope #8 Rotated 309 x 120 mm

PRC Envelope #9 Rotated 324 x 229 mm

PRC Envelope #10 Rotated 458 x 324 mm

usual B3(13.9 x 19.7 in)

Business Card(90mm x 55 mm)

Thermal(3 x 11 in)

Represents the custom paper size.

Represent all parameters' type or return value type of function.

Represents the paste special type.

Copies all data of the range.

It works as "All" behavior of MS Excel.

Copies all data of the range without the range.

It works as "All except borders" behavior of MS Excel.

Only copies the widths of the range.

Only copies the heights of the range.

Represents the way comments are printed with the sheet.

Represents to print comments as displayed on sheet.

Represents not to print comments.

Represents to print comments at end of sheet.

Represents print errors constants.

Represents not to print errors.

Represents to print errors as "--".

Represents to print errors as displayed.

Represents to print errors as "#N/A".

Indicates which pages will not be printed.

Prints all pages.

Don't print the pages which the cells are blank.

Don't print the pages which cells only contain styles.

Represents workbook/worksheet protection type.

Represents to protect all.

Represents to protect contents, used in Worksheet protection.

Represents to protect objects, used in Worksheet protection.

Represents to protect scenarios, used in Worksheet protection.

Represents to protect structure, used in Workbook protection.

Represents to protect window, used in Workbook protection.

Represents no protection. Only for Reading property.

Represents the format in which the workbook is saved.

Comma-Separated Values(CSV) text file.

Represents an xlsx file.

Represents an xlsm file which enable macros.

Represents an xltx file.

Represents an xltm file which enable macros.

Represents an xltm file which enable addin macros.

Tab-Separated Values(TSV) text file.

Tab-Separated Values(TSV) text file. NOTE: This member is now obsolete. Instead, please use Tsv property.

Represents a tab delimited text file, same with Tsv

Represents a html file.

Represents a mhtml file.

Open Document Sheet(ODS) file.

Open Document Sheet(ODS) file. NOTE: This member is now obsolete. Instead, please use Ods property.

Represents an Excel97-2003 xls file.

Represents an Excel 2003 xml file.

Represents an xlsb file.

If saving the file to the disk,the file format accords to the extension of the file name. If saving the file to the stream, the file format is xlsx.

Represents unrecognized format, cannot be saved.

Represents a Pdf file.

XPS (XML Paper Specification) format.

Represents a TIFF file.

SVG file.

Data Interchange Format.

Open Document Template Sheet(OTS) file.

Excel 97-2003 template file.

Represents a simple xml file.

Represents a numbers file.

Not supported.

Represents markdown document.

Represents OpenDocument Flat XML Spreadsheet (.fods) file format.

Represents OpenDocument Flat XML Spreadsheet (.fods) file format. NOTE: This member is now obsolete. Instead, please use Fods property.

Represents StarOffice Calc Spreadsheet (.sxc) file format.

Represents StarOffice Calc Spreadsheet (.sxc) file format. NOTE: This member is now obsolete. Instead, please use Sxc property.

Represents .pptx file.

Represents .docx file.

Windows Enhanced Metafile.

JPEG JFIF.

Portable Network Graphics.

Windows Bitmap

Gif

Json

Sql

Rrepesents XHtml file.

BIFF4 Macro sheet

International Macro sheet

Dialog worksheet

Represent the shift options when deleting a range of cells.

Shift cells down.

Shift cells left.

Do not shift cells.

Shift cells right.

Shift cells up.

The style modified flags.

Indicates whether left border has been modified for the style.

Indicates whether right border has been modified for the style.

Indicates whether top border has been modified for the style.

Indicates whether bottom border has been modified for the style.

Indicates whether diagonal-down border has been modified for the style.

Indicates whether diagonal-up border has been modified for the style.

Indicates whether one or more diagonal borders(DiagonalDownBorder , DiagonalUpBorder ) have been modified for the style.

Indicates whether horizontal border has been modified for the style. Only for dynamic style, such as conditional formatting.

Indicates whether vertical border has been modified for the style. Only for dynamic style, such as conditional formatting.

Indicates whether one or more borders(LeftBorder , RightBorder , TopBorder , BottomBorder , Diagonal , HorizontalBorder , VerticalBorder ) have been modified for the style.

Indicates whether numberformat has been modified.

Indicates whether horizontal alignment has been modified.

Indicates whether vertical alignment has been modified.

Indicates whether indent property has been modified.

Indicates whether rotation property has been modified.

Indicates whether wrap text property has been modified.

Indicates whether shrink to fit property has been modified.

Indicates whether text direction property has been modified.

Indicates whether relative indent property has been modified for the style. Only for dynamic style, such as conditional formatting.

Indicates whether one or more alignment-related properties(HorizontalAlignment , VerticalAlignment , Rotation , WrapText , WrapText , Indent , ShrinkToFit , TextDirection , RelativeIndent ) have been modified.

Indicates whether pattern of the shading has been modified.

Indicates whether foreground color has been modified.

Indicates whether background color has been modified.

Indicates whether one or more shading-related properties(Pattern , ForegroundColor , BackgroundColor ) have been modified.

Indicates whether locked property has been modified.

Indicates whether hide formula has been modified.

Indicates whether one or more protection-related properties(Locked , HideFormula ) have been modified.

Indicates whether font size has been modified.

Indicates whether font name has been modified.

Indicates whether font color has been modified.

Indicates whether font weight has been modified.

Indicates whether italic property of font has been modified.

Indicates whether underline property of font has been modified.

Indicates whether strike property font has been modified.

Indicates whether subscript or superscript property of font has been modified.

Indicates whether font family has been modified.

Indicates whether charset of the font has been modified.

unused.

unused.

unused.

unused.

unused.

unused.

unused.

unused.

Indicates whether one or more properties have been modified for the font of the style.

Indicates whether one or more properties have been modified for the style.

Enumerates text alignment types.

Represents general text alignment.

Represents bottom text alignment.

Represents center text alignment.

Represents center across text alignment.

Represents distributed text alignment.

Represents fill text alignment.

Represents justify text alignment.

Represents left text alignment.

Represents right text alignment.

Represents top text alignment.

Aligns the text with an adjusted kashida length for Arabic text.

Distributes Thai text specially, because each character is treated as a word.

Represents the direction of the text flow for this paragraph.

Enumerates text orientation types.

Rotates text with 90 degrees clockwise.

Rotates text with 90 degrees counterclockwise.

Represents the default value.

Displays text from top to bottom of the cell. Stacked text.

This type specifies the strike type.

A single strikethrough applied on the text.

A double strikethrough applied on the text.

No strike is applied to the text.

Used in a FormatConditionType.TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.

Today's date.

Yesterday's date.

Tomorrow's date.

A date in the last seven days.

A date occurring in this calendar month.

A date occurring in the last calendar month.

A date occurring in the next calendar month.

A date occurring this week.

A date occurring last week.

A date occurring next week.

A date occurring this year. Only for .ods.

A date occurring last year. Only for .ods.

A date occurring next year. Only for .ods.

Specifies how to apply style for parsed values when converting string value to number or datetime.

Does not set style for the parsed value.

Set the style as built-in number/datetime when the parsed value are plain numeric/datetime values.

When ms excel parsing datetime or numeric values according to user's input(such as CSV file), the formatting of those values may be changed, such as leading/tailing zeros of number, year/month/day order of datetime, ...etc. This type is for simulating ms excel's behavior.

Set the exact custom format for the parsed value to make the formatted value be same with the original input one.

Specifies the type of using quotation marks for values in text format files.

All values that contain special characters such as quotation mark, separator character will be quoted. Same with the behavior of ms excel for exporting text file.

All values will be quoted always.

Only quote values when needed. Such as, if one value contains quotation mark but the quotation mark is not at the begin of this value, this value will not be quoted.

All values will not be quoted. The exported text file with this type may not be read back correctly because the needed quotation marks being absent.

Represents how to update links to other workbooks when the workbook is opened.

Prompt user to update.

Do not update, and do not prompt user.

Always update.

Represents the data validation alert style.

Information alert style.

Stop alert style.

Warning alert style.

Represents data validation type.

Any value validation type.

Whole number validation type.

Decimal validation type.

List validation type.

Date validation type.

Time validation type.

Text length validation type.

Custom validation type.

Represents the states for sheet visibility.

Indicates the sheet is visible.