excel-templates.formulas — com.madriska/excel-templates 0.3.3.1

*debug-prints* clj

Set to true to enable the trace prints that show how formulas are being translated

build-forward-table clj

(build-forward-table data-seq)

Build the translation table to from source to dest

build-reverse-table clj

(build-reverse-table xlate-seq)

Build the translation from destination back to source

build-translation-tables clj

(build-translation-tables data-map)

Build the translation tables for all the worksheets mentioned in the data map

debug-println clj

(debug-println & args)

Print the arguments if debug-prints is bound to true.

external-sheets clj

(external-sheets workbook sheet formula)

Find any references to external sheets in the formula (note: all referenced sheets need to actually exist).

map-values clj

(map-values f m)

Build a new map that has [k v] -> [k (f v)]. I don't know why clojure doesn't have this

parse clj

(parse workbook sheet-num formula-string)

Parse a formula into a PTG array

PtgExternalSheets clj protocol

Protocol to find any external sheet references in the formula and return them

external-sheets-ptg clj

(external-sheets-ptg ptg)

PtgRelocator clj protocol

Protocol to handle translating various PTG classes by modifying cell references appropriately

relocate-ptg clj

(relocate-ptg ptg old-index new-index)

PtgTranslator clj protocol

Protocol to handle translating various PTG classes by modifying cell references appropriately

translate-ptg clj

(translate-ptg ptg translation-table sheet target-cell)

relocate-formula clj

(relocate-formula workbook sheet old-index new-index formula)

Relocate any references to the sheet at old-index in the formula to refer to new-index

render clj

(render workbook ptgs)

Render a PTG array back to a formula string

sheet-number clj

(sheet-number sheet)

Find the sheet number of this sheet object within its workbook

src->dst clj

(src->dst translation-table
          worksheet
          [row col]
          [target-row target-col]
          max?
          abs?)

Translate a cell location from the source template to the target, accounting for cell motion and expansion. Returns a [row col] pair.

translate-formula clj

(translate-formula translation-table workbook sheet target-cell formula)

Translate a formula from the source sheet to the output workbook based on the translation table