• Home
• Download
• Documentation
• Examples
• Setup
• FAQ
• Purchase
• Contact

Factory functions

• BookHandle book = xlCreateBook();
  
  Creates a book instance for working with XLS files. This function should be called first for receiving a book handler.

• BookHandle book = xlCreateXMLBook();
  
  Creates a book instance for working with XLSX files. This function should be called first for receiving a book handler.

Book functions

• int xlBookLoad(BookHandle handle, const wchar_t* filename)
• int xlBookSave(BookHandle handle, const wchar_t* filename)
• int xlBookLoadUsingTempFile(BookHandle handle, const wchar_t* filename, const wchar_t* tempFile)
• int xlBookSaveUsingTempFile(BookHandle handle, const wchar_t* filename, int useTempFile)
• int xlBookLoadPartially(BookHandle handle, const wchar_t* filename, int sheetIndex, int firstRow, int lastRow, int keepAllSheets)
• int xlBookLoadPartiallyUsingTempFile(BookHandle handle, const wchar_t* filename, int sheetIndex, int firstRow, int lastRow, const wchar_t* tempFile, int keepAllSheets)
• int xlBookLoadWithoutEmptyCells(BookHandle handle, const wchar_t* filename)
• int xlBookLoadInfo(BookHandle handle, const wchar_t* filename)
• int xlBookLoadRaw(BookHandle handle, const char* data, unsigned size)
• int xlBookLoadRawPartially(BookHandle handle, const char* data, unsigned size, int sheetIndex, int firstRow, int lastRow, int keepAllSheets)
• int xlBookSaveRaw(BookHandle handle, const char** data, unsigned* size)
• SheetHandle xlBookAddSheet(BookHandle handle, const wchar_t* name, SheetHandle initSheet)
• SheetHandle xlBookInsertSheet(BookHandle handle, int index, const wchar_t* name, SheetHandle initSheet)
• SheetHandle xlBookGetSheet(BookHandle handle, int index)
• const wchar_t* xlBookGetSheetName(BookHandle handle, int index)
• int xlBookSheetType(BookHandle handle, int index)
• int xlBookMoveSheet(BookHandle handle, int srcIndex, int dstIndex)
• int xlBookDelSheet(BookHandle handle, int index)
• int xlBookSheetCount(BookHandle handle)
• FormatHandle xlBookAddFormat(BookHandle handle, FormatHandle initFormat)
• FormatHandle xlBookAddFormatFromStyle(BookHandle handle, int style)
• FontHandle xlBookAddFont(BookHandle handle, FontHandle initFont)
• RichStringHandle xlBookAddRichString(BookHandle handle)
• int xlBookAddCustomNumFormat(BookHandle handle, const wchar_t* customNumFormat)
• const wchar_t* xlBookCustomNumFormat(BookHandle handle, int fmt)
• FormatHandle xlBookFormat(BookHandle handle, int index)
• int xlBookFormatSize(BookHandle handle)
• FontHandle xlBookFont(BookHandle handle, int index)
• int xlBookFontSize(BookHandle handle)
• ConditionalFormatHandle xlBookAddConditionalFormat(BookHandle handle)
• double xlBookDatePack(BookHandle handle, int year, int month, int day, int hour, int min, int sec, int msec)
• int xlBookDateUnpack(BookHandle handle, double value, int* year, int* month, int* day, int* hour, int* min, int* sec, int* msec)
• int xlBookColorPack(BookHandle handle, int red, int green, int blue)
• void xlBookColorUnpack(BookHandle handle, int color, int* red, int* green, int* blue)
• int xlBookActiveSheet(BookHandle handle)
• void xlBookSetActiveSheet(BookHandle handle, int index)
• int xlBookPictureSize(BookHandle handle)
• int xlBookGetPicture(BookHandle handle, int index, const char** data, unsigned* size)
• int xlBookAddPicture(BookHandle handle, const wchar_t* filename)
• int xlBookAddPicture2(BookHandle handle, const char* data, unsigned size)
• int xlBookAddPictureAsLink(BookHandle handle, const wchar_t* filename, int insert)
• const wchar_t* xlBookDefaultFont(BookHandle handle, int* fontSize)
• void xlBookSetDefaultFont(BookHandle handle, const wchar_t* fontName, int fontSize)
• int xlBookRgbMode(BookHandle handle)
• void xlBookSetRgbMode(BookHandle handle, int rgbMode)
• int xlBookCalcMode(BookHandle handle)
• void xlBookSetCalcMode(BookHandle handle, int calcMode)
• int xlBookRefR1C1(BookHandle handle)
• void xlBookSetRefR1C1(BookHandle handle, int refR1C1)
• int xlBookVersion(BookHandle handle)
• int xlBookBiffVersion(BookHandle handle)
• int xlBookIsDate1904(BookHandle handle)
• void xlBookSetDate1904(BookHandle handle, int date1904)
• int xlBookIsTemplate(BookHandle handle)
• void xlBookSetTemplate(BookHandle handle, int tmpl)
• int xlBookIsWriteProtected(BookHandle handle)
• CorePropertiesHandle xlBookCoreProperties(BookHandle handle)
• int xlBookRemoveVBA(BookHandle handle)
• int xlBookRemovePrinterSettings(BookHandle handle)
• void xlBookRemoveAllPhonetics(BookHandle handle)
• void xlBookSetKey(BookHandle handle, const wchar_t* name, const wchar_t* key)
• int xlBookSetLocale(BookHandle handle, const char* locale)
• const char* xlBookErrorMessage(BookHandle handle)
• void xlBookRelease(BookHandle handle)

