ElixirLibxl v0.1.0

View Source ElixirLibxl (ElixirLibxl v0.1.0)

LibXL elixir port

このモジュールを使用するにはLibXLのC言語ライブラリがインストールされていることが必須です。

  • 必須ヘッダ

/usr/local/include または /usr/include

/usr/local/include/AutoFilterA.h または /usr/include/AutoFilterA.h

/usr/local/include/AutoFilterW.h または /usr/include/AutoFilterW.h

/usr/local/include/BookA.h または /usr/include/BookA.h

/usr/local/include/BookW.h または /usr/include/BookW.h

/usr/local/include/FilterColumnA.h または /usr/include/FilterColumnA.h

/usr/local/include/FilterColumnW.h または /usr/include/FilterColumnW.h

/usr/local/include/FontA.h または /usr/include/FontA.h

/usr/local/include/FontW.h または /usr/include/FontW.h

/usr/local/include/FormControlA.h または /usr/include/FormControlA.h

/usr/local/include/FormControlW.h または /usr/include/FormControlW.h

/usr/local/include/FormatA.h または /usr/include/FormatA.h

/usr/local/include/FormatW.h または /usr/include/FormatW.h

/usr/local/include/RichStringA.h または /usr/include/RichStringA.h

/usr/local/include/RichStringW.h または /usr/include/RichStringW.h

/usr/local/include/SheetA.h または /usr/include/SheetA.h

/usr/local/include/SheetW.h または /usr/include/SheetW.h

/usr/local/include/enum.h または /usr/include/enum.h

/usr/local/include/handle.h または /usr/include/handle.h

/usr/local/include/libxl.h または /usr/include/libxl.h

/usr/local/include/setup.h または /usr/include/setup.h

  • 必須ライブラリ

/usr/local/lib/libxl.a または /usr/lib/libxl.a

/usr/local/lib/libxl.dylib または /usr/lib/libxl.dylib

/usr/local/lib/libxl.so または /usr/lib/libxl.so

install

def deps do
[
	{:elixir_libxl, "~> 0.1.0"}
]
end

基本的な使用方法

book_handle = ElixirLibxl.xlCreateXMLBook()

ElixirLibxl.xlBookLoad(book_handle, "path/to/xlsx")

ElixirLibxl.xlBookRelease(book_handle)

注意点

  • 定数はConstant.exに定義してありますが実際にコンパイルされた値ではないので注意してください。

  • 出力用のポインタ引数の存在する関数は引数には含まずListとして、関数の戻り値と共にreturnされます。

    • 例

    xlSheetMerge()のC言語プロトタイプはint xlSheetMerge(SheetHandle handle, int index, int* rowFirst, int* rowLast, int* colFirst, int* colLast);

    となっていますが本モジュールでは@spec xlSheetMerge(reference(), integer()) :: [integer()]となります。

Link to this section Summary

Functions

