excel-clj.poi
Exposes a low level cell writer that uses Apache POI.
See the example and performance-test functions at the end of
this ns + the adjacent (comment ...) forms for more detail.
Exposes a low level cell writer that uses Apache POI. See the `example` and `performance-test` functions at the end of this ns + the adjacent (comment ...) forms for more detail.
appenderclj
(appender from-path to-path)(appender from-path to-path streaming?)Like writer, but allows overwriting individual sheets within a template
workbook.
Like `writer`, but allows overwriting individual sheets within a template workbook.
IWorkbookWritercljprotocol
dissoc-sheet!clj
(dissoc-sheet! this sheet-name)If there's a sheet with the given name, get rid of it.
If there's a sheet with the given name, get rid of it.
workbook*clj
(workbook* this)Get the underlying Apache POI Workbook object.
Get the underlying Apache POI Workbook object.
IWorksheetWritercljprotocol
newline!clj
(newline! this)Skip the writer to the next row in the worksheet.
Skip the writer to the next row in the worksheet.
sheet*clj
(sheet* this)Get the underlying Apache POI XSSFSheet object.
Get the underlying Apache POI XSSFSheet object.
write!clj
(write! this value)(write! this value style width height)Write a single cell.
If provided, style is a map shaped as described in excel-clj.style.
Width and height determine cell merging, e.g. a width of 2 describes a cell that is merged into the cell to the right.
Write a single cell. If provided, `style` is a map shaped as described in excel-clj.style. Width and height determine cell merging, e.g. a width of 2 describes a cell that is merged into the cell to the right.
performance-testclj
(performance-test to-file n-rows & {:keys [streaming?] :or {streaming? true}})Write n-rows of data to to-file and see how long it takes.
Write `n-rows` of data to `to-file` and see how long it takes.
sheet-writerclj
(sheet-writer workbook-writer sheet-name)Create a writer for an individual sheet within the workbook.
Create a writer for an individual sheet within the workbook.
stream-appenderclj
(stream-appender from-stream to-stream)(stream-appender from-stream to-stream streaming?)Like stream-writer, but allows overwriting individual sheets within a
template workbook.
Like `stream-writer`, but allows overwriting individual sheets within a template workbook.
stream-writerclj
(stream-writer stream)(stream-writer stream streaming?)Open a stream writer for Excel workbooks.
If streaming? is true (default), uses Apache POI streaming implementations.
N.B. The streaming version is an order of magnitude faster than the alternative, so override this default only if you have a good reason!
Open a stream writer for Excel workbooks. If `streaming?` is true (default), uses Apache POI streaming implementations. N.B. The streaming version is an order of magnitude faster than the alternative, so override this default only if you have a good reason!
writerclj
(writer path)(writer path streaming?)Open a writer for Excel workbooks.
See stream-writer for writing to your own streams (maybe you're writing
as a web server response, to S3, or otherwise over TCP).
If streaming? is true (default), uses Apache POI streaming implementations.
N.B. The streaming version is an order of magnitude faster than the alternative, so override this default only if you have a good reason!
Open a writer for Excel workbooks. See `stream-writer` for writing to your own streams (maybe you're writing as a web server response, to S3, or otherwise over TCP). If `streaming?` is true (default), uses Apache POI streaming implementations. N.B. The streaming version is an order of magnitude faster than the alternative, so override this default only if you have a good reason!
cljdoc is a website building & hosting documentation for Clojure/Script libraries
× close