Sheet functions

• int xlSheetCellType(SheetHandle handle, int row, int col)
• int xlSheetIsFormula(SheetHandle handle, int row, int col)
• FormatHandle xlSheetCellFormat(SheetHandle handle, int row, int col)
• void xlSheetSetCellFormat(SheetHandle handle, int row, int col, FormatHandle format)
• const wchar_t* xlSheetReadStr(SheetHandle handle, int row, int col, FormatHandle* format)
• int xlSheetWriteStr(SheetHandle handle, int row, int col, const wchar_t* value, FormatHandle format)
• RichStringHandle xlSheetReadRichStr(SheetHandle handle, int row, int col, FormatHandle* format)
• int xlSheetWriteRichStr(SheetHandle handle, int row, int col, RichStringHandle richString, FormatHandle format)
• double xlSheetReadNum(SheetHandle handle, int row, int col, FormatHandle* format)
• int xlSheetWriteNum(SheetHandle handle, int row, int col, double value, FormatHandle format)
• int xlSheetReadBool(SheetHandle handle, int row, int col, FormatHandle* format)
• int xlSheetWriteBool(SheetHandle handle, int row, int col, int value, FormatHandle format)
• int xlSheetReadBlank(SheetHandle handle, int row, int col, FormatHandle* format)
• int xlSheetWriteBlank(SheetHandle handle, int row, int col, FormatHandle format)
• const wchar_t* xlSheetReadFormula(SheetHandle handle, int row, int col, FormatHandle* format)
• int xlSheetWriteFormula(SheetHandle handle, int row, int col, const wchar_t* value, FormatHandle format)
• int xlSheetWriteFormulaNum(SheetHandle handle, int row, int col, const wchar_t* expr, double value, FormatHandle format)
• int xlSheetWriteFormulaStr(SheetHandle handle, int row, int col, const wchar_t* expr, const wchar_t* value, FormatHandle format)
• int xlSheetWriteFormulaBool(SheetHandle handle, int row, int col, const wchar_t* expr, int value, FormatHandle format)
• const char* xlSheetReadComment(SheetHandle handle, int row, int col)
• void xlSheetWriteComment(SheetHandle handle, int row, int col, const wchar_t* value, const wchar_t* author, int width, int height)
• void xlSheetRemoveComment(SheetHandle handle, int row, int col)
• int xlSheetIsDate(SheetHandle handle, int row, int col)
• int xlSheetIsRichStr(SheetHandle handle, int row, int col)
• int xlSheetReadError(SheetHandle handle, int row, int col)
• void xlSheetWriteError(SheetHandle handle, int row, int col, int error, FormatHandle format)
• double xlSheetColWidth(SheetHandle handle, int col)
• double xlSheetRowHeight(SheetHandle handle, int row)
• int xlSheetColWidthPx(SheetHandle handle, int col)
• int xlSheetRowHeightPx(SheetHandle handle, int row)
• FormatHandle xlSheetColFormat(SheetHandle handle, int col)
• FormatHandle xlSheetRowFormat(SheetHandle handle, int row)
• int xlSheetSetCol(SheetHandle handle, int colFirst, int colLast, double width, FormatHandle format, int hidden)
• int xlSheetSetRow(SheetHandle handle, int row, double height, FormatHandle format, int hidden)
• int xlSheetSetColPx(SheetHandle handle, int colFirst, int colLast, int widthPx, FormatHandle format, int hidden)
• int xlSheetSetRowPx(SheetHandle handle, int row, int heightPx, FormatHandle format, int hidden)
• int xlSheetRowHidden(SheetHandle handle, int row)
• int xlSheetSetRowHidden(SheetHandle handle, int row, int hidden)
• int xlSheetColHidden(SheetHandle handle, int col)
• int xlSheetSetColHidden(SheetHandle handle, int col, int hidden)
• double xlSheetDefaultRowHeight(SheetHandle handle)
• void xlSheetSetDefaultRowHeight(SheetHandle handle, double height)
• int xlSheetGetMerge(SheetHandle handle, int row, int col, int* rowFirst, int* rowLast, int* colFirst, int* colLast)
• int xlSheetSetMerge(SheetHandle handle, int rowFirst, int rowLast, int colFirst, int colLast)
• int xlSheetDelMerge(SheetHandle handle, int row, int col)
• int xlSheetMergeSize(SheetHandle handle)
• int xlSheetMerge(SheetHandle handle, int index, int* rowFirst, int* rowLast, int* colFirst, int* colLast)
• int xlSheetDelMergeByIndex(SheetHandle handle, int index)
• int xlSheetPictureSize(SheetHandle handle)
• int xlSheetGetPicture(SheetHandle handle, int index, int* rowTop, int* colLeft, int* rowBottom, int* colRight, int* width, int* height, int* offset_x, int* offset_y)
• int xlSheetRemovePictureByIndex(SheetHandle handle, int index)
• void xlSheetSetPicture(SheetHandle handle, int row, int col, int pictureId, double scale, int offset_x, int offset_y, int pos)
• void xlSheetSetPicture2(SheetHandle handle, int row, int col, int pictureId, int width, int height, int offset_x, int offset_y, int pos)
• int xlSheetRemovePicture(SheetHandle handle, int row, int col)
• int xlSheetGetHorPageBreak(SheetHandle handle, int index)
• int xlSheetGetHorPageBreakSize(SheetHandle handle)
• int xlSheetGetVerPageBreak(SheetHandle handle, int index)
• int xlSheetGetVerPageBreakSize(SheetHandle handle)
• int xlSheetSetHorPageBreak(SheetHandle handle, int row, int pageBreak)
• int xlSheetSetVerPageBreak(SheetHandle handle, int col, int pageBreak)
• void xlSheetSplit(SheetHandle handle, int row, int col)
• int xlSheetSplitInfo(SheetHandle handle, int* row, int* col)
• int xlSheetGroupRows(SheetHandle handle, int rowFirst, int rowLast, int collapsed)
• int xlSheetGroupCols(SheetHandle handle, int colFirst, int colLast, int collapsed)
• int xlSheetGroupSummaryBelow(SheetHandle handle)
• void xlSheetSetGroupSummaryBelow(SheetHandle handle, int below)
• int xlSheetGroupSummaryRight(SheetHandle handle)
• void xlSheetSetGroupSummaryRight(SheetHandle handle, int right)
• int xlSheetClear(SheetHandle handle, int rowFirst, int rowLast, int colFirst, int colLast)
• int xlSheetInsertRow(SheetHandle handle, int rowFirst, int rowLast)
• int xlSheetInsertCol(SheetHandle handle, int colFirst, int colLast)
• int xlSheetRemoveRow(SheetHandle handle, int rowFirst, int rowLast)
• int xlSheetRemoveCol(SheetHandle handle, int colFirst, int colLast)
• int xlSheetInsertRowAndKeepRanges(SheetHandle handle, int rowFirst, int rowLast)
• int xlSheetInsertColAndKeepRanges(SheetHandle handle, int colFirst, int colLast)
• int xlSheetRemoveRowAndKeepRanges(SheetHandle handle, int rowFirst, int rowLast)
• int xlSheetRemoveColAndKeepRanges(SheetHandle handle, int colFirst, int colLast)
• int xlSheetCopyCell(SheetHandle handle, int rowSrc, int colSrc, int rowDst, int colDst)
• int xlSheetFirstRow(SheetHandle handle)
• int xlSheetLastRow(SheetHandle handle)
• int xlSheetFirstCol(SheetHandle handle)
• int xlSheetLastCol(SheetHandle handle)
• int xlSheetFirstFilledRow(SheetHandle handle)
• int xlSheetLastFilledRow(SheetHandle handle)
• int xlSheetFirstFilledCol(SheetHandle handle)
• int xlSheetLastFilledCol(SheetHandle handle)
• int xlSheetDisplayGridlines(SheetHandle handle)
• void xlSheetSetDisplayGridlines(SheetHandle handle, int show)
• int xlSheetPrintGridlines(SheetHandle handle)
• void xlSheetSetPrintGridlines(SheetHandle handle, int print)
• int xlSheetZoom(SheetHandle handle)
• void xlSheetSetZoom(SheetHandle handle, int zoom)
• int xlSheetPrintZoom(SheetHandle handle)
• void xlSheetSetPrintZoom(SheetHandle handle, int zoom)
• int xlSheetLandscape(SheetHandle handle)
• void xlSheetSetLandscape(SheetHandle handle, int landscape)
• int xlSheetGetPrintFit(SheetHandle handle, int* wPages, int* hPages)
• void xlSheetSetPrintFit(SheetHandle handle, int wPages, int hPages)
• int xlSheetPaper(SheetHandle handle)
• void xlSheetSetPaper(SheetHandle handle, int paper)
• const wchar_t* xlSheetHeader(SheetHandle handle)
• int xlSheetSetHeader(SheetHandle handle, const wchar_t* header, double margin)
• double xlSheetHeaderMargin(SheetHandle handle)
• const wchar_t* xlSheetFooter(SheetHandle handle)
• int xlSheetSetFooter(SheetHandle handle, const wchar_t* footer, double margin)
• double xlSheetFooterMargin(SheetHandle handle)
• int xlSheetHCenter(SheetHandle handle)
• void xlSheetSetHCenter(SheetHandle handle, int hCenter)
• int xlSheetVCenter(SheetHandle handle)
• void xlSheetSetVCenter(SheetHandle handle, int vCenter)
• double xlSheetMarginLeft(SheetHandle handle)
• void xlSheetSetMarginLeft(SheetHandle handle, double margin)
• double xlSheetMarginRight(SheetHandle handle)
• void xlSheetSetMarginRight(SheetHandle handle, double margin)
• double xlSheetMarginTop(SheetHandle handle)
• void xlSheetSetMarginTop(SheetHandle handle, double margin)
• double xlSheetMarginBottom(SheetHandle handle)
• void xlSheetSetMarginBottom(SheetHandle handle, double margin)
• int xlSheetPrintRowCol(SheetHandle handle)
• void xlSheetSetPrintRowCol(SheetHandle handle, int print)
• int xlSheetPrintRepeatRows(SheetHandle handle, int* rowFirst, int* rowLast)
• void xlSheetSetPrintRepeatRows(SheetHandle handle, int rowFirst, int rowLast)
• int xlSheetPrintRepeatCols(SheetHandle handle, int* colFirst, int* colLast)
• void xlSheetSetPrintRepeatCols(SheetHandle handle, int colFirst, int colLast)
• int xlSheetPrintArea(SheetHandle handle, int* rowFirst, int* rowLast, int* colFirst, int* colLast)
• void xlSheetSetPrintArea(SheetHandle handle, int rowFirst, int rowLast, int colFirst, int colLast)
• void xlSheetClearPrintRepeats(SheetHandle handle)
• void xlSheetClearPrintArea(SheetHandle handle)
• int xlSheetGetNamedRange(SheetHandle handle, const wchar_t* name, int* rowFirst, int* rowLast, int* colFirst, int* colLast, int scopeId, int* hidden)
• int xlSheetSetNamedRange(SheetHandle handle, const wchar_t* name, int rowFirst, int rowLast, int colFirst, int colLast, int scopeId)
• int xlSheetDelNamedRange(SheetHandle handle, const wchar_t* name, int scopeId)
• int xlSheetNamedRangeSize(SheetHandle handle)
• const wchar_t* xlSheetNamedRange(SheetHandle handle, int index, int* rowFirst, int* rowLast, int* colFirst, int* colLast, int* scopeId, int* hidden)
• int xlSheetGetTable(SheetHandle handle, const wchar_t* name, int* rowFirst, int* rowLast, int* colFirst, int* colLast, int* headerRowCount, int* totalsRowCount)
• int xlSheetTableSize(SheetHandle handle)
• const wchar_t* xlSheetTable(SheetHandle handle, int index, int* rowFirst, int* rowLast, int* colFirst, int* colLast, int* headerRowCount, int* totalsRowCount)
• TableHandle xlSheetAddTable(SheetHandle handle, const wchar_t* name, int rowFirst, int rowLast, int colFirst, int colLast, int hasHeaders, int tableStyle)
• TableHandle xlSheetGetTableByName(SheetHandle handle, const wchar_t* name)
• TableHandle xlSheetGetTableByIndex(SheetHandle handle, int index)
• int xlSheetHyperlinkSize(SheetHandle handle)
• const wchar_t* xlSheetHyperlink(SheetHandle handle, int index, int* rowFirst, int* rowLast, int* colFirst, int* colLast)
• int xlSheetDelHyperlink(SheetHandle handle, int index)
• void xlSheetAddHyperlink(SheetHandle handle, const wchar_t* hyperlink, int rowFirst, int rowLast, int colFirst, int colLast)
• int xlSheetHyperlinkIndex(SheetHandle handle, int row, int col)
• int xlSheetIsAutoFilter(SheetHandle handle)
• AutoFilterHandle xlSheetAutoFilter(SheetHandle handle)
• void xlSheetApplyFilter(SheetHandle handle)
• void xlSheetApplyFilter2(SheetHandle handle, AutoFilterHandle autoFilter)
• void xlSheetRemoveFilter(SheetHandle handle)
• const wchar_t* xlSheetName(SheetHandle handle)
• void xlSheetSetName(SheetHandle handle, const wchar_t* name)
• int xlSheetProtect(SheetHandle handle)
• void xlSheetSetProtect(SheetHandle handle, int protect)
• void xlSheetSetProtectEx(SheetHandle handle, int protect, const wchar_t* password, int enhancedProtection)
• int xlSheetRightToLeft(SheetHandle handle)
• void xlSheetSetRightToLeft(SheetHandle handle, int rightToLeft)
• int xlSheetHidden(SheetHandle handle)
• int xlSheetSetHidden(SheetHandle handle, int hidden)
• void xlSheetGetTopLeftView(SheetHandle handle, int* row, int* col)
• void xlSheetSetTopLeftView(SheetHandle handle, int row, int col)
• void xlSheetSetAutoFitArea(SheetHandle handle, int rowFirst, int colFirst, int rowLast, int colLast)
• void xlSheetAddrToRowCol(SheetHandle handle, const wchar_t* addr, int* row, int* col, int* rowRelative, int* colRelative)
• const wchar_t* xlSheetRowColToAddr(SheetHandle handle, int row, int col, int rowRelative, int colRelative)
• int xlSheetTabColor(SheetHandle handle)
• void xlSheetSetTabColor(SheetHandle handle, int color)
• int xlSheetGetTabRgbColor(int* red, int* green, int* blue)
• void xlSheetSetTabRgbColor(SheetHandle handle, int red, int green, int blue)
• int xlSheetSetBorder(SheetHandle handle, int rowFirst, int rowLast, int colFirst, int colLast, int borderStyle, int borderColor)
• int xlSheetAddIgnoredError(SheetHandle handle, int rowFirst, int colFirst, int rowLast, int colLast, int iError)
• void xlSheetAddDataValidation(SheetHandle handle, int type, int op, int rowFirst, int rowLast, int colFirst, int colLast, const wchar_t* value1, const wchar_t* value2)
• void xlSheetAddDataValidationEx(SheetHandle handle, int type, int op, int rowFirst, int rowLast, int colFirst, int colLast, const wchar_t* value1, const wchar_t* value2, int allowBlank, int hideDropDown, int showInputMessage, int showErrorMessage, const wchar_t* promptTitle, const wchar_t* prompt, const wchar_t* errorTitle, const wchar_t* error, int errorStyle)
• void xlSheetAddDataValidationDouble(SheetHandle handle, int type, int op, int rowFirst, int rowLast, int colFirst, int colLast, double value1, double value2)
• void xlSheetAddDataValidationDoubleEx(SheetHandle handle, int type, int op, int rowFirst, int rowLast, int colFirst, int colLast, double value1, double value2, int allowBlank, int hideDropDown, int showInputMessage, int showErrorMessage, const wchar_t* promptTitle, const wchar_t* prompt, const wchar_t* errorTitle, const wchar_t* error, int errorStyle)
• void xlSheetRemoveDataValidations(SheetHandle handle)
• int xlSheetFormControlSize(SheetHandle handle)
• FormControlHandle xlSheetFormControl(SheetHandle handle, int index)
• ConditionalFormattingHandle xlSheetAddConditionalFormatting(SheetHandle handle)
• int xlSheetGetActiveCell(SheetHandle handle, int* row, int* col)
• void xlSheetSetActiveCell(SheetHandle handle, int row, int col)
• const wchar_t* xlSheetSelectionRange(SheetHandle handle)
• void xlSheetAddSelectionRange(SheetHandle handle, const wchar_t* sqref)
• void xlSheetRemoveSelection(SheetHandle handle)