load_nif()
xlAutoFilterAddSort(handle, columnIndex, descending)
xlAutoFilterColumn(handle, colId)
xlAutoFilterColumnByIndex(handle, index)
xlAutoFilterColumnSize(handle)
xlAutoFilterGetRef(handle)
xlAutoFilterGetSort(handle)
xlAutoFilterGetSortRange(handle)
xlAutoFilterSetRef(handle, rowFirst, rowLast, colFirst, colLast)
xlAutoFilterSetSort(handle, columnIndex, descending)
xlBookActiveSheet(handle)
xlBookAddCustomNumFormat(handle, customnumformat)
xlBookAddFont(handle, initfont)
xlBookAddFormat(handle, initformat)
xlBookAddPicture2(handle, data, size)
xlBookAddPicture(handle, filename)
xlBookAddPictureAsLink(handle, filename, insert)
xlBookAddRichString(handle)
xlBookAddSheet(handle, name, initsheet)
xlBookBiffVersion(handle)
xlBookCalcMode(handle)
xlBookColorPack(handle, red, green, blue)
xlBookColorUnpack(handle, color)
xlBookCustomNumFormat(handle, fmt)
xlBookDatePack(handle, year, month, day, hour, min, sec, msec)
xlBookDateUnpack(handle, value)
xlBookDefaultFont(handle)
xlBookDelSheet(handle, index)
xlBookErrorMessage(handle)
xlBookFont(handle, index)
xlBookFontSize(handle)
xlBookFormat(handle, index)
xlBookFormatSize(handle)
xlBookGetPicture(handle, index)
xlBookGetSheet(handle, index)
xlBookGetSheetName(handle, index)
xlBookInsertSheet(handle, index, name, initsheet)
xlBookIsDate1904(handle)
xlBookIsTemplate(handle)
xlBookLoad(handle, filename)
xlBookLoadInfo(handle, filename)
xlBookLoadPartially(handle, filename, sheetindex, firstrow, lastrow)
xlBookLoadPartiallyUsingTempFile(handle, filename, sheetindex, firstrow, lastrow, tempfile)
xlBookLoadRaw(handle, data, size)
xlBookLoadRawPartially(handle, data, size, sheetindex, firstrow, lastrow)
xlBookLoadUsingTempFile(handle, filename, tempfile)
xlBookLoadWithoutEmptyCells(handle, filename)
xlBookMoveSheet(handle, srcindex, dstindex)
xlBookPictureSize(handle)
xlBookRefR1C1(handle)
xlBookRelease(handle)
xlBookRgbMode(handle)
xlBookSave(handle, filename)
xlBookSaveRaw(handle)
xlBookSaveUsingTempFile(handle, filename, usetempfile)
xlBookSetActiveSheet(handle, index)
xlBookSetCalcMode(handle, calcmode)
xlBookSetDate1904(handle, date1904)
xlBookSetDefaultFont(handle, fontname, fontsize)
xlBookSetKey(handle, name, key)
xlBookSetLocale(handle, locate)
xlBookSetRefR1C1(handle, refr1c1)
xlBookSetRgbMode(handle, rgbmode)
xlBookSetTemplate(handle, tmpl)
xlBookSheetCount(handle)
xlBookSheetType(handle, index)
xlBookVersion(handle)
xlCreateBook()
xlCreateXMLBook()
xlFilterColumnAddFilter(handle, value)
xlFilterColumnClear(handle)
xlFilterColumnFilter(handle, index)
xlFilterColumnFilterSize(handle)
xlFilterColumnFilterType(handle)
xlFilterColumnGetCustomFilter(handle)
xlFilterColumnGetTop10(handle)
xlFilterColumnIndex(handle)
xlFilterColumnSetCustomFilter(handle, op, val)
xlFilterColumnSetCustomFilterEx(handle, op1, v1, op2, v2, andOp)
xlFilterColumnSetTop10(handle, value, top, percent)
xlFontBold(handle)
xlFontColor(handle)
xlFontItalic(handle)
xlFontName(handle)
xlFontScript(handle)
xlFontSetBold(handle, bold)
xlFontSetColor(handle, color)
xlFontSetItalic(handle, italic)
xlFontSetName(handle, name)
xlFontSetScript(handle, script)
xlFontSetSize(handle, size)
xlFontSetStrikeOut(handle, strikeOut)
xlFontSetUnderline(handle, underline)
xlFontSize(handle)
xlFontStrikeOut(handle)
xlFontUnderline(handle)
xlFormatAlignH(handle)
xlFormatAlignV(handle)
xlFormatBorderBottom(handle)
xlFormatBorderBottomColor(handle)
xlFormatBorderDiagonal(handle)
xlFormatBorderDiagonalColor(handle)
xlFormatBorderDiagonalStyle(handle)
xlFormatBorderLeft(handle)
xlFormatBorderLeftColor(handle)
xlFormatBorderRight(handle)
xlFormatBorderRightColor(handle)
xlFormatBorderTop(handle)
xlFormatBorderTopColor(handle)
xlFormatFillPattern(handle)
xlFormatFont(handle)
xlFormatHidden(handle)
xlFormatIndent(handle)
xlFormatLocked(handle)
xlFormatNumFormat(handle)
xlFormatPatternBackgroundColor(handle)
xlFormatPatternForegroundColor(handle)
xlFormatRotation(handle)
xlFormatSetAlignH(handle, align)
xlFormatSetAlignV(handle, align)
xlFormatSetBorder(handle, style)
xlFormatSetBorderBottom(handle, style)
xlFormatSetBorderBottomColor(handle, color)
xlFormatSetBorderColor(handle, color)
xlFormatSetBorderDiagonal(handle, border)
xlFormatSetBorderDiagonalColor(handle, color)
xlFormatSetBorderDiagonalStyle(handle, style)
xlFormatSetBorderLeft(handle, style)
xlFormatSetBorderLeftColor(handle, color)
xlFormatSetBorderRight(handle, style)
xlFormatSetBorderRightColor(handle, color)
xlFormatSetBorderTop(handle, style)
xlFormatSetBorderTopColor(handle, color)
xlFormatSetFillPattern(handle, pattern)
xlFormatSetFont(handle, fontHandle)
xlFormatSetHidden(handle, hidden)
xlFormatSetIndent(handle, indent)
xlFormatSetLocked(handle, locked)
xlFormatSetNumFormat(handle, numFormat)
xlFormatSetPatternBackgroundColor(handle, color)
xlFormatSetPatternForegroundColor(handle, color)
xlFormatSetRotation(handle, rotation)
xlFormatSetShrinkToFit(handle, shrinkToFit)
xlFormatSetWrap(handle, wrap)
xlFormatShrinkToFit(handle)
xlFormatWrap(handle)
xlFormControlAddItem(handle, value)
xlFormControlAltText(handle)
xlFormControlChecked(handle)
xlFormControlClearItems(handle)
xlFormControlDefaultSize(handle)
xlFormControlDisabled(handle)
xlFormControlDropLines(handle)
xlFormControlDx(handle)
xlFormControlFirstButton(handle)
xlFormControlFmlaGroup(handle)
xlFormControlFmlaLink(handle)
xlFormControlFmlaRange(handle)
xlFormControlFmlaTxbx(handle)
xlFormControlFromAnchor(handle)
xlFormControlGetMax(handle)
xlFormControlGetMin(handle)
xlFormControlHoriz(handle)
xlFormControlInc(handle)
xlFormControlInsertItem(handle, index, value)
xlFormControlItem(handle, index)
xlFormControlItemSize(handle)
xlFormControlLinkedCell(handle)
xlFormControlListFillRange(handle)
xlFormControlLocked(handle)
xlFormControlMacro(handle)
xlFormControlMultiSel(handle)
xlFormControlName(handle)
xlFormControlObjectType(handle)
xlFormControlPrint(handle)
xlFormControlSel(handle)
xlFormControlSetChecked(handle, checked)
xlFormControlSetDropLines(handle, lines)
xlFormControlSetDx(handle, dx)
xlFormControlSetFirstButton(handle, firstButton)
xlFormControlSetFmlaGroup(handle, group)
xlFormControlSetFmlaLink(handle, link)
xlFormControlSetFmlaRange(handle, range)
xlFormControlSetFmlaTxbx(handle, txbx)
xlFormControlSetHoriz(handle, horiz)
xlFormControlSetInc(handle, inc)
xlFormControlSetMax(handle, max)
xlFormControlSetMin(handle, min)
xlFormControlSetMultiSel(handle, value)
xlFormControlSetSel(handle, sel)
xlFormControlToAnchor(handle)
xlRichStringAddFont(handle, initFont)
xlRichStringAddText(handle, text, font)
xlRichStringGetText(handle, index, font)
xlRichStringTextSize(handle)
xlSheetAddDataValidation(handle, type, op, rowFirst, rowLast, colFirst, colLast, value1, value2)
xlSheetAddDataValidationDouble(handle, type, op, rowFirst, rowLast, colFirst, colLast, value1, value2)
xlSheetAddDataValidationDoubleEx(handle, type, op, rowFirst, rowLast, colFirst, colLast, value1, value2, allowBlank, hideDropDown, showInputMessage, showErrorMessage, promptTitle, prompt, errorTitle, error, errorStyle)
xlSheetAddDataValidationEx(handle, type, op, rowFirst, rowLast, colFirst, colLast, value1, value2, allowBlank, hideDropDown, showInputMessage, showErrorMessage, promptTitle, prompt, errorTitle, error, errorStyle)
xlSheetAddHyperlink(handle, hyperlink, rowFirst, rowLast, colFirst, colLast)
xlSheetAddIgnoredError(handle, rowFirst, colFirst, rowLast, colLast, iError)
xlSheetAddrToRowCol(handle, addr)
xlSheetApplyFilter(handle)
xlSheetAutoFilter(handle)
xlSheetCellFormat(handle, row, col)
xlSheetCellType(handle, row, col)
xlSheetClear(handle, rowFirst, rowLast, colFirst, colLast)
xlSheetClearPrintArea(handle)
xlSheetClearPrintRepeats(handle)
xlSheetColHidden(handle, col)
xlSheetColWidth(handle, col)
xlSheetColWidthPx(handle, col)
xlSheetCopyCell(handle, rowSrc, colSrc, rowDst, colDst)
xlSheetDelHyperlink(handle, index)
xlSheetDelMerge(handle, row, col)
xlSheetDelMergeByIndex(handle, index)
xlSheetDelNamedRange(handle, name, scopeId)
xlSheetDisplayGridlines(handle)
xlSheetFirstCol(handle)
xlSheetFirstFilledCol(handle)
xlSheetFirstFilledRow(handle)
xlSheetFirstRow(handle)
xlSheetFooter(handle)
xlSheetFooterMargin(handle)
xlSheetFormControl(handle, index)
xlSheetFormControlSize(handle)
xlSheetGetHorPageBreak(handle, index)
xlSheetGetHorPageBreakSize(handle)
xlSheetGetMerge(handle, row, col)
xlSheetGetNamedRange(handle, name, scopedId)
xlSheetGetPicture(handle, index)
xlSheetGetPrintFit(handle)
xlSheetGetTopLeftView(handle)
xlSheetGetVerPageBreak(handle, index)
xlSheetGetVerPageBreakSize(handle)
xlSheetGroupCols(handle, colFirst, colLast, collapsed)
xlSheetGroupRows(handle, rowFirst, rowLast, collapsed)
xlSheetGroupSummaryBelow(handle)
xlSheetGroupSummaryRight(handle)
xlSheetHCenter(handle)
xlSheetHeader(handle)
xlSheetHeaderMargin(handle)
xlSheetHidden(handle)
xlSheetHyperlink(handle, index)
xlSheetHyperlinkSize(handle)
xlSheetInsertCol(handle, colFirst, colLast)
xlSheetInsertColAndKeepRanges(handle, colFirst, colLast)
xlSheetInsertRow(handle, rowFirst, rowLast)
xlSheetInsertRowAndKeepRanges(handle, rowFirst, rowLast)
xlSheetIsAutoFilter(handle)
xlSheetIsDate(handle, row, col)
xlSheetIsFormula(handle, row, col)
xlSheetIsRichStr(handle, row, col)
xlSheetLandscape(handle)
xlSheetLastCol(handle)
xlSheetLastFilledCol(handle)
xlSheetLastFilledRow(handle)
xlSheetLastRow(handle)
xlSheetMarginBottom(handle)
xlSheetMarginLeft(handle)
xlSheetMarginRight(handle)
xlSheetMarginTop(handle)
xlSheetMerge(handle, index)
xlSheetMergeSize(handle)
xlSheetName(handle)
xlSheetNamedRange(handle, index)
xlSheetNamedRangeSize(handle)
xlSheetPaper(handle)
xlSheetPictureSize(handle)
xlSheetPrintArea(handle)
xlSheetPrintGridlines(handle)
xlSheetPrintRepeatCols(handle)
xlSheetPrintRepeatRows(handle)
xlSheetPrintRowCol(handle)
xlSheetPrintZoom(handle)
xlSheetProtect(handle)
xlSheetReadBlank(handle, row, col)
xlSheetReadBool(handle, row, col)
xlSheetReadComment(handle, row, col)
xlSheetReadError(handle, row, col)
xlSheetReadFormula(handle, row, col)
xlSheetReadNum(handle, row, col)
xlSheetReadRichStr(handle, row, col)
xlSheetReadStr(handle, row, col)
xlSheetRemoveCol(handle, colFirst, colLast)
xlSheetRemoveColAndKeepRanges(handle, colFirst, colLast)
xlSheetRemoveComment(handle, row, col)
xlSheetRemoveDataValidations(handle)
xlSheetRemoveFilter(handle)
xlSheetRemovePicture(handle, row, col)
xlSheetRemovePictureByIndex(handle, index)
xlSheetRemoveRow(handle, rowFirst, rowLast)
xlSheetRemoveRowAndKeepRanges(handle, rowFirst, rowLast)
xlSheetRightToLeft(handle)
xlSheetRowColToAddr(handle, row, col, rowRelative, colRelative)
xlSheetRowHeight(handle, row)
xlSheetRowHeightPx(handle, row)
xlSheetRowHidden(handle, row)
xlSheetSetAutoFitArea(handle, rowFirst, colFirst, rowLast, colLast)
xlSheetSetCellFormat(handle, row, col, format)
xlSheetSetCol(handle, colFirst, colLast, width, format, hidden)
xlSheetSetColHidden(handle, col, hidden)
xlSheetSetDisplayGridlines(handle, show)
xlSheetSetFooter(handle, footer, margin)
xlSheetSetGroupSummaryBelow(handle, below)
xlSheetSetGroupSummaryRight(handle, right)
xlSheetSetHCenter(handle, hCenter)
xlSheetSetHeader(handle, header, margin)
xlSheetSetHidden(handle, hidden)
xlSheetSetHorPageBreak(handle, row, pageBreak)
xlSheetSetLandscape(handle, landscape)
xlSheetSetMarginBottom(handle, margin)
xlSheetSetMarginLeft(handle, margin)
xlSheetSetMarginRight(handle, margin)
xlSheetSetMarginTop(handle, margin)
xlSheetSetMerge(handle, rowFirst, rowLast, colFirst, colLast)
xlSheetSetName(handle, name)
xlSheetSetNamedRange(handle, name, rowFirst, rowLast, colFirst, colLast, scopeId)
xlSheetSetPaper(handle, paper)
xlSheetSetPicture2(handle, row, col, pictureId, width, height, offset_x, offset_y, pos)
xlSheetSetPicture(handle, row, col, pictureId, scale, offset_x, offset_y, pos)
xlSheetSetPrintArea(handle, rowFirst, rowLast, colFirst, colLast)
xlSheetSetPrintFit(handle, wPages, hPages)
xlSheetSetPrintGridlines(handle, print)
xlSheetSetPrintRepeatCols(handle, colFirst, colLast)
xlSheetSetPrintRepeatRows(handle, rowFirst, rowLast)
xlSheetSetPrintRowCol(handle, print)
xlSheetSetPrintZoom(handle, zoom)
xlSheetSetProtect(handle, protect)
xlSheetSetProtectEx(handle, protect, password, enhancedProtection)
xlSheetSetRightToLeft(handle, rightToLeft)
xlSheetSetRow(handle, row, height, format, hidden)
xlSheetSetRowHidden(handle, row, hidden)
xlSheetSetTabColor(handle, color)
xlSheetSetTabRgbColor(handle, red, green, blue)
xlSheetSetTopLeftView(handle, row, col)
xlSheetSetVCenter(handle, vCenter)
xlSheetSetVerPageBreak(handle, col, pageBreak)
xlSheetSetZoom(handle, zoom)
xlSheetSplit(handle, row, col)
xlSheetSplitInfo(handle)
xlSheetTable(handle, index)
xlSheetTableSize(handle)
xlSheetVCenter(handle)
xlSheetWriteBlank(handle, row, col, format)
xlSheetWriteBool(handle, row, col, value, format)
xlSheetWriteComment(handle, row, col, value, author, width, height)
xlSheetWriteError(handle, row, col, error, format)
xlSheetWriteFormula(handle, row, col, value, format)
xlSheetWriteFormulaBool(handle, row, col, expr, value, format)
xlSheetWriteFormulaNum(handle, row, col, expr, value, format)
xlSheetWriteFormulaStr(handle, row, col, expr, value, format)
xlSheetWriteNum(handle, row, col, value, format)
xlSheetWriteRichStr(handle, row, col, richString, format)
xlSheetWriteStr(handle, row, col, value, format)
xlSheetWriteStrAsNum(handle, row, col, value, format)
xlSheetZoom(handle)

