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

anchors-by-id clj

(anchors-by-id sheet)

Gets a map of anchor objects by ID that show where the graphic with that ID is on the sheet

change-sheet clj

(change-sheet sheet old-index new-index)

Update any reference in the charts on this sheet that points to the base sheet to point to this sheet

chart-change-sheet clj

(chart-change-sheet sheet old-index new-index chart-xml)

Handle a single chart that was duplicated from an old sheet to a new sheet

chart-formulas clj

(chart-formulas sheet)

Get all the formulas in each chart on the sheet

chart-removal-rules clj

(chart-removal-rules chart-data)

Combine all the rules to remove charts from this workbook

chart-sheet? clj

(chart-sheet? sheet)

Return true if this sheet is a chart sheet

chart-sheets clj

(chart-sheets chart-data)

filter the chart data for charts from chart sheets only

chart-transform clj

(chart-transform sheet translation-table chart-xml)

Transform the formulas in the XML representation of a chart

drawing-rel clj

(drawing-rel link)

Change a chart reference to be relative to the drawing object

emit-xml clj

(emit-xml loc)

Generate an XML string from a zipper using clojure.xml

escape-strings clj

(escape-strings tree)

Escape any illegal XML strings

expand-all-series clj

(expand-all-series sheet src-sheet dst-sheets chart-xml)

Replicate the various series

expand-chart-data clj

(expand-chart-data workbook src-sheet dst-sheets chart-data)

Expand the xml charts that we've captured if they have references to sheets that are being cloned

expand-charts clj

(expand-charts sheet src-sheet dst-sheets)

Replace any series in charts on the sheet that reference src-sheet with multiple series each referencing a single element of dst-sheets

expand-series clj

(expand-series sheet src-sheet dst-sheets series-loc)

Expand a single series into 0 or more destination series leaving the cursor such that zip/next will return the same result as when called.

expand-xml-str clj

(expand-xml-str sheet src-sheet dst-sheets xml-str)

Replace any series in a chart that references a sheet that's being cloned to point to all the clones.

formula? clj

(formula? loc)

Return true if the node at the loc is a formula

get-anchor-location clj

(get-anchor-location anchor)

Get the location info from an anchor so we can create a new one later

get-chart-data clj

(get-chart-data sheet)

Get all the data the we need to delete and then recreate the charts for this sheet

get-charts clj

(get-charts sheet)

Get the charts from a worksheet

get-charts-and-anchors clj

(get-charts-and-anchors sheet)

Get maps representing each chart on the sheet along with its anchor

get-part-id clj

(get-part-id sheet part)

Get the part id for a document part in the drawing patriarch

get-xml clj

(get-xml chart)

Get the XML representation of a chart

has-chart? clj

(has-chart? sheet)

Return true if the sheet has any charts on it

mjuxt clj macro

(mjuxt & methods)

Like juxt, but for Java methods

new-anchor clj

(new-anchor sheet old-anchor)

Get an anchor for a duplicated chart based on an anchor pulled from the original

parse-xml clj

(parse-xml xml-string)

Parse the XML string using clojure.xml and return a zipper

part-path clj

(part-path part)

Get the path to this part for this object in the zip file

px clj

(px x)

Put this in the middle of a thread op to print the current state and keep threading the operand

reindex-series clj

(reindex-series key values chart-xml)

After modifying a chart, make sure that the indices and order of the series is correct

relocate-formula clj

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

Relocate a single chart formula from old-sheet to new-sheet

relocate-xml clj

(relocate-xml sheet old-index new-index loc)

Find the formulas in the XML that refer to the sheet at old-index and make them point to the sheet at new-index

rels-path clj

(rels-path part)

Get the path to the relationship definitions for this object in the zip file

remove-anchors clj

(remove-anchors chart-data)

Returns a map of drawing sheets to functions that will move the anchors corresponding to the charts

remove-charts clj

(remove-charts chart-data)

Returns a map of chart names to a map with :delete set to true. This will cause the chart objects to be dropped.

remove-drawing-rels clj

(remove-drawing-rels chart-data)

Returns a map of relationship sheets to a function that will remove the correct relationships on each one

renumber-chart-sheets clj

(renumber-chart-sheets chart-data)

Returns a map with instructions about how to renumber the charts on chart sheets so that they a 1..n with no holes so that POI can re-add the charts on worksheets correctly.

series? clj

(series? loc)

Return true if the node at the loc is a series

set-xml clj

(set-xml chart xml-str)

Set new XML for the chart

transform-charts clj

(transform-charts sheet translation-table)

Transform the charts in a sheet according to the translation table

transform-formula clj

(transform-formula sheet translation-table formula)

Transform a single chart formula according to the translation table

transform-xml clj

(transform-xml sheet translation-table loc)

Transform the zipper representing the chart into a zipper with expansions

tree-edit clj

(tree-edit zipper matcher editor & colls)

Take a zipper, a function that matches a pattern in the tree, and a function that edits the current location in the tree. Examine the tree nodes in depth-first order, determine whether the matcher matches, and if so apply the editor. Optional colls are used as in clojure.core/map with one element of each coll passed as an argument to editor in sequence. These will be nil padded if necessary if the number of matches is longer that the length of the collection.

tree-loc-edit clj

(tree-loc-edit zipper matcher editor & colls)

The rawer version of tree edit, this operates on a loc rather than a node. As a result, it allows for non-local manipulation of the tree.

work-sheets clj

(work-sheets chart-data)

filter the chart data for charts from worksheets only