Format functions

• FontHandle xlFormatFont(FormatHandle handle)
• int xlFormatSetFont(FormatHandle handle, FontHandle fontHandle)
• int xlFormatNumFormat(FormatHandle handle)
• void xlFormatSetNumFormat(FormatHandle handle, int numFormat)
• int xlFormatAlignH(FormatHandle handle)
• void xlFormatSetAlignH(FormatHandle handle, int align)
• int xlFormatAlignV(FormatHandle handle)
• void xlFormatSetAlignV(FormatHandle handle, int align)
• int xlFormatWrap(FormatHandle handle)
• void xlFormatSetWrap(FormatHandle handle, int wrap)
• int xlFormatRotation(FormatHandle handle)
• int xlFormatSetRotation(FormatHandle handle, int rotation)
• int xlFormatIndent(FormatHandle handle)
• void xlFormatSetIndent(FormatHandle handle, int indent)
• int xlFormatShrinkToFit(FormatHandle handle)
• void xlFormatSetShrinkToFit(FormatHandle handle, int shrinkToFit)
• void xlFormatSetBorder(FormatHandle handle, int style)
• void xlFormatSetBorderColor(FormatHandle handle, int color)
• int xlFormatBorderLeft(FormatHandle handle)
• void xlFormatSetBorderLeft(FormatHandle handle, int style)
• int xlFormatBorderRight(FormatHandle handle)
• void xlFormatSetBorderRight(FormatHandle handle, int style)
• int xlFormatBorderTop(FormatHandle handle)
• void xlFormatSetBorderTop(FormatHandle handle, int style)
• int xlFormatBorderBottom(FormatHandle handle)
• void xlFormatSetBorderBottom(FormatHandle handle, int style)
• int xlFormatBorderLeftColor(FormatHandle handle)
• void xlFormatSetBorderLeftColor(FormatHandle handle, int color)
• int xlFormatBorderRightColor(FormatHandle handle)
• void xlFormatSetBorderRightColor(FormatHandle handle, int color)
• int xlFormatBorderTopColor(FormatHandle handle)
• void xlFormatSetBorderTopColor(FormatHandle handle, int color)
• int xlFormatBorderBottomColor(FormatHandle handle)
• void xlFormatSetBorderBottomColor(FormatHandle handle, int color)
• int xlFormatBorderDiagonal(FormatHandle handle)
• void xlFormatSetBorderDiagonal(FormatHandle handle, int border)
• int xlFormatBorderDiagonalStyle(FormatHandle handle)
• void xlFormatSetBorderDiagonalStyle(FormatHandle handle, int style)
• int xlFormatBorderDiagonalColor(FormatHandle handle)
• void xlFormatSetBorderDiagonalColor(FormatHandle handle, int color)
• int xlFormatFillPattern(FormatHandle handle)
• void xlFormatSetFillPattern(FormatHandle handle, int pattern)
• int xlFormatPatternForegroundColor(FormatHandle handle)
• void xlFormatSetPatternForegroundColor(FormatHandle handle, int color)
• int xlFormatPatternBackgroundColor(FormatHandle handle)
• void xlFormatSetPatternBackgroundColor(FormatHandle handle, int color)
• int xlFormatLocked(FormatHandle handle)
• void xlFormatSetLocked(FormatHandle handle, int locked)
• int xlFormatHidden(FormatHandle handle)
• void xlFormatSetHidden(FormatHandle handle, int hidden)