Link to this section Functions

Link to this function

load_nif()

View Source
Link to this function

xlAutoFilterAddSort(handle, columnIndex, descending)

View Source 
@spec xlAutoFilterAddSort(reference(), integer(), integer()) :: integer()
Link to this function

xlAutoFilterColumn(handle, colId)

View Source 
@spec xlAutoFilterColumn(reference(), integer()) :: reference() | nil
Link to this function

xlAutoFilterColumnByIndex(handle, index)

View Source 
@spec xlAutoFilterColumnByIndex(reference(), integer()) :: reference() | nil
Link to this function

xlAutoFilterColumnSize(handle)

View Source 
@spec xlAutoFilterColumnSize(reference()) :: integer()
Link to this function

xlAutoFilterGetRef(handle)

View Source 
@spec xlAutoFilterGetRef(reference()) :: [integer()]
Link to this function

xlAutoFilterGetSort(handle)

View Source 
@spec xlAutoFilterGetSort(reference()) :: [integer()]
Link to this function

xlAutoFilterGetSortRange(handle)

View Source 
@spec xlAutoFilterGetSortRange(reference()) :: [integer()]
Link to this function

xlAutoFilterSetRef(handle, rowFirst, rowLast, colFirst, colLast)

View Source 
@spec xlAutoFilterSetRef(reference(), integer(), integer(), integer(), integer()) ::
  nil
Link to this function

xlAutoFilterSetSort(handle, columnIndex, descending)

View Source 
@spec xlAutoFilterSetSort(reference(), integer(), integer()) :: integer()
Link to this function

xlBookActiveSheet(handle)

View Source 
@spec xlBookActiveSheet(reference()) :: integer()
Link to this function

xlBookAddCustomNumFormat(handle, customnumformat)

View Source 
@spec xlBookAddCustomNumFormat(reference(), String.t()) :: integer()
Link to this function

xlBookAddFont(handle, initfont)

View Source 
@spec xlBookAddFont(reference(), reference() | nil) :: integer()
Link to this function

xlBookAddFormat(handle, initformat)

View Source 
@spec xlBookAddFormat(reference(), reference() | nil) :: integer()
Link to this function

xlBookAddPicture2(handle, data, size)

View Source 
@spec xlBookAddPicture2(reference(), String.t(), integer()) :: integer()
Link to this function

xlBookAddPicture(handle, filename)

View Source 
@spec xlBookAddPicture(reference(), String.t()) :: integer()
Link to this function

xlBookAddPictureAsLink(handle, filename, insert)

View Source 
@spec xlBookAddPictureAsLink(reference(), String.t(), integer()) :: integer()
Link to this function

xlBookAddRichString(handle)

View Source 
@spec xlBookAddRichString(reference()) :: integer()
Link to this function

xlBookAddSheet(handle, name, initsheet)

View Source 
@spec xlBookAddSheet(reference(), String.t(), reference() | nil) :: integer()
Link to this function

xlBookBiffVersion(handle)

View Source 
@spec xlBookBiffVersion(reference()) :: integer()
Link to this function

xlBookCalcMode(handle)

View Source 
@spec xlBookCalcMode(reference()) :: integer()
Link to this function

xlBookColorPack(handle, red, green, blue)

View Source 
@spec xlBookColorPack(reference(), integer(), integer(), integer()) :: integer()
Link to this function

xlBookColorUnpack(handle, color)

View Source 
@spec xlBookColorUnpack(reference(), integer()) :: nil
Link to this function

xlBookCustomNumFormat(handle, fmt)

View Source 
@spec xlBookCustomNumFormat(reference(), integer()) :: integer()
Link to this function

xlBookDatePack(handle, year, month, day, hour, min, sec, msec)

