Excel Library

Buy Now! Free Download
...
AllWindowsiOS,OSXOther

Products
CDBF - DBF Viewer and Editor
DBF Viewer/Editor for iOS
DBF reanimator
CDBFlite
CDBFAPI
¤ Excel Library
DBF Script
CSV to DBF Converter
CSV to DBF Converter for Mac
CSV to XLS Converter
CSV to XLS Converter for Mac
CSV to SQLite Converter for Mac
XLS to DBF Converter
XLS to DBF Converter for Mac
XLS to CSV Converter
XLS to CSV Converter for Mac
XLS to JSON Converter
DBF to CSV Converter
DBF to CSV Converter for Mac
DBF to JSON Converter
DBF to XLS Converter
DBF to XLS Converter for Mac
DBF to MDB Converter
DBF to SQL Converter
DBF to SQL Converter for Mac
DBF to SQLite Converter for Mac
DBF to XML Converter
DBF to XML Converter for Mac
DBF to DBF Converter
DBF to DBF Converter for Mac
DBF to HTML Converter
MDB to DBF Converter
MDB to XLS Converter
MDB to CSV Converter
DBF to PDB Converter
PDB to DBF Converter

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)

Related Links
Functions

Copyright © WhiteTown Software, 1996-2017 | Privacy policy | Site map