(column-letter->number col-str)Convert column letter(s) to a 1-based numeric index. A=1, B=2, ..., Z=26, AA=27, etc.
Convert column letter(s) to a 1-based numeric index. A=1, B=2, ..., Z=26, AA=27, etc.
(crange s e)Creates as sequence of columns given a starting and ending column name.
Creates as sequence of columns given a starting and ending column name.
(create-xlsx file-path data)Create an Excel spreadsheet file-path : Destination folder and filename. e.g /test/sample.xlsx will create the folder test if it does not exist and place the newly created sample.xlsx in that folder data : Data should be vector of maps or vector of vectors where each map or vector represents a row
Create an Excel spreadsheet
file-path : Destination folder and filename. e.g /test/sample.xlsx will create the folder test
if it does not exist and place the newly created sample.xlsx in that folder
data : Data should be vector of maps or vector of vectors where each map or vector represents a row(create-zip-entry zip-stream entry-name content)For a given filepath and content add to a java ZipOuputStream
For a given filepath and content add to a java ZipOuputStream
Default values for processing the Excel Spreadsheet :row integer :- Which row to begin data extraction defaults to 0 :fxn function :- Which function to use parse header rows :rows integer :- Number of rows to extract :hdr boolean :- Rename columns with data from the first row
Default values for processing the Excel Spreadsheet :row integer :- Which row to begin data extraction defaults to 0 :fxn function :- Which function to use parse header rows :rows integer :- Number of rows to extract :hdr boolean :- Rename columns with data from the first row
(excel-date-serial datetime)Convert a java LocalDate to an MS Excel integer value
Convert a java LocalDate to an MS Excel integer value
(excel-time-serial datetime)Convert a java LocalDateTime to an MS Excel decimal value.
Convert a java LocalDateTime to an MS Excel decimal value.
(extract-cell-value shared-strings styles cell)Possible cell-value types well explained here https://stackoverflow.com/a/18346273
Possible cell-value types well explained here https://stackoverflow.com/a/18346273
(find-sheet-by-name-or-index sheets sheetname-or-idx)Find a sheet by name (case-insensitive) or by positional index (1-based). When using an integer index, it refers to the position in the sheets list, not the internal sheetId.
Find a sheet by name (case-insensitive) or by positional index (1-based). When using an integer index, it refers to the position in the sheets list, not the internal sheetId.
(get-cells sheet rows cols)Get range of values returned as list of rows
Get range of values returned as list of rows
(get-col sheet col)Get column from sheet by name. If columns have been renamed use the new name.
Get column from sheet by name. If columns have been renamed use the new name.
(get-col-index cell last-processed-col-number)Returns a vector of [col-letter col-number] where col-number is the 1-based numeric index. Self-calculated index is used only if cell-index attribute(:r) is missing on the cell
Returns a vector of [col-letter col-number] where col-number is the 1-based numeric index. Self-calculated index is used only if cell-index attribute(:r) is missing on the cell
(get-range sheet rg)Get range of values using Excel cell coordinates e.g A1:C5
Get range of values using Excel cell coordinates e.g A1:C5
(get-row sheet row)Get row from sheet by row index
Get row from sheet by row index
(get-shared-strings zipfile)Get dictionary of all unique strings in the Excel spreadsheet
Get dictionary of all unique strings in the Excel spreadsheet
(get-sheet file-or-filename)(get-sheet file-or-filename sheetname-or-idx)(get-sheet file-or-filename sheetname-or-idx options)Get sheet from file or filename
Get sheet from file or filename
(get-sheet-entry zipfile rels rid)Get the ZipEntry for a worksheet using the relationship ID. The rels map provides the mapping from rId to the actual worksheet path.
Get the ZipEntry for a worksheet using the relationship ID. The rels map provides the mapping from rId to the actual worksheet path.
(get-sheet-names file-or-filename)Retrieves a list of Sheet Names from a given Excel Spreadsheet. Returns a vector of maps with :name and :idx keys.
Retrieves a list of Sheet Names from a given Excel Spreadsheet. Returns a vector of maps with :name and :idx keys.
(get-sheets file-or-filename)(get-sheets file-or-filename options)Get all or specified sheet from the excel spreadsheet
Get all or specified sheet from the excel spreadsheet
(get-workbook-relationships zipfile)Get the relationship mappings from xl/_rels/workbook.xml.rels. Returns a map from rId to the Target path (e.g. {"rId1" "worksheets/sheet1.xml"}).
Get the relationship mappings from xl/_rels/workbook.xml.rels.
Returns a map from rId to the Target path (e.g. {"rId1" "worksheets/sheet1.xml"}).(parse-range s)Takes in an Excel coordinate and returns a hashmap of rows and columns to pull
Takes in an Excel coordinate and returns a hashmap of rows and columns to pull
(parse-xlong x)Adds support for passing in nil into parse-long Return an empty string if x is nil
Adds support for passing in nil into parse-long Return an empty string if x is nil
(process-row shared-strings styles row)Process Excel row of data
Process Excel row of data
(style-check cell-attrs styles ids)Check if the style id is within a range.
Check if the style id is within a range.
(to-col num)Takes in an ordinal and returns its equivalent column heading.
Takes in an ordinal and returns its equivalent column heading.
(when-num s)Returns nil for empty strings when a number is expected
Returns nil for empty strings when a number is expected
(when-str s)Returns nil for empty strings
Returns nil for empty strings
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 |