Keyword to BorderStyle for every BorderStyle value, e.g. :thin, :medium-dashed.
Keyword to BorderStyle for every BorderStyle value, e.g. :thin, :medium-dashed.
(cell-style wb
{:keys [background-color foreground-color border-bottom border-left
border-right border-top wrap interop]
:as options})Creates a new CellStyle in the workbook.
:font can be a font options map (see font) or a Font instance
created in the same workbook.
:interop is an optional function called with the CellStyle, to set properties Loiste doesn't support directly.
Creates a new CellStyle in the workbook. :font can be a font options map (see `font`) or a Font instance created in the same workbook. :interop is an optional function called with the CellStyle, to set properties Loiste doesn't support directly.
(column-width num-chars)(column-width num-chars padding)Column width is given in 1/256ths of character width.
Column width is given in 1/256ths of character width.
Keyword to FillPatternType for every FillPatternType value, e.g. :solid-foreground, :fine-dots. :solid is an alias for :solid-foreground.
Keyword to FillPatternType for every FillPatternType value, e.g. :solid-foreground, :fine-dots. :solid is an alias for :solid-foreground.
(font wb {:keys [color name bold interop]})Creates a new Font in the workbook.
:interop is an optional function called with the Font, to set properties Loiste doesn't support directly.
Creates a new Font in the workbook. :interop is an optional function called with the Font, to set properties Loiste doesn't support directly.
(read-sheet sheet)(read-sheet sheet {:keys [column-name-fn] :or {column-name-fn keyword}})Create map key names based on the column labels on the first row.
Create map key names based on the column labels on the first row.
(sheet wb)(sheet wb sheet-name-or-index)Returns sheet with given name or index, or creates new sheet with given name if one doesn't exist.
Returns sheet with given name or index, or creates new sheet with given name if one doesn't exist.
(streaming-workbook)(streaming-workbook input)(streaming-workbook input
{:keys [row-access-window compress-tmp-files?
shared-strings-table?]
:or {row-access-window 100
compress-tmp-files? false
shared-strings-table? false}})Creates a new streaming workbook or opens existing workbook in streaming mode.
Input can be File, InputStream, URL or Workbook.
Creates a new streaming workbook or opens existing workbook in streaming mode. Input can be File, InputStream, URL or Workbook.
(-to-workbook this)Reads object to Workbook
Reads object to Workbook
(workbook)(workbook input)Creates a new workbook or opens existing workbook.
Input can be File, InputStream, URL or Workbook.
Creates a new workbook or opens existing workbook. Input can be File, InputStream, URL or Workbook.
(write-rows! wb sheet options rows)Writes rows to the sheet.
Options:
cell-style)
or CellStyle instance created in the same workbook.Rows are vectors of cell values, or maps with :values and optional :height and :interop. Cell values can be maps with :value and optional :style and :interop.
Row and cell :interop functions are called with the Row or Cell, after the values have been written, and the options map, which contains :workbook, :sheet and the created :styles. Their return value is ignored.
Note: streaming workbooks write strings inline by default, which drops rich text formatting. To write rich text in :interop functions with a streaming workbook, create it with :shared-strings-table? true.
Workbook level objects, e.g. Fonts or CellStyles, shouldn't be created in :interop functions, as they would be created for each cell. Create them before calling write-rows! and close over them, or use named :styles.
Writes rows to the sheet.
Options:
- :styles map of style name to style options (see `cell-style`)
or CellStyle instance created in the same workbook.
- :columns vector of column options, :width and :style.
Rows are vectors of cell values, or maps with :values and optional
:height and :interop. Cell values can be maps with :value and optional
:style and :interop.
Row and cell :interop functions are called with the Row or Cell, after the
values have been written, and the options map, which contains :workbook,
:sheet and the created :styles. Their return value is ignored.
Note: streaming workbooks write strings inline by default, which drops
rich text formatting. To write rich text in :interop functions with a
streaming workbook, create it with :shared-strings-table? true.
Workbook level objects, e.g. Fonts or CellStyles, shouldn't be created in
:interop functions, as they would be created for each cell. Create them
before calling write-rows! and close over them, or use named :styles.cljdoc builds & hosts documentation for Clojure/Script libraries
| Ctrl+k | Jump to recent docs |
| ← | Move to previous article |
| → | Move to next article |
| Ctrl+/ | Jump to the search field |