Font functions

• int xlFontSize(FontHandle handle)
• void xlFontSetSize(FontHandle handle, int size)
• int xlFontItalic(FontHandle handle)
• void xlFontSetItalic(FontHandle handle, int italic)
• int xlFontStrikeOut(FontHandle handle)
• void xlFontSetStrikeOut(FontHandle handle, int strikeOut)
• int xlFontColor(FontHandle handle)
• void xlFontSetColor(FontHandle handle, int color)
• int xlFontBold(FontHandle handle)
• void xlFontSetBold(FontHandle handle, int bold)
• int xlFontScript(FontHandle handle)
• void xlFontSetScript(FontHandle handle, int script)
• int xlFontUnderline(FontHandle handle)
• void xlFontSetUnderline(FontHandle handle, int underline)
• const wchar_t* xlFontName(FontHandle handle)
• int xlFontSetName(FontHandle handle, const wchar_t* name)

AutoFilter functions

• int xlAutoFilterGetRef(AutoFilterHandle handle, int* rowFirst, int* rowLast, int* colFirst, int* colLast)
• void xlAutoFilterSetRef(AutoFilterHandle handle, int rowFirst, int rowLast, int colFirst, int colLast)
• FilterColumnHandle xlAutoFilterColumn(AutoFilterHandle handle, int colId)
• int xlAutoFilterColumnSize(AutoFilterHandle handle)
• FilterColumnHandle xlAutoFilterColumnByIndex(AutoFilterHandle handle, int index)
• int xlAutoFilterGetSortRange(AutoFilterHandle handle, int* rowFirst, int* rowLast, int* colFirst, int* colLast)
• int xlAutoFilterGetSort(AutoFilterHandle handle, int* columnIndex, int* descending)
• int xlAutoFilterSetSort(AutoFilterHandle handle, int columnIndex, int descending)
• int xlAutoFilterAddSort(AutoFilterHandle handle, int columnIndex, int descending)

FilterColumn functions

• int xlFilterColumnIndex(FilterColumnHandle handle)
• int xlFilterColumnFilterType(FilterColumnHandle handle)
• int xlFilterColumnFilterSize(FilterColumnHandle handle)
• const wchar_t* xlFilterColumnFilter(FilterColumnHandle handle, int index)
• void xlFilterColumnAddFilter(FilterColumnHandle handle, const wchar_t* value)
• int xlFilterColumnGetTop10(FilterColumnHandle handle, double* value, int* top, int* percent)
• void xlFilterColumnSetTop10(FilterColumnHandle handle, double value, int top, int percent)
• int xlFilterColumnGetCustomFilter(FilterColumnHandle handle, int* op1, const wchar_t** v1, int* op2, const wchar_t** v2, int* andOp)
• void xlFilterColumnSetCustomFilter(FilterColumnHandle handle, int op, const wchar_t* v)
• void xlFilterColumnSetCustomFilterEx(FilterColumnHandle handle, int op1, const wchar_t* v1, int op2, const wchar_t* v2, int andOp)
• void xlFilterColumnClear(FilterColumnHandle handle)

RichString functions

• FontHandle xlRichStringAddFont(RichStringHandle handle, FontHandle initFont)
• void xlRichStringAddText(RichStringHandle handle, const wchar_t* text, FontHandle font)
• const wchar_t* xlRichStringGetText(RichStringHandle handle, int index, FontHandle* font)
• int xlRichStringTextSize(RichStringHandle handle)

FormControl functions

• int xlFormControlObjectType(FormControlHandle handle)
• int xlFormControlChecked(FormControlHandle handle)
• void xlFormControlSetChecked(FormControlHandle handle, int checked)
• const wchar_t* xlFormControlFmlaGroup(FormControlHandle handle)
• void xlFormControlSetFmlaGroup(FormControlHandle handle, const wchar_t* group)
• const wchar_t* xlFormControlFmlaLink(FormControlHandle handle)
• void xlFormControlSetFmlaLink(FormControlHandle handle, const wchar_t* link)
• const wchar_t* xlFormControlFmlaRange(FormControlHandle handle)
• void xlFormControlSetFmlaRange(FormControlHandle handle, const wchar_t* range)
• const wchar_t* xlFormControlFmlaTxbx(FormControlHandle handle)
• void xlFormControlSetFmlaTxbx(FormControlHandle handle, const wchar_t* txbx)
• const wchar_t* xlFormControlName(FormControlHandle handle)
• const wchar_t* xlFormControlLinkedCell(FormControlHandle handle)
• const wchar_t* xlFormControlListFillRange(FormControlHandle handle)
• const wchar_t* xlFormControlMacro(FormControlHandle handle)
• const wchar_t* xlFormControlAltText(FormControlHandle handle)
• int xlFormControlLocked(FormControlHandle handle)
• int xlFormControlDefaultSize(FormControlHandle handle)
• int xlFormControlPrint(FormControlHandle handle)
• int xlFormControlDisabled(FormControlHandle handle)
• const wchar_t* xlFormControlItem(FormControlHandle handle, int index)
• int xlFormControlItemSize(FormControlHandle handle)
• void xlFormControlAddItem(FormControlHandle handle, const wchar_t* value)
• void xlFormControlInsertItem(FormControlHandle handle, int index, const wchar_t* value)
• void xlFormControlClearItems(FormControlHandle handle)
• int xlFormControlDropLines(FormControlHandle handle)
• void xlFormControlSetDropLines(FormControlHandle handle, int lines)
• int xlFormControlDx(FormControlHandle handle)
• void xlFormControlSetDx(FormControlHandle handle, int dx)
• int xlFormControlFirstButton(FormControlHandle handle)
• void xlFormControlSetFirstButton(FormControlHandle handle, int firstButton)
• int xlFormControlHoriz(FormControlHandle handle)
• void xlFormControlSetHoriz(FormControlHandle handle, int horiz)
• int xlFormControlInc(FormControlHandle handle)
• void xlFormControlSetInc(FormControlHandle handle, int inc)
• int xlFormControlGetMax(FormControlHandle handle)
• void xlFormControlSetMax(FormControlHandle handle, int max)
• int xlFormControlGetMin(FormControlHandle handle)
• void xlFormControlSetMin(FormControlHandle handle, int min)
• const wchar_t* xlFormControlMultiSel(FormControlHandle handle)
• void xlFormControlSetMultiSel(FormControlHandle handle, const wchar_t* value)
• int xlFormControlSel(FormControlHandle handle)
• void xlFormControlSetSel(FormControlHandle handle, int sel)
• int xlFormControlFromAnchor(FormControlHandle handle, int* col, int* colOff, int* row, int* rowOff)
• int xlFormControlToAnchor(FormControlHandle handle, int* col, int* colOff, int* row, int* rowOff)

ConditionalFormatting functions

• void xlConditionalFormattingAddRange(ConditionalFormattingHandle handle, int rowFirst, int rowLast, int colFirst, int colLast)
• void xlConditionalFormattingAddRule(ConditionalFormattingHandle handle, int type, ConditionalFormatHandle cFormat, const wchar_t* value, int stopIfTrue)
• void xlConditionalFormattingAddTopRule(ConditionalFormattingHandle handle, ConditionalFormatHandle cFormat, int value, int bottom, int percent, int stopIfTrue)
• void xlConditionalFormattingAddOpNumRule(ConditionalFormattingHandle handle, int op, ConditionalFormatHandle cFormat, double value1, double value2, int stopIfTrue)
• void xlConditionalFormattingAddOpStrRule(ConditionalFormattingHandle handle, int op, ConditionalFormatHandle cFormat, const wchar_t* value1, const wchar_t* value2, int stopIfTrue)
• void xlConditionalFormattingAddAboveAverageRule(ConditionalFormattingHandle handle, ConditionalFormatHandle cFormat, int aboveAverage, int equalAverage, int stdDev, int stopIfTrue)
• void xlConditionalFormattingAddTimePeriodRule(ConditionalFormattingHandle handle, ConditionalFormatHandle cFormat, int timePeriod, int stopIfTrue)
• void xlConditionalFormattingAdd2ColorScaleRule(ConditionalFormattingHandle handle, int minColor, int maxColor, int minType, double minValue, int maxType, double maxValue, int stopIfTrue)
• void xlConditionalFormattingAdd2ColorScaleRule(ConditionalFormattingHandle handle, int minColor, int maxColor, int minType, const char* minValue, int maxType, const wchar_t* maxValue, int stopIfTrue)
• void xlConditionalFormattingAdd3ColorScaleRule(ConditionalFormattingHandle handle, int minColor, int midColor, int maxColor, int minType, double minValue, int midType, double midValue, int maxType, double maxValue, int stopIfTrue)
• void xlConditionalFormattingAdd3ColorScaleFormulaRule(ConditionalFormattingHandle handle, int minColor, int midColor, int maxColor, int minType, const wchar_t* minValue, int midType, const wchar_t* midValue, int maxType, const wchar_t* maxValue, int stopIfTrue)

ConditionalFormat functions

• FontHandle xlFormatFont(FormatHandle handle)
• int xlFormatNumFormat(FormatHandle handle)
• void xlFormatSetNumFormat(FormatHandle handle, int numFormat)
• const wchar_t* xlBookCustomNumFormat(BookHandle handle)
• void xlBookSetCustomNumFormat(BookHandle handle, const wchar_t* customNumFormat)
• void xlFormatSetBorder(FormatHandle handle, int style)
• void xlFormatSetBorderColor(FormatHandle handle, int color)
• int xlFormatBorderLeft(FormatHandle handle)
• void xlFormatSetBorderLeft(FormatHandle handle, int style)
• int xlFormatBorderRight(FormatHandle handle)
• void xlFormatSetBorderRight(FormatHandle handle, int style)
• int xlFormatBorderTop(FormatHandle handle)
• void xlFormatSetBorderTop(FormatHandle handle, int style)
• int xlFormatBorderBottom(FormatHandle handle)
• void xlFormatSetBorderBottom(FormatHandle handle, int style)
• int xlFormatBorderLeftColor(FormatHandle handle)
• void xlFormatSetBorderLeftColor(FormatHandle handle, int color)
• int xlFormatBorderRightColor(FormatHandle handle)
• void xlFormatSetBorderRightColor(FormatHandle handle, int color)
• int xlFormatBorderTopColor(FormatHandle handle)
• void xlFormatSetBorderTopColor(FormatHandle handle, int color)
• int xlFormatBorderBottomColor(FormatHandle handle)
• void xlFormatSetBorderBottomColor(FormatHandle handle, int color)
• int xlFormatFillPattern(FormatHandle handle)
• void xlFormatSetFillPattern(FormatHandle handle, int pattern)
• int xlFormatPatternForegroundColor(FormatHandle handle)
• void xlFormatSetPatternForegroundColor(FormatHandle handle, int color)
• int xlFormatPatternBackgroundColor(FormatHandle handle)
• void xlFormatSetPatternBackgroundColor(FormatHandle handle, int color)

CoreProperties functions

• const wchar_t* xlCorePropertiesTitle(CorePropertiesHandle handle)
• void xlCorePropertiesSetTitle(CorePropertiesHandle handle, const wchar_t* title)
• const wchar_t* xlCorePropertiesSubject(CorePropertiesHandle handle)
• void xlCorePropertiesSetSubject(CorePropertiesHandle handle, const wchar_t* subject)
• const wchar_t* xlCorePropertiesCreator(CorePropertiesHandle handle)
• void xlCorePropertiesSetCreator(CorePropertiesHandle handle, const wchar_t* creator)
• const wchar_t* xlCorePropertiesLastModifiedBy(CorePropertiesHandle handle)
• void xlCorePropertiesSetLastModifiedBy(CorePropertiesHandle handle, const wchar_t* lastModifiedBy)
• const wchar_t* xlCorePropertiesCreated(CorePropertiesHandle handle)
• void xlCorePropertiesSetCreated(CorePropertiesHandle handle, const wchar_t* created)
• double xlCorePropertiesCreatedAsDouble(CorePropertiesHandle handle)
• void xlCorePropertiesSetCreatedAsDouble(CorePropertiesHandle handle, double created)
• const wchar_t* xlCorePropertiesModified(CorePropertiesHandle handle)
• void xlCorePropertiesSetModified(CorePropertiesHandle handle, const wchar_t* modified)
• double xlCorePropertiesModifiedAsDouble(CorePropertiesHandle handle)
• void xlCorePropertiesSetModifiedAsDouble(CorePropertiesHandle handle, double modified)
• const wchar_t* xlCorePropertiesTags(CorePropertiesHandle handle)
• void xlCorePropertiesSetTags(CorePropertiesHandle handle, const wchar_t* tags)
• const wchar_t* xlCorePropertiesCategories(CorePropertiesHandle handle)
• void xlCorePropertiesSetCategories(CorePropertiesHandle handle, const wchar_t* categories)
• const wchar_t* xlCorePropertiesComments(CorePropertiesHandle handle)
• void xlCorePropertiesSetComments(CorePropertiesHandle handle, const wchar_t* comments)
• void xlCorePropertiesRemoveAll(CorePropertiesHandle handle)

Table functions

• const wchar_t* xlTableName(TableHandle handle)
• void xlTableSetName(TableHandle handle, const wchar_t* name)
• const wchar_t* xlTableRef(TableHandle handle)
• void xlTableSetRef(TableHandle handle, const wchar_t* ref)
• AutoFilterHandle xlTableAutoFilter(TableHandle handle)
• int xlTableStyle(TableHandle handle)
• void xlTableSetStyle(TableHandle handle, int tableStyle)
• int xlTableShowRowStripes(TableHandle handle)
• void xlTableSetShowRowStripes(TableHandle handle, int showRowStripes)
• int xlTableShowColumnStripes(TableHandle handle)
• void xlTableSetShowColumnStripes(TableHandle handle, int showColumnStripes)
• int xlTableShowFirstColumn(TableHandle handle)
• void xlTableSetShowFirstColumn(TableHandle handle, int showFirstColumn)
• int xlTableShowLastColumn(TableHandle handle)
• void xlTableSetShowLastColumn(TableHandle handle, int showLastColumn)
• int xlTableColumnSize(TableHandle handle)
• const wchar_t* xlTableColumnName(TableHandle handle, int columnIndex)
• int xlTableSetColumnName(TableHandle handle, int columnIndex, const wchar_t* name)