View Source 
@spec xlBookDatePack(
  reference(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer()
) :: integer()
Link to this function

xlBookDateUnpack(handle, value)

View Source 
@spec xlBookDateUnpack(reference(), float()) :: [any()]
Link to this function

xlBookDefaultFont(handle)

View Source 
@spec xlBookDefaultFont(reference()) :: [any()]
Link to this function

xlBookDelSheet(handle, index)

View Source 
@spec xlBookDelSheet(reference(), integer()) :: integer()
Link to this function

xlBookErrorMessage(handle)

View Source 
@spec xlBookErrorMessage(reference()) :: String.t()
Link to this function

xlBookFont(handle, index)

View Source 
@spec xlBookFont(reference(), integer()) :: integer()
Link to this function

xlBookFontSize(handle)

View Source 
@spec xlBookFontSize(reference()) :: integer()
Link to this function

xlBookFormat(handle, index)

View Source 
@spec xlBookFormat(reference(), integer()) :: integer()
Link to this function

xlBookFormatSize(handle)

View Source 
@spec xlBookFormatSize(reference()) :: integer()
Link to this function

xlBookGetPicture(handle, index)

View Source 
@spec xlBookGetPicture(reference(), integer()) :: [any()]
Link to this function

xlBookGetSheet(handle, index)

View Source 
@spec xlBookGetSheet(reference(), integer()) :: integer()
Link to this function

xlBookGetSheetName(handle, index)

View Source 
@spec xlBookGetSheetName(reference(), integer()) :: integer()
Link to this function

xlBookInsertSheet(handle, index, name, initsheet)

View Source 
@spec xlBookInsertSheet(reference(), integer(), String.t(), reference() | nil) ::
  integer()
Link to this function

xlBookIsDate1904(handle)

View Source 
@spec xlBookIsDate1904(reference()) :: integer()
Link to this function

xlBookIsTemplate(handle)

View Source 
@spec xlBookIsTemplate(reference()) :: integer()
Link to this function

xlBookLoad(handle, filename)

View Source 
@spec xlBookLoad(reference(), String.t()) :: integer()
Link to this function

xlBookLoadInfo(handle, filename)

View Source 
@spec xlBookLoadInfo(reference(), String.t()) :: integer()
Link to this function

xlBookLoadPartially(handle, filename, sheetindex, firstrow, lastrow)

View Source 
@spec xlBookLoadPartially(reference(), String.t(), integer(), integer(), integer()) ::
  integer()
Link to this function

xlBookLoadPartiallyUsingTempFile(handle, filename, sheetindex, firstrow, lastrow, tempfile)

View Source 
@spec xlBookLoadPartiallyUsingTempFile(
  reference(),
  String.t(),
  integer(),
  integer(),
  integer(),
  String.t()
) :: integer()
Link to this function

xlBookLoadRaw(handle, data, size)

View Source 
@spec xlBookLoadRaw(reference(), String.t(), integer()) :: integer()
Link to this function

xlBookLoadRawPartially(handle, data, size, sheetindex, firstrow, lastrow)

View Source 
@spec xlBookLoadRawPartially(
  reference(),
  String.t(),
  integer(),
  integer(),
  integer(),
  integer()
) ::
  integer()
Link to this function

xlBookLoadUsingTempFile(handle, filename, tempfile)

View Source 
@spec xlBookLoadUsingTempFile(reference(), String.t(), String.t()) :: integer()
Link to this function

xlBookLoadWithoutEmptyCells(handle, filename)

View Source 
@spec xlBookLoadWithoutEmptyCells(reference(), String.t()) :: integer()
Link to this function

xlBookMoveSheet(handle, srcindex, dstindex)

View Source 
@spec xlBookMoveSheet(reference(), integer(), integer()) :: integer()
Link to this function

xlBookPictureSize(handle)

View Source 
@spec xlBookPictureSize(reference()) :: integer()
Link to this function

xlBookRefR1C1(handle)

View Source 
@spec xlBookRefR1C1(reference()) :: integer()
Link to this function

xlBookRelease(handle)

View Source 
@spec xlBookRelease(reference()) :: nil
Link to this function

xlBookRgbMode(handle)

View Source 
@spec xlBookRgbMode(reference()) :: integer()
Link to this function

xlBookSave(handle, filename)

View Source 
@spec xlBookSave(reference(), String.t()) :: integer()
Link to this function

xlBookSaveRaw(handle)

View Source 
@spec xlBookSaveRaw(reference()) :: [any()]
Link to this function

xlBookSaveUsingTempFile(handle, filename, usetempfile)

View Source 
@spec xlBookSaveUsingTempFile(reference(), String.t(), integer()) :: integer()
Link to this function

xlBookSetActiveSheet(handle, index)

View Source 
@spec xlBookSetActiveSheet(reference(), integer()) :: nil
Link to this function

xlBookSetCalcMode(handle, calcmode)

View Source 
@spec xlBookSetCalcMode(reference(), integer()) :: nil
Link to this function

xlBookSetDate1904(handle, date1904)

View Source 
@spec xlBookSetDate1904(reference(), integer()) :: nil
Link to this function

xlBookSetDefaultFont(handle, fontname, fontsize)

View Source 
@spec xlBookSetDefaultFont(reference(), String.t(), integer()) :: nil
Link to this function

xlBookSetKey(handle, name, key)

View Source 
@spec xlBookSetKey(reference(), String.t(), String.t()) :: nil
Link to this function

xlBookSetLocale(handle, locate)

View Source 
@spec xlBookSetLocale(reference(), String.t()) :: integer()
Link to this function

xlBookSetRefR1C1(handle, refr1c1)

View Source 
@spec xlBookSetRefR1C1(reference(), integer()) :: nil
Link to this function

xlBookSetRgbMode(handle, rgbmode)

View Source 
@spec xlBookSetRgbMode(reference(), integer()) :: nil
Link to this function

xlBookSetTemplate(handle, tmpl)

View Source 
@spec xlBookSetTemplate(reference(), integer()) :: nil
Link to this function

xlBookSheetCount(handle)

View Source 
@spec xlBookSheetCount(reference()) :: integer()
Link to this function

xlBookSheetType(handle, index)

View Source 
@spec xlBookSheetType(reference(), integer()) :: integer()
Link to this function

xlBookVersion(handle)

View Source 
@spec xlBookVersion(reference()) :: integer()
Link to this function

xlCreateBook()

View Source 
@spec xlCreateBook() :: reference() | nil
Link to this function

xlCreateXMLBook()

View Source 
@spec xlCreateXMLBook() :: reference() | nil
Link to this function

xlFilterColumnAddFilter(handle, value)

View Source 
@spec xlFilterColumnAddFilter(reference(), String.t()) :: nil
Link to this function

xlFilterColumnClear(handle)

View Source 
@spec xlFilterColumnClear(reference()) :: nil
Link to this function

xlFilterColumnFilter(handle, index)

View Source 
@spec xlFilterColumnFilter(reference(), integer()) :: String.t()
Link to this function

xlFilterColumnFilterSize(handle)

View Source 
@spec xlFilterColumnFilterSize(reference()) :: integer()
Link to this function

xlFilterColumnFilterType(handle)

View Source 
@spec xlFilterColumnFilterType(reference()) :: integer()
Link to this function

xlFilterColumnGetCustomFilter(handle)

View Source 
@spec xlFilterColumnGetCustomFilter(reference()) :: [any()]
Link to this function

xlFilterColumnGetTop10(handle)

View Source 
@spec xlFilterColumnGetTop10(reference()) :: [any()]
Link to this function

xlFilterColumnIndex(handle)

View Source 
@spec xlFilterColumnIndex(reference()) :: integer()
Link to this function

xlFilterColumnSetCustomFilter(handle, op, val)

View Source 
@spec xlFilterColumnSetCustomFilter(reference(), integer(), String.t()) :: nil
Link to this function

xlFilterColumnSetCustomFilterEx(handle, op1, v1, op2, v2, andOp)

View Source 
@spec xlFilterColumnSetCustomFilterEx(
  reference(),
  integer(),
  String.t(),
  integer(),
  String.t(),
  integer()
) :: nil
Link to this function

xlFilterColumnSetTop10(handle, value, top, percent)

View Source 
@spec xlFilterColumnSetTop10(reference(), float(), integer(), integer()) :: nil
Link to this function

xlFontBold(handle)

View Source 
@spec xlFontBold(reference()) :: integer()
Link to this function

xlFontColor(handle)

View Source 
@spec xlFontColor(reference()) :: integer()
Link to this function

xlFontItalic(handle)

View Source 
@spec xlFontItalic(reference()) :: integer()
Link to this function

xlFontName(handle)

View Source 
@spec xlFontName(reference()) :: integer()
Link to this function

xlFontScript(handle)

View Source 
@spec xlFontScript(reference()) :: integer()
Link to this function

xlFontSetBold(handle, bold)

View Source 
@spec xlFontSetBold(reference(), integer()) :: nil
Link to this function

xlFontSetColor(handle, color)

View Source 
@spec xlFontSetColor(reference(), integer()) :: nil
Link to this function

xlFontSetItalic(handle, italic)

View Source 
@spec xlFontSetItalic(reference(), integer()) :: nil
Link to this function

xlFontSetName(handle, name)

View Source 
@spec xlFontSetName(reference(), String.t()) :: nil
Link to this function

xlFontSetScript(handle, script)

View Source 
@spec xlFontSetScript(reference(), integer()) :: nil
Link to this function

xlFontSetSize(handle, size)

View Source 
@spec xlFontSetSize(reference(), integer()) :: nil
Link to this function

xlFontSetStrikeOut(handle, strikeOut)

View Source 
@spec xlFontSetStrikeOut(reference(), integer()) :: nil
Link to this function

xlFontSetUnderline(handle, underline)

View Source 
@spec xlFontSetUnderline(reference(), integer()) :: nil
Link to this function

xlFontSize(handle)

View Source 
@spec xlFontSize(reference()) :: integer()
Link to this function

xlFontStrikeOut(handle)

View Source 
@spec xlFontStrikeOut(reference()) :: integer()
Link to this function

xlFontUnderline(handle)

View Source 
@spec xlFontUnderline(reference()) :: integer()
Link to this function

xlFormatAlignH(handle)

View Source 
@spec xlFormatAlignH(reference()) :: integer()
Link to this function

xlFormatAlignV(handle)

View Source 
@spec xlFormatAlignV(reference()) :: integer()
Link to this function

xlFormatBorderBottom(handle)

View Source 
@spec xlFormatBorderBottom(reference()) :: integer()
Link to this function

xlFormatBorderBottomColor(handle)

View Source 
@spec xlFormatBorderBottomColor(reference()) :: integer()
Link to this function

xlFormatBorderDiagonal(handle)

View Source 
@spec xlFormatBorderDiagonal(reference()) :: integer()
Link to this function

xlFormatBorderDiagonalColor(handle)

View Source 
@spec xlFormatBorderDiagonalColor(reference()) :: integer()
Link to this function

xlFormatBorderDiagonalStyle(handle)

View Source 
@spec xlFormatBorderDiagonalStyle(reference()) :: integer()
Link to this function

xlFormatBorderLeft(handle)

View Source 
@spec xlFormatBorderLeft(reference()) :: integer()
Link to this function

xlFormatBorderLeftColor(handle)

View Source 
@spec xlFormatBorderLeftColor(reference()) :: integer()
Link to this function

xlFormatBorderRight(handle)

View Source 
@spec xlFormatBorderRight(reference()) :: integer()
Link to this function

xlFormatBorderRightColor(handle)

View Source 
@spec xlFormatBorderRightColor(reference()) :: integer()
Link to this function

xlFormatBorderTop(handle)

View Source 
@spec xlFormatBorderTop(reference()) :: integer()
Link to this function

xlFormatBorderTopColor(handle)

View Source 
@spec xlFormatBorderTopColor(reference()) :: integer()
Link to this function

xlFormatFillPattern(handle)

View Source 
@spec xlFormatFillPattern(reference()) :: integer()
Link to this function

xlFormatFont(handle)

View Source 
@spec xlFormatFont(reference()) :: reference() | nil
Link to this function

xlFormatHidden(handle)

View Source 
@spec xlFormatHidden(reference()) :: integer()
Link to this function

xlFormatIndent(handle)

View Source 
@spec xlFormatIndent(reference()) :: integer()
Link to this function

xlFormatLocked(handle)

View Source 
@spec xlFormatLocked(reference()) :: integer()
Link to this function

xlFormatNumFormat(handle)

View Source 
@spec xlFormatNumFormat(reference()) :: integer()
Link to this function

xlFormatPatternBackgroundColor(handle)

View Source 
@spec xlFormatPatternBackgroundColor(reference()) :: integer()
Link to this function

xlFormatPatternForegroundColor(handle)

View Source 
@spec xlFormatPatternForegroundColor(reference()) :: integer()
Link to this function

xlFormatRotation(handle)

View Source 
@spec xlFormatRotation(reference()) :: integer()
Link to this function

xlFormatSetAlignH(handle, align)

View Source 
@spec xlFormatSetAlignH(reference(), integer()) :: nil
Link to this function

xlFormatSetAlignV(handle, align)

View Source 
@spec xlFormatSetAlignV(reference(), integer()) :: nil
Link to this function

xlFormatSetBorder(handle, style)

View Source 
@spec xlFormatSetBorder(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderBottom(handle, style)

View Source 
@spec xlFormatSetBorderBottom(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderBottomColor(handle, color)

View Source 
@spec xlFormatSetBorderBottomColor(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderColor(handle, color)

View Source 
@spec xlFormatSetBorderColor(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderDiagonal(handle, border)

View Source 
@spec xlFormatSetBorderDiagonal(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderDiagonalColor(handle, color)

View Source 
@spec xlFormatSetBorderDiagonalColor(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderDiagonalStyle(handle, style)

View Source 
@spec xlFormatSetBorderDiagonalStyle(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderLeft(handle, style)

View Source 
@spec xlFormatSetBorderLeft(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderLeftColor(handle, color)

View Source 
@spec xlFormatSetBorderLeftColor(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderRight(handle, style)

View Source 
@spec xlFormatSetBorderRight(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderRightColor(handle, color)

View Source 
@spec xlFormatSetBorderRightColor(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderTop(handle, style)

View Source 
@spec xlFormatSetBorderTop(reference(), integer()) :: nil
Link to this function

xlFormatSetBorderTopColor(handle, color)

View Source 
@spec xlFormatSetBorderTopColor(reference(), integer()) :: nil
Link to this function

xlFormatSetFillPattern(handle, pattern)

View Source 
@spec xlFormatSetFillPattern(reference(), integer()) :: nil
Link to this function

xlFormatSetFont(handle, fontHandle)

View Source 
@spec xlFormatSetFont(reference(), reference()) :: integer()
Link to this function

xlFormatSetHidden(handle, hidden)

View Source 
@spec xlFormatSetHidden(reference(), integer()) :: nil
Link to this function

xlFormatSetIndent(handle, indent)

View Source 
@spec xlFormatSetIndent(reference(), integer()) :: nil
Link to this function

xlFormatSetLocked(handle, locked)

View Source 
@spec xlFormatSetLocked(reference(), integer()) :: nil
Link to this function

xlFormatSetNumFormat(handle, numFormat)

View Source 
@spec xlFormatSetNumFormat(reference(), integer()) :: nil
Link to this function

xlFormatSetPatternBackgroundColor(handle, color)

View Source 
@spec xlFormatSetPatternBackgroundColor(reference(), integer()) :: nil
Link to this function

xlFormatSetPatternForegroundColor(handle, color)

View Source 
@spec xlFormatSetPatternForegroundColor(reference(), integer()) :: nil
Link to this function

xlFormatSetRotation(handle, rotation)

View Source 
@spec xlFormatSetRotation(reference(), integer()) :: integer()
Link to this function

xlFormatSetShrinkToFit(handle, shrinkToFit)

View Source 
@spec xlFormatSetShrinkToFit(reference(), integer()) :: nil
Link to this function

xlFormatSetWrap(handle, wrap)

View Source 
@spec xlFormatSetWrap(reference(), integer()) :: nil
Link to this function

xlFormatShrinkToFit(handle)

View Source 
@spec xlFormatShrinkToFit(reference()) :: integer()
Link to this function

xlFormatWrap(handle)

View Source 
@spec xlFormatWrap(reference()) :: integer()
Link to this function

xlFormControlAddItem(handle, value)

View Source 
@spec xlFormControlAddItem(reference(), String.t()) :: nil
Link to this function

xlFormControlAltText(handle)

View Source 
@spec xlFormControlAltText(reference()) :: String.t()
Link to this function

xlFormControlChecked(handle)

View Source 
@spec xlFormControlChecked(reference()) :: integer()
Link to this function

xlFormControlClearItems(handle)

View Source 
@spec xlFormControlClearItems(reference()) :: nil
Link to this function

xlFormControlDefaultSize(handle)

View Source 
@spec xlFormControlDefaultSize(reference()) :: integer()
Link to this function

xlFormControlDisabled(handle)

View Source 
@spec xlFormControlDisabled(reference()) :: integer()
Link to this function

xlFormControlDropLines(handle)

View Source 
@spec xlFormControlDropLines(reference()) :: integer()
Link to this function

xlFormControlDx(handle)

View Source 
@spec xlFormControlDx(reference()) :: integer()
Link to this function

xlFormControlFirstButton(handle)

View Source 
@spec xlFormControlFirstButton(reference()) :: integer()
Link to this function

xlFormControlFmlaGroup(handle)

View Source 
@spec xlFormControlFmlaGroup(reference()) :: String.t()
Link to this function

xlFormControlFmlaLink(handle)

View Source 
@spec xlFormControlFmlaLink(reference()) :: String.t()
Link to this function

xlFormControlFmlaRange(handle)

View Source 
@spec xlFormControlFmlaRange(reference()) :: String.t()
Link to this function

xlFormControlFmlaTxbx(handle)

View Source 
@spec xlFormControlFmlaTxbx(reference()) :: String.t()
Link to this function

xlFormControlFromAnchor(handle)

View Source 
@spec xlFormControlFromAnchor(reference()) :: [any()]
Link to this function

xlFormControlGetMax(handle)

View Source 
@spec xlFormControlGetMax(reference()) :: integer()
Link to this function

xlFormControlGetMin(handle)

View Source 
@spec xlFormControlGetMin(reference()) :: integer()
Link to this function

xlFormControlHoriz(handle)

View Source 
@spec xlFormControlHoriz(reference()) :: integer()
Link to this function

xlFormControlInc(handle)

View Source 
@spec xlFormControlInc(reference()) :: integer()
Link to this function

xlFormControlInsertItem(handle, index, value)

View Source 
@spec xlFormControlInsertItem(reference(), integer(), String.t()) :: nil
Link to this function

xlFormControlItem(handle, index)

View Source 
@spec xlFormControlItem(reference(), integer()) :: String.t()
Link to this function

xlFormControlItemSize(handle)

View Source 
@spec xlFormControlItemSize(reference()) :: integer()
Link to this function

xlFormControlLinkedCell(handle)

View Source 
@spec xlFormControlLinkedCell(reference()) :: String.t()
Link to this function

xlFormControlListFillRange(handle)

View Source 
@spec xlFormControlListFillRange(reference()) :: String.t()
Link to this function

xlFormControlLocked(handle)

View Source 
@spec xlFormControlLocked(reference()) :: integer()
Link to this function

xlFormControlMacro(handle)

View Source 
@spec xlFormControlMacro(reference()) :: String.t()
Link to this function

xlFormControlMultiSel(handle)

View Source 
@spec xlFormControlMultiSel(reference()) :: String.t()
Link to this function

xlFormControlName(handle)

View Source 
@spec xlFormControlName(reference()) :: String.t()
Link to this function

xlFormControlObjectType(handle)

View Source 
@spec xlFormControlObjectType(reference()) :: integer()
Link to this function

xlFormControlPrint(handle)

View Source 
@spec xlFormControlPrint(reference()) :: integer()
Link to this function

xlFormControlSel(handle)

View Source 
@spec xlFormControlSel(reference()) :: integer()
Link to this function

xlFormControlSetChecked(handle, checked)

View Source 
@spec xlFormControlSetChecked(reference(), integer()) :: nil
Link to this function

xlFormControlSetDropLines(handle, lines)

View Source 
@spec xlFormControlSetDropLines(reference(), integer()) :: nil
Link to this function

xlFormControlSetDx(handle, dx)

View Source 
@spec xlFormControlSetDx(reference(), integer()) :: nil
Link to this function

xlFormControlSetFirstButton(handle, firstButton)

View Source 
@spec xlFormControlSetFirstButton(reference(), integer()) :: nil
Link to this function

xlFormControlSetFmlaGroup(handle, group)

View Source 
@spec xlFormControlSetFmlaGroup(reference(), String.t()) :: nil
Link to this function

xlFormControlSetFmlaLink(handle, link)

View Source 
@spec xlFormControlSetFmlaLink(reference(), String.t()) :: nil
Link to this function

xlFormControlSetFmlaRange(handle, range)

View Source 
@spec xlFormControlSetFmlaRange(reference(), String.t()) :: nil
Link to this function

xlFormControlSetFmlaTxbx(handle, txbx)

View Source 
@spec xlFormControlSetFmlaTxbx(reference(), String.t()) :: nil
Link to this function

xlFormControlSetHoriz(handle, horiz)

View Source 
@spec xlFormControlSetHoriz(reference(), integer()) :: nil
Link to this function

xlFormControlSetInc(handle, inc)

View Source 
@spec xlFormControlSetInc(reference(), integer()) :: nil
Link to this function

xlFormControlSetMax(handle, max)

View Source 
@spec xlFormControlSetMax(reference(), integer()) :: nil
Link to this function

xlFormControlSetMin(handle, min)

View Source 
@spec xlFormControlSetMin(reference(), integer()) :: nil
Link to this function

xlFormControlSetMultiSel(handle, value)

View Source 
@spec xlFormControlSetMultiSel(reference(), String.t()) :: nil
Link to this function

xlFormControlSetSel(handle, sel)

View Source 
@spec xlFormControlSetSel(reference(), integer()) :: nil
Link to this function

xlFormControlToAnchor(handle)

View Source 
@spec xlFormControlToAnchor(reference()) :: [any()]
Link to this function

xlRichStringAddFont(handle, initFont)

View Source 
@spec xlRichStringAddFont(reference(), reference() | nil) :: reference() | nil
Link to this function

xlRichStringAddText(handle, text, font)

View Source 
@spec xlRichStringAddText(reference(), String.t(), reference()) :: nil
Link to this function

xlRichStringGetText(handle, index, font)

View Source 
@spec xlRichStringGetText(reference(), integer(), reference()) :: String.t()
Link to this function

xlRichStringTextSize(handle)

View Source 
@spec xlRichStringTextSize(reference()) :: integer()
Link to this function

xlSheetAddDataValidation(handle, type, op, rowFirst, rowLast, colFirst, colLast, value1, value2)

View Source 
@spec xlSheetAddDataValidation(
  reference(),
  String.t(),
  String.t(),
  String.t(),
  String.t(),
  String.t(),
  String.t(),
  String.t(),
  String.t()
) :: nil
Link to this function

xlSheetAddDataValidationDouble(handle, type, op, rowFirst, rowLast, colFirst, colLast, value1, value2)

View Source 
@spec xlSheetAddDataValidationDouble(
  reference(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  float(),
  float()
) :: nil
Link to this function

xlSheetAddDataValidationDoubleEx(handle, type, op, rowFirst, rowLast, colFirst, colLast, value1, value2, allowBlank, hideDropDown, showInputMessage, showErrorMessage, promptTitle, prompt, errorTitle, error, errorStyle)

View Source 
@spec xlSheetAddDataValidationDoubleEx(
  reference(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  float(),
  float(),
  integer(),
  integer(),
  integer(),
  integer(),
  String.t(),
  String.t(),
  String.t(),
  String.t(),
  integer()
) :: nil
Link to this function

xlSheetAddDataValidationEx(handle, type, op, rowFirst, rowLast, colFirst, colLast, value1, value2, allowBlank, hideDropDown, showInputMessage, showErrorMessage, promptTitle, prompt, errorTitle, error, errorStyle)

View Source 
@spec xlSheetAddDataValidationEx(
  reference(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  String.t(),
  String.t(),
  integer(),
  integer(),
  integer(),
  integer(),
  String.t(),
  String.t(),
  String.t(),
  String.t(),
  integer()
) :: nil
Link to this function

xlSheetAddHyperlink(handle, hyperlink, rowFirst, rowLast, colFirst, colLast)

View Source 
@spec xlSheetAddHyperlink(
  reference(),
  String.t(),
  integer(),
  integer(),
  integer(),
  integer()
) :: nil
Link to this function

xlSheetAddIgnoredError(handle, rowFirst, colFirst, rowLast, colLast, iError)

View Source 
@spec xlSheetAddIgnoredError(
  reference(),
  String.t(),
  String.t(),
  String.t(),
  String.t(),
  String.t()
) ::
  integer()
Link to this function

xlSheetAddrToRowCol(handle, addr)

View Source 
@spec xlSheetAddrToRowCol(reference(), String.t()) :: [any()]
Link to this function

xlSheetApplyFilter(handle)

View Source 
@spec xlSheetApplyFilter(reference()) :: nil
Link to this function

xlSheetAutoFilter(handle)

View Source 
@spec xlSheetAutoFilter(reference()) :: integer()
Link to this function

xlSheetCellFormat(handle, row, col)

View Source 
@spec xlSheetCellFormat(reference(), integer(), integer()) :: reference() | nil
Link to this function

xlSheetCellType(handle, row, col)

View Source 
@spec xlSheetCellType(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetClear(handle, rowFirst, rowLast, colFirst, colLast)

View Source 
@spec xlSheetClear(reference(), integer(), integer(), integer(), integer()) ::
  integer()
Link to this function

xlSheetClearPrintArea(handle)

View Source 
@spec xlSheetClearPrintArea(reference()) :: nil
Link to this function

xlSheetClearPrintRepeats(handle)

View Source 
@spec xlSheetClearPrintRepeats(reference()) :: nil
Link to this function

xlSheetColHidden(handle, col)

View Source 
@spec xlSheetColHidden(reference(), integer()) :: integer()
Link to this function

xlSheetColWidth(handle, col)

View Source 
@spec xlSheetColWidth(reference(), integer()) :: integer()
Link to this function

xlSheetColWidthPx(handle, col)

View Source 
@spec xlSheetColWidthPx(reference(), integer()) :: integer()
Link to this function

xlSheetCopyCell(handle, rowSrc, colSrc, rowDst, colDst)

View Source 
@spec xlSheetCopyCell(reference(), integer(), integer(), integer(), integer()) ::
  integer()
Link to this function

xlSheetDelHyperlink(handle, index)

View Source 
@spec xlSheetDelHyperlink(reference(), integer()) :: integer()
Link to this function

xlSheetDelMerge(handle, row, col)

View Source 
@spec xlSheetDelMerge(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetDelMergeByIndex(handle, index)

View Source 
@spec xlSheetDelMergeByIndex(reference(), integer()) :: integer()
Link to this function

xlSheetDelNamedRange(handle, name, scopeId)

View Source 
@spec xlSheetDelNamedRange(reference(), String.t(), integer()) :: integer()
Link to this function

xlSheetDisplayGridlines(handle)

View Source 
@spec xlSheetDisplayGridlines(reference()) :: integer()
Link to this function

xlSheetFirstCol(handle)

View Source 
@spec xlSheetFirstCol(reference()) :: integer()
Link to this function

xlSheetFirstFilledCol(handle)

View Source 
@spec xlSheetFirstFilledCol(reference()) :: integer()
Link to this function

xlSheetFirstFilledRow(handle)

View Source 
@spec xlSheetFirstFilledRow(reference()) :: integer()
Link to this function

xlSheetFirstRow(handle)

View Source 
@spec xlSheetFirstRow(reference()) :: integer()
Link to this function

xlSheetFooter(handle)

View Source 
@spec xlSheetFooter(reference()) :: integer()
Link to this function

xlSheetFooterMargin(handle)

View Source 
@spec xlSheetFooterMargin(reference()) :: integer()
Link to this function

xlSheetFormControl(handle, index)

View Source 
@spec xlSheetFormControl(reference(), integer()) :: reference() | nil
Link to this function

xlSheetFormControlSize(handle)

View Source 
@spec xlSheetFormControlSize(reference()) :: integer()
Link to this function

xlSheetGetHorPageBreak(handle, index)

View Source 
@spec xlSheetGetHorPageBreak(reference(), integer()) :: integer()
Link to this function

xlSheetGetHorPageBreakSize(handle)

View Source 
@spec xlSheetGetHorPageBreakSize(reference()) :: integer()
Link to this function

xlSheetGetMerge(handle, row, col)

View Source 
@spec xlSheetGetMerge(reference(), integer(), integer()) :: [any()]
Link to this function

xlSheetGetNamedRange(handle, name, scopedId)

View Source 
@spec xlSheetGetNamedRange(reference(), String.t(), integer()) :: [any()]
Link to this function

xlSheetGetPicture(handle, index)

View Source 
@spec xlSheetGetPicture(reference(), integer()) :: [any()]
Link to this function

xlSheetGetPrintFit(handle)

View Source 
@spec xlSheetGetPrintFit(reference()) :: [any()]
Link to this function

xlSheetGetTopLeftView(handle)

View Source 
@spec xlSheetGetTopLeftView(reference()) :: [any()]
Link to this function

xlSheetGetVerPageBreak(handle, index)

View Source 
@spec xlSheetGetVerPageBreak(reference(), integer()) :: integer()
Link to this function

xlSheetGetVerPageBreakSize(handle)

View Source 
@spec xlSheetGetVerPageBreakSize(reference()) :: integer()
Link to this function

xlSheetGroupCols(handle, colFirst, colLast, collapsed)

View Source 
@spec xlSheetGroupCols(reference(), integer(), integer(), integer()) :: integer()
Link to this function

xlSheetGroupRows(handle, rowFirst, rowLast, collapsed)

View Source 
@spec xlSheetGroupRows(reference(), integer(), integer(), integer()) :: integer()
Link to this function

xlSheetGroupSummaryBelow(handle)

View Source 
@spec xlSheetGroupSummaryBelow(reference()) :: integer()
Link to this function

xlSheetGroupSummaryRight(handle)

View Source 
@spec xlSheetGroupSummaryRight(reference()) :: integer()
Link to this function

xlSheetHCenter(handle)

View Source 
@spec xlSheetHCenter(reference()) :: integer()
Link to this function

xlSheetHeader(handle)

View Source 
@spec xlSheetHeader(reference()) :: integer()
Link to this function

xlSheetHeaderMargin(handle)

View Source 
@spec xlSheetHeaderMargin(reference()) :: integer()
Link to this function

xlSheetHidden(handle)

View Source 
@spec xlSheetHidden(reference()) :: integer()
Link to this function

xlSheetHyperlink(handle, index)

View Source 
@spec xlSheetHyperlink(reference(), integer()) :: [any()]
Link to this function

xlSheetHyperlinkSize(handle)

View Source 
@spec xlSheetHyperlinkSize(reference()) :: integer()
Link to this function

xlSheetInsertCol(handle, colFirst, colLast)

View Source 
@spec xlSheetInsertCol(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetInsertColAndKeepRanges(handle, colFirst, colLast)

View Source 
@spec xlSheetInsertColAndKeepRanges(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetInsertRow(handle, rowFirst, rowLast)

View Source 
@spec xlSheetInsertRow(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetInsertRowAndKeepRanges(handle, rowFirst, rowLast)

View Source 
@spec xlSheetInsertRowAndKeepRanges(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetIsAutoFilter(handle)

View Source 
@spec xlSheetIsAutoFilter(reference()) :: integer()
Link to this function

xlSheetIsDate(handle, row, col)

View Source 
@spec xlSheetIsDate(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetIsFormula(handle, row, col)

View Source 
@spec xlSheetIsFormula(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetIsRichStr(handle, row, col)

View Source 
@spec xlSheetIsRichStr(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetLandscape(handle)

View Source 
@spec xlSheetLandscape(reference()) :: integer()
Link to this function

xlSheetLastCol(handle)

View Source 
@spec xlSheetLastCol(reference()) :: integer()
Link to this function

xlSheetLastFilledCol(handle)

View Source 
@spec xlSheetLastFilledCol(reference()) :: integer()
Link to this function

xlSheetLastFilledRow(handle)

View Source 
@spec xlSheetLastFilledRow(reference()) :: integer()
Link to this function

xlSheetLastRow(handle)

View Source 
@spec xlSheetLastRow(reference()) :: integer()
Link to this function

xlSheetMarginBottom(handle)

View Source 
@spec xlSheetMarginBottom(reference()) :: integer()
Link to this function

xlSheetMarginLeft(handle)

View Source 
@spec xlSheetMarginLeft(reference()) :: integer()
Link to this function

xlSheetMarginRight(handle)

View Source 
@spec xlSheetMarginRight(reference()) :: integer()
Link to this function

xlSheetMarginTop(handle)

View Source 
@spec xlSheetMarginTop(reference()) :: integer()
Link to this function

xlSheetMerge(handle, index)

View Source 
@spec xlSheetMerge(reference(), integer()) :: [any()]
Link to this function

xlSheetMergeSize(handle)

View Source 
@spec xlSheetMergeSize(reference()) :: integer()
Link to this function

xlSheetName(handle)

View Source 
@spec xlSheetName(reference()) :: integer()
Link to this function

xlSheetNamedRange(handle, index)

View Source 
@spec xlSheetNamedRange(reference(), integer()) :: [any()]
Link to this function

xlSheetNamedRangeSize(handle)

View Source 
@spec xlSheetNamedRangeSize(reference()) :: integer()
Link to this function

xlSheetPaper(handle)

View Source 
@spec xlSheetPaper(reference()) :: integer()
Link to this function

xlSheetPictureSize(handle)

View Source 
@spec xlSheetPictureSize(reference()) :: integer()
Link to this function

xlSheetPrintArea(handle)

View Source 
@spec xlSheetPrintArea(reference()) :: [any()]
Link to this function

xlSheetPrintGridlines(handle)

View Source 
@spec xlSheetPrintGridlines(reference()) :: integer()
Link to this function

xlSheetPrintRepeatCols(handle)

View Source 
@spec xlSheetPrintRepeatCols(reference()) :: [any()]
Link to this function

xlSheetPrintRepeatRows(handle)

View Source 
@spec xlSheetPrintRepeatRows(reference()) :: [any()]
Link to this function

xlSheetPrintRowCol(handle)

View Source 
@spec xlSheetPrintRowCol(reference()) :: integer()
Link to this function

xlSheetPrintZoom(handle)

View Source 
@spec xlSheetPrintZoom(reference()) :: integer()
Link to this function

xlSheetProtect(handle)

View Source 
@spec xlSheetProtect(reference()) :: integer()
Link to this function

xlSheetReadBlank(handle, row, col)

View Source 
@spec xlSheetReadBlank(reference(), integer(), integer()) :: [any()]
Link to this function

xlSheetReadBool(handle, row, col)

View Source 
@spec xlSheetReadBool(reference(), integer(), integer()) :: [any()]
Link to this function

xlSheetReadComment(handle, row, col)

View Source 
@spec xlSheetReadComment(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetReadError(handle, row, col)

View Source 
@spec xlSheetReadError(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetReadFormula(handle, row, col)

View Source 
@spec xlSheetReadFormula(reference(), integer(), integer()) :: [any()]
Link to this function

xlSheetReadNum(handle, row, col)

View Source 
@spec xlSheetReadNum(reference(), integer(), integer()) :: [any()]
Link to this function

xlSheetReadRichStr(handle, row, col)

View Source 
@spec xlSheetReadRichStr(reference(), integer(), integer()) :: [any()]
Link to this function

xlSheetReadStr(handle, row, col)

View Source 
@spec xlSheetReadStr(reference(), reference(), reference()) :: [any()]
Link to this function

xlSheetRemoveCol(handle, colFirst, colLast)

View Source 
@spec xlSheetRemoveCol(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetRemoveColAndKeepRanges(handle, colFirst, colLast)

View Source 
@spec xlSheetRemoveColAndKeepRanges(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetRemoveComment(handle, row, col)

View Source 
@spec xlSheetRemoveComment(reference(), integer(), integer()) :: nil
Link to this function

xlSheetRemoveDataValidations(handle)

View Source 
@spec xlSheetRemoveDataValidations(reference()) :: nil
Link to this function

xlSheetRemoveFilter(handle)

View Source 
@spec xlSheetRemoveFilter(reference()) :: nil
Link to this function

xlSheetRemovePicture(handle, row, col)

View Source 
@spec xlSheetRemovePicture(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetRemovePictureByIndex(handle, index)

View Source 
@spec xlSheetRemovePictureByIndex(reference(), integer()) :: integer()
Link to this function

xlSheetRemoveRow(handle, rowFirst, rowLast)

View Source 
@spec xlSheetRemoveRow(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetRemoveRowAndKeepRanges(handle, rowFirst, rowLast)

View Source 
@spec xlSheetRemoveRowAndKeepRanges(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetRightToLeft(handle)

View Source 
@spec xlSheetRightToLeft(reference()) :: integer()
Link to this function

xlSheetRowColToAddr(handle, row, col, rowRelative, colRelative)

View Source 
@spec xlSheetRowColToAddr(reference(), String.t(), String.t(), String.t(), String.t()) ::
  integer()
Link to this function

xlSheetRowHeight(handle, row)

View Source 
@spec xlSheetRowHeight(reference(), integer()) :: integer()
Link to this function

xlSheetRowHeightPx(handle, row)

View Source 
@spec xlSheetRowHeightPx(reference(), integer()) :: integer()
Link to this function

xlSheetRowHidden(handle, row)

View Source 
@spec xlSheetRowHidden(reference(), integer()) :: integer()
Link to this function

xlSheetSetAutoFitArea(handle, rowFirst, colFirst, rowLast, colLast)

View Source 
@spec xlSheetSetAutoFitArea(reference(), integer(), integer(), integer(), integer()) ::
  nil
Link to this function

xlSheetSetCellFormat(handle, row, col, format)

View Source 
@spec xlSheetSetCellFormat(reference(), integer(), integer(), reference() | nil) ::
  nil
Link to this function

xlSheetSetCol(handle, colFirst, colLast, width, format, hidden)

View Source 
@spec xlSheetSetCol(
  reference(),
  integer(),
  integer(),
  float(),
  reference(),
  integer()
) :: integer()
Link to this function

xlSheetSetColHidden(handle, col, hidden)

View Source 
@spec xlSheetSetColHidden(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetSetDisplayGridlines(handle, show)

View Source 
@spec xlSheetSetDisplayGridlines(reference(), integer()) :: nil
Link to this function

xlSheetSetFooter(handle, footer, margin)

View Source 
@spec xlSheetSetFooter(reference(), String.t(), integer()) :: integer()
Link to this function

xlSheetSetGroupSummaryBelow(handle, below)

View Source 
@spec xlSheetSetGroupSummaryBelow(reference(), integer()) :: nil
Link to this function

xlSheetSetGroupSummaryRight(handle, right)

View Source 
@spec xlSheetSetGroupSummaryRight(reference(), integer()) :: nil
Link to this function

xlSheetSetHCenter(handle, hCenter)

View Source 
@spec xlSheetSetHCenter(reference(), integer()) :: nil
Link to this function

xlSheetSetHeader(handle, header, margin)

View Source 
@spec xlSheetSetHeader(reference(), String.t(), integer()) :: integer()
Link to this function

xlSheetSetHidden(handle, hidden)

View Source 
@spec xlSheetSetHidden(reference(), integer()) :: integer()
Link to this function

xlSheetSetHorPageBreak(handle, row, pageBreak)

View Source 
@spec xlSheetSetHorPageBreak(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetSetLandscape(handle, landscape)

View Source 
@spec xlSheetSetLandscape(reference(), integer()) :: nil
Link to this function

xlSheetSetMarginBottom(handle, margin)

View Source 
@spec xlSheetSetMarginBottom(reference(), float()) :: nil
Link to this function

xlSheetSetMarginLeft(handle, margin)

View Source 
@spec xlSheetSetMarginLeft(reference(), float()) :: nil
Link to this function

xlSheetSetMarginRight(handle, margin)

View Source 
@spec xlSheetSetMarginRight(reference(), float()) :: nil
Link to this function

xlSheetSetMarginTop(handle, margin)

View Source 
@spec xlSheetSetMarginTop(reference(), float()) :: nil
Link to this function

xlSheetSetMerge(handle, rowFirst, rowLast, colFirst, colLast)

View Source 
@spec xlSheetSetMerge(reference(), integer(), integer(), integer(), integer()) ::
  integer()
Link to this function

xlSheetSetName(handle, name)

View Source 
@spec xlSheetSetName(reference(), String.t()) :: nil
Link to this function

xlSheetSetNamedRange(handle, name, rowFirst, rowLast, colFirst, colLast, scopeId)

View Source 
@spec xlSheetSetNamedRange(
  reference(),
  String.t(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer()
) :: integer()
Link to this function

xlSheetSetPaper(handle, paper)

View Source 
@spec xlSheetSetPaper(reference(), integer()) :: nil
Link to this function

xlSheetSetPicture2(handle, row, col, pictureId, width, height, offset_x, offset_y, pos)

View Source 
@spec xlSheetSetPicture2(
  reference(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer(),
  integer()
) :: nil
Link to this function

xlSheetSetPicture(handle, row, col, pictureId, scale, offset_x, offset_y, pos)

View Source 
@spec xlSheetSetPicture(
  reference(),
  integer(),
  integer(),
  integer(),
  float(),
  integer(),
  integer(),
  integer()
) :: nil
Link to this function

xlSheetSetPrintArea(handle, rowFirst, rowLast, colFirst, colLast)

View Source 
@spec xlSheetSetPrintArea(reference(), integer(), integer(), integer(), integer()) ::
  nil
Link to this function

xlSheetSetPrintFit(handle, wPages, hPages)

View Source 
@spec xlSheetSetPrintFit(reference(), integer(), integer()) :: nil
Link to this function

xlSheetSetPrintGridlines(handle, print)

View Source 
@spec xlSheetSetPrintGridlines(reference(), integer()) :: nil
Link to this function

xlSheetSetPrintRepeatCols(handle, colFirst, colLast)

View Source 
@spec xlSheetSetPrintRepeatCols(reference(), integer(), integer()) :: nil
Link to this function

xlSheetSetPrintRepeatRows(handle, rowFirst, rowLast)

View Source 
@spec xlSheetSetPrintRepeatRows(reference(), integer(), integer()) :: nil
Link to this function

xlSheetSetPrintRowCol(handle, print)

View Source 
@spec xlSheetSetPrintRowCol(reference(), integer()) :: nil
Link to this function

xlSheetSetPrintZoom(handle, zoom)

View Source 
@spec xlSheetSetPrintZoom(reference(), integer()) :: nil
Link to this function

xlSheetSetProtect(handle, protect)

View Source 
@spec xlSheetSetProtect(reference(), integer()) :: nil
Link to this function

xlSheetSetProtectEx(handle, protect, password, enhancedProtection)

View Source 
@spec xlSheetSetProtectEx(reference(), integer(), String.t(), integer()) :: nil
Link to this function

xlSheetSetRightToLeft(handle, rightToLeft)

View Source 
@spec xlSheetSetRightToLeft(reference(), integer()) :: nil
Link to this function

xlSheetSetRow(handle, row, height, format, hidden)

View Source 
@spec xlSheetSetRow(reference(), integer(), float(), reference() | nil, integer()) ::
  integer()
Link to this function

xlSheetSetRowHidden(handle, row, hidden)

View Source 
@spec xlSheetSetRowHidden(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetSetTabColor(handle, color)

View Source 
@spec xlSheetSetTabColor(reference(), String.t()) :: nil
Link to this function

xlSheetSetTabRgbColor(handle, red, green, blue)

View Source 
@spec xlSheetSetTabRgbColor(reference(), String.t(), String.t(), String.t()) :: nil
Link to this function

xlSheetSetTopLeftView(handle, row, col)

View Source 
@spec xlSheetSetTopLeftView(reference(), integer(), integer()) :: nil
Link to this function

xlSheetSetVCenter(handle, vCenter)

View Source 
@spec xlSheetSetVCenter(reference(), integer()) :: nil
Link to this function

xlSheetSetVerPageBreak(handle, col, pageBreak)

View Source 
@spec xlSheetSetVerPageBreak(reference(), integer(), integer()) :: integer()
Link to this function

xlSheetSetZoom(handle, zoom)

View Source 
@spec xlSheetSetZoom(reference(), integer()) :: nil
Link to this function

xlSheetSplit(handle, row, col)

View Source 
@spec xlSheetSplit(reference(), integer(), integer()) :: nil
Link to this function

xlSheetSplitInfo(handle)

View Source 
@spec xlSheetSplitInfo(reference()) :: [any()]
Link to this function

xlSheetTable(handle, index)

View Source 
@spec xlSheetTable(reference(), integer()) :: [any()]
Link to this function

xlSheetTableSize(handle)

View Source 
@spec xlSheetTableSize(reference()) :: integer()
Link to this function

xlSheetVCenter(handle)

View Source 
@spec xlSheetVCenter(reference()) :: integer()
Link to this function

xlSheetWriteBlank(handle, row, col, format)

View Source 
@spec xlSheetWriteBlank(reference(), integer(), integer(), reference() | nil) ::
  integer()
Link to this function

xlSheetWriteBool(handle, row, col, value, format)

View Source 
@spec xlSheetWriteBool(
  reference(),
  integer(),
  integer(),
  integer(),
  reference() | nil
) :: integer()
Link to this function

xlSheetWriteComment(handle, row, col, value, author, width, height)

View Source 
@spec xlSheetWriteComment(
  reference(),
  integer(),
  integer(),
  String.t(),
  String.t(),
  integer(),
  integer()
) :: nil
Link to this function

xlSheetWriteError(handle, row, col, error, format)

View Source 
@spec xlSheetWriteError(
  reference(),
  integer(),
  integer(),
  integer(),
  reference() | nil
) :: nil
Link to this function

xlSheetWriteFormula(handle, row, col, value, format)

View Source 
@spec xlSheetWriteFormula(
  reference(),
  integer(),
  integer(),
  String.t(),
  reference() | nil
) :: integer()
Link to this function

xlSheetWriteFormulaBool(handle, row, col, expr, value, format)

View Source 
@spec xlSheetWriteFormulaBool(
  reference(),
  integer(),
  integer(),
  String.t(),
  integer(),
  reference() | nil
) :: integer()
Link to this function

xlSheetWriteFormulaNum(handle, row, col, expr, value, format)

View Source 
@spec xlSheetWriteFormulaNum(
  reference(),
  integer(),
  integer(),
  String.t(),
  float(),
  reference() | nil
) ::
  integer()
Link to this function

xlSheetWriteFormulaStr(handle, row, col, expr, value, format)

View Source 
@spec xlSheetWriteFormulaStr(
  reference(),
  integer(),
  integer(),
  String.t(),
  String.t(),
  reference() | nil
) :: integer()
Link to this function

xlSheetWriteNum(handle, row, col, value, format)

View Source 
@spec xlSheetWriteNum(reference(), integer(), integer(), float(), reference() | nil) ::
  integer()
Link to this function

xlSheetWriteRichStr(handle, row, col, richString, format)

View Source 
@spec xlSheetWriteRichStr(
  reference(),
  integer(),
  integer(),
  reference(),
  reference() | nil
) ::
  integer()
Link to this function

xlSheetWriteStr(handle, row, col, value, format)

View Source 
@spec xlSheetWriteStr(
  reference(),
  integer(),
  integer(),
  String.t(),
  reference() | nil
) :: integer()
Link to this function

xlSheetWriteStrAsNum(handle, row, col, value, format)

View Source 
@spec xlSheetWriteStrAsNum(
  reference(),
  integer(),
  integer(),
  String.t(),
  reference() | nil
) ::
  integer()
Link to this function

xlSheetZoom(handle)

View Source 
@spec xlSheetZoom(reference()) :: integer()