Worksheet

Undocumented in source.
struct Worksheet {}

Constructors

this
this(lxw_worksheet* handle)
Undocumented in source.

Members

Functions

activate
void activate()
Undocumented in source. Be warned that the author may not have intended to support it.
autofilter
void autofilter(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol)
Undocumented in source. Be warned that the author may not have intended to support it.
centerHorizontally
void centerHorizontally()
Undocumented in source. Be warned that the author may not have intended to support it.
centerVertically
void centerVertically()
Undocumented in source. Be warned that the author may not have intended to support it.
dataValidationCell
void dataValidationCell(RowType row, ColType col, lxw_data_validation* validator)
Undocumented in source. Be warned that the author may not have intended to support it.
dataValidationRange
void dataValidationRange(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol, lxw_data_validation* validator)
Undocumented in source. Be warned that the author may not have intended to support it.
fitToPages
void fitToPages(ushort width, ushort height)
Undocumented in source. Be warned that the author may not have intended to support it.
freezePanes
void freezePanes(RowType row, ColType col)
Undocumented in source. Be warned that the author may not have intended to support it.
gridlines
void gridlines(ubyte option)
Undocumented in source. Be warned that the author may not have intended to support it.
hide
void hide()
Undocumented in source. Be warned that the author may not have intended to support it.
hideZero
void hideZero()
Undocumented in source. Be warned that the author may not have intended to support it.
insertChart
void insertChart(RowType row, ColType col, Chart chart)
Undocumented in source. Be warned that the author may not have intended to support it.
insertChartOpt
void insertChartOpt(RowType row, ColType col, Chart chart, lxw_image_options* options)
Undocumented in source. Be warned that the author may not have intended to support it.
insertImage
void insertImage(RowType row, ColType col, string filename)
Undocumented in source. Be warned that the author may not have intended to support it.
insertImageBuffer
void insertImageBuffer(RowType row, ColType col, const(ubyte)* buf, size_t bufSize)
Undocumented in source. Be warned that the author may not have intended to support it.
insertImageBufferOpt
void insertImageBufferOpt(RowType row, ColType col, const(ubyte)* buf, size_t bufSize, lxw_image_options* options)
Undocumented in source. Be warned that the author may not have intended to support it.
insertImageOpt
void insertImageOpt(RowType row, ColType col, string filename, lxw_image_options* options)
Undocumented in source. Be warned that the author may not have intended to support it.
mergeRange
void mergeRange(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol, string str)
Undocumented in source. Be warned that the author may not have intended to support it.
mergeRange
void mergeRange(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol, string str, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
mergeRangeFormat
void mergeRangeFormat(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol, string str, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
outlineSettings
void outlineSettings(ubyte visible, ubyte symbolsBelow, ubyte symbolsRight, ubyte autoStyle)
Undocumented in source. Be warned that the author may not have intended to support it.
printAcross
void printAcross()
Undocumented in source. Be warned that the author may not have intended to support it.
printArea
void printArea(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol)
Undocumented in source. Be warned that the author may not have intended to support it.
printRowColHeaders
void printRowColHeaders()
Undocumented in source. Be warned that the author may not have intended to support it.
protect
void protect(string password, lxw_protection* options)
Undocumented in source. Be warned that the author may not have intended to support it.
repeatColumns
void repeatColumns(ColType firstCol, ColType lastCol)
Undocumented in source. Be warned that the author may not have intended to support it.
repeatRows
void repeatRows(RowType firstRow, RowType lastRow)
Undocumented in source. Be warned that the author may not have intended to support it.
rightToLeft
void rightToLeft()
Undocumented in source. Be warned that the author may not have intended to support it.
select
void select()
Undocumented in source. Be warned that the author may not have intended to support it.
setColumn
void setColumn(ColType firstCol, ColType lastCol, double width)
Undocumented in source. Be warned that the author may not have intended to support it.
setColumn
void setColumn(ColType firstCol, ColType lastCol, double width, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
setColumnFormat
void setColumnFormat(ColType firstCol, ColType lastCol, double width, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
setColumnOpt
void setColumnOpt(ColType firstCol, ColType lastCol, double width, lxw_row_col_options* options)
Undocumented in source. Be warned that the author may not have intended to support it.
setColumnOpt
void setColumnOpt(ColType firstCol, ColType lastCol, double width, lxw_row_col_options* options, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
setColumnOptFormat
void setColumnOptFormat(ColType firstCol, ColType lastCol, double width, lxw_row_col_options* options, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
setDefaultRow
void setDefaultRow(double height, ubyte hideUnusedRows)
Undocumented in source. Be warned that the author may not have intended to support it.
setFirstSheet
void setFirstSheet()
Undocumented in source. Be warned that the author may not have intended to support it.
setFooter
void setFooter(string footer)
Undocumented in source. Be warned that the author may not have intended to support it.
setFooterOpt
void setFooterOpt(string footer, lxw_header_footer_options* options)
Undocumented in source. Be warned that the author may not have intended to support it.
setHPagebreaks
void setHPagebreaks(RowType[] row)
Undocumented in source. Be warned that the author may not have intended to support it.
setHeader
void setHeader(string header)
Undocumented in source. Be warned that the author may not have intended to support it.
setHeaderOpt
void setHeaderOpt(string header, lxw_header_footer_options* options)
Undocumented in source. Be warned that the author may not have intended to support it.
setLandscape
void setLandscape()
Undocumented in source. Be warned that the author may not have intended to support it.
setMargins
void setMargins(double left, double right, double top, double bottom)
Undocumented in source. Be warned that the author may not have intended to support it.
setPageView
void setPageView()
Undocumented in source. Be warned that the author may not have intended to support it.
setPaper
void setPaper(ubyte paperType)
Undocumented in source. Be warned that the author may not have intended to support it.
setPortrait
void setPortrait()
Undocumented in source. Be warned that the author may not have intended to support it.
setPrintScale
void setPrintScale(ushort scale)
Undocumented in source. Be warned that the author may not have intended to support it.
setRow
void setRow(RowType row, double height)
Undocumented in source. Be warned that the author may not have intended to support it.
setRow
void setRow(RowType row, double height, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
setRowFormat
void setRowFormat(RowType row, double height, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
setRowOpt
void setRowOpt(RowType row, double height, lxw_row_col_options* options)
Undocumented in source. Be warned that the author may not have intended to support it.
setRowOpt
void setRowOpt(RowType row, double height, lxw_row_col_options* options, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
setRowOptFormat
void setRowOptFormat(RowType row, double height, lxw_row_col_options* options, Format f)
Undocumented in source. Be warned that the author may not have intended to support it.
setSelection
void setSelection(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol)
Undocumented in source. Be warned that the author may not have intended to support it.
setStartPage
void setStartPage(ushort startPage)
Undocumented in source. Be warned that the author may not have intended to support it.
setTabColor
void setTabColor(lxw_color_t color)
Undocumented in source. Be warned that the author may not have intended to support it.
setVPagebreaks
void setVPagebreaks(ColType[] col)
Undocumented in source. Be warned that the author may not have intended to support it.
setZoom
void setZoom(ushort scale)
Undocumented in source. Be warned that the author may not have intended to support it.
splitPanes
void splitPanes(double vertical, double horizontal)
Undocumented in source. Be warned that the author may not have intended to support it.
write
void write(RowType row, ColType col, T value)
Undocumented in source. Be warned that the author may not have intended to support it.
write
void write(RowType row, ColType col, T value, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeAndGetWidth
size_t writeAndGetWidth(RowType row, ColType col, T value)
Undocumented in source. Be warned that the author may not have intended to support it.
writeAndGetWidth
size_t writeAndGetWidth(RowType row, ColType col, T value, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeArrayFormula
void writeArrayFormula(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol, string formula)
Undocumented in source. Be warned that the author may not have intended to support it.
writeArrayFormula
void writeArrayFormula(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol, string formula, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeArrayFormulaFormat
void writeArrayFormulaFormat(RowType firstRow, ColType firstCol, RowType lastRow, ColType lastCol, string formula, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeBlankImpl
void writeBlankImpl(RowType row, ColType col, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeBooleanImpl
void writeBooleanImpl(RowType row, ColType col, bool value, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeDatetimeImpl
void writeDatetimeImpl(RowType row, ColType col, Datetime datetime, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeFormulaNumImpl
void writeFormulaNumImpl(RowType row, ColType col, string formula, double value, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeIntImpl
void writeIntImpl(RowType row, ColType col, double num, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeNumberImpl
void writeNumberImpl(RowType row, ColType col, double num, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeRichStringImpl
void writeRichStringImpl(RowType row, ColType col, lxw_rich_string_tuple** rst, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeStringImpl
void writeStringImpl(RowType row, ColType col, string str, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.
writeUrlImpl
void writeUrlImpl(RowType row, ColType col, string url, Format format)
Undocumented in source. Be warned that the author may not have intended to support it.

Variables

handle
lxw_worksheet* handle;
Undocumented in source.

Meta