The different constants linked to the XlsxToolBx DLL function parameters are listed below:
Error codes
The following error codes may be returned by the XlsxToolBx functions:
Nom |
Valeur |
Description |
_XLSX_ERR_NO_ERROR |
0 |
No error. |
_XLSX_ERR_UNEXPECTED_ERROR |
-1 |
Unexpected error. |
_XLSX_ERR_OBJECT_NOT_FOUND |
-2 |
Object not found. |
_XLSX_ERR_OBJECT_ALREADY_EXIST |
-3 |
Object already exists. |
_XLSX_ERR_INVALID_PARAMETER |
-4 |
Invalid parameter. |
_XLSX_ERR_INVALID_PARAMETER_TYPE |
-5 |
Invalid parameter type. |
_XLSX_ERR_INVALID_PARAMETER_COUNT |
-6 |
Number of invalid parameters. |
_XLSX_ERR_IO_EXCEPTION |
-7 |
Input/output exception. |
_XLSX_ERR_INVALID_HANDLE |
-9 |
Invalid handle. |
_XLSX_ERR_INVALID_FILENAME |
-10 |
Invalid file name. |
_XLSX_ERR_INVALID_OBJECTTYPE |
-11 |
Invalid object type. |
_XLSX_ERR_NO_MORE_HANDLE |
-13 |
No handle available. |
_XLSX_ERR_UNKNOWN_METHOD |
-14 |
Unknown method. |
_XLSX_ERR_OUT_OF_BOUNDS |
-17 |
Index outside bounds or end of search. |
_XLSX_ERR_NOT_IMPLEMENTED |
-18 |
Function not implemented. |
_XLSX_ERR_INVALID_NUMBER |
-19 |
Numeric value invalid. |
_XLSX_ERR_NUMERIC_OUT_OF_RANGE |
-20 |
Numeric value out of range. |
_XLSX_ERR_INVALID_STYLE |
-100 |
Invalid style. |
_XLSX_ERR_TOO_MANY_STYLES |
-101 |
Too many styles defined. Note: For Excel 97-2003, you can have only 4000 different cell styles. |
_XLSX_ERR_INVALID_SELECTION |
-102 |
Invalid selection. |
_XLSX_ERR_INVALID_CELL_TYPE |
-103 |
Invalid cell type. |
_XLSX_ERR_INVALID_FORMULA |
-104 |
Invalid formula. |
Horizontal cell alignment
Name |
Value |
Description |
_XLSX_HALIGN_STANDARD |
1 |
Standard alignment. |
_XLSX_HALIGN_LEFT |
2 |
Left alignment. |
_XLSX_HALIGN_RIGHT |
3 |
Right alignment. |
_XLSX_HALIGN_CENTER |
4 |
Centered. |
_XLSX_HALIGN_JUSTIFY |
5 |
Justified. |
_XLSX_HALIGN_CENTER_SELECTION |
6 |
Alignment centered on the column. |
_XLSX_HALIGN_FILL |
7 |
Filling. |
Vertical cell alignment
Name |
Value |
Description |
_XLSX_VALIGN_BOTTOM |
1 |
Bottom alignment. |
_XLSX_VALIGN_CENTER |
2 |
Centered. |
_XLSX_VALIGN_JUSTIFY |
3 |
Justified. |
_XLSX_VALIGN_TOP |
4 |
Top alignment. |
Text properties
These constants group together the different properties to style the text in a cell.
Name |
Value |
Description |
_XLSX_TEXT_PROP_BOLD |
1 |
Bold. |
_XLSX_TEXT_PROP_ITALIC |
2 |
Italics |
_XLSX_TEXT_PROP_STRIKE |
4 |
Strikethrough. |
_XLSX_TEXT_PROP_UNDERLINE |
8 |
Underline |
_XLSX_TEXT_PROP_DOUBLE_UNDERLINE |
16 |
Double underline. |
_XLSX_TEXT_PROP_UNDERLINE_ACCOUNTING |
32 |
Accounting underline. |
_XLSX_TEXT_PROP_DOUBLE_UNDERLINE_ACCOUNTING |
64 |
Double accounting underline. |
Border selection
These constants define which borders are handled by the style functions managing cell borders.
When you get the information, you need to explicitly specify the border to be processed (e.g. BORDER_BOTTOM)
If you define a border style, you can apply it to several borders simultaneously by combining the values.
For example: BORDER_TOP + BORDER_LEFT + BORDER_BOTTOM + BORDER_RIGHT to apply to the whole frame.
Name |
Value |
Description |
_XLSX_BORDER_TOP |
1 |
Top border. |
_XLSX_BORDER_LEFT |
2 |
Left border. |
_XLSX_BORDER_BOTTOM |
4 |
Bottom border. |
_XLSX_BORDER_RIGHT |
8 |
Right border. |
Types of border
These constants define cell border types.
Name |
Value |
Description |
_XLSX_BST_NONE |
1 |
Unbroken line. |
_XLSX_BST_DASHED |
2 |
Dashed line. |
_XLSX_BST_DASH_DOT |
3 |
Line with alternating dots and dashes. |
_XLSX_BST_DASH_DOT_DOT |
4 |
Alternating dashes and colons. |
_XLSX_BST_DOT |
5 |
Dotted line. |
_XLSX_BST_DOUBLE |
6 |
Double line. |
_XLSX_BST_SLANT_DASH_DOT |
7 |
Line with alternating dots and dashes diagonally. |
_XLSX_BST_HAIRLINE |
8 |
Thin line. |
_XLSX_BST_MEDIUM |
9 |
Medium thick line. |
_XLSX_BST_THICK |
10 |
Thick line. |
_XLSX_BST_THIN |
11 |
Fine line. |
Excel format
These constants define the format of the Excel workbook.
Name |
Value |
Description |
_XLSX_FORMAT_XLS |
1 |
Excel 97/2003 format (.xls). |
_XLSX_FORMAT_XLSX |
2 |
Excel 2007 et and later versions format (.xlsx). |
Click below for further details about: