Excel library functions

Factory functions

  • BookHandle xlCreateBook()
    Create a binary book instance for xls format. This function should be called first for receiving a book handler.
  • BookHandle xlCreateXMLBook()
    Create a xml book instance for xlsx format. 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 xlBookLoadRaw(BookHandle handle, const char* data, unsigned size)
  • int xlBookSaveRaw(BookHandle handle, const char** data, unsigned* size)
  • SheetHandle xlBookAddSheet(BookHandle handle, const wchar_t* name, SheetHandle initSheet)
  • SheetHandle xlBookGetSheet(BookHandle handle, int index)
  • int xlBookDelSheet(BookHandle handle, int index)
  • int xlBookSheetCount(BookHandle handle)
  • FormatHandle xlBookAddFormat(BookHandle handle, FormatHandle initFormat)
  • FontHandle xlBookAddFont(BookHandle handle, FontHandle initFont)
  • 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)
  • 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 xlBookAddPicture(BookHandle handle, const wchar_t* filename)
  • int xlBookAddPicture2(BookHandle handle, const char* data, unsigned size)
  • 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)
  • void xlBookSetKey(BookHandle handle, const wchar_t* name, const wchar_t* key)
  • void 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)
  • 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)
  • 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)
  • int xlSheetIsDate(SheetHandle handle, int row, int col)
  • int xlSheetReadError(SheetHandle handle, int row, int col)
  • double xlSheetColWidth(SheetHandle handle, int col)
  • double xlSheetRowHeight(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 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)
  • void xlSheetSetPicture(SheetHandle handle, int row, int col, int pictureId, double scale)
  • void xlSheetSetPicture2(SheetHandle handle, int row, int col, int pictureId, int width, int height)
  • 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 xlSheetGroupRows(SheetHandle handle, int rowFirst, int rowLast, int collapsed)
  • int xlSheetGroupCols(SheetHandle handle, int colFirst, int colLast, int collapsed)
  • void 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 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 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 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)
  • const wchar_t* xlSheetName(SheetHandle handle)
  • void xlSheetSetName(SheetHandle handle, const wchar_t* name)
  • int xlSheetProtect(SheetHandle handle)
  • void xlSheetSetProtect(SheetHandle handle, int protect)

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(FomatHandle 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 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)