(anchors-by-id sheet)
Gets a map of anchor objects by ID that show where the graphic with that ID is on the sheet
Gets a map of anchor objects by ID that show where the graphic with that ID is on the sheet
(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
Update any reference in the charts on this sheet that points to the base sheet to point to this sheet
(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
Handle a single chart that was duplicated from an old sheet to a new sheet
(chart-formulas sheet)
Get all the formulas in each chart on the sheet
Get all the formulas in each chart on the sheet
(chart-removal-rules chart-data)
Combine all the rules to remove charts from this workbook
Combine all the rules to remove charts from this workbook
(chart-sheet? sheet)
Return true if this sheet is a chart sheet
Return true if this sheet is a chart sheet
(chart-sheets chart-data)
filter the chart data for charts from chart sheets only
filter the chart data for charts from chart sheets only
(chart-transform sheet translation-table chart-xml)
Transform the formulas in the XML representation of a chart
Transform the formulas in the XML representation of a chart
(drawing-rel link)
Change a chart reference to be relative to the drawing object
Change a chart reference to be relative to the drawing object
(emit-xml loc)
Generate an XML string from a zipper using clojure.xml
Generate an XML string from a zipper using clojure.xml
(escape-strings tree)
Escape any illegal XML strings
Escape any illegal XML strings
(expand-all-series sheet src-sheet dst-sheets chart-xml)
Replicate the various series
Replicate the various series
(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 the xml charts that we've captured if they have references to sheets that are being cloned
(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
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 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 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 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.
Replace any series in a chart that references a sheet that's being cloned to point to all the clones.
(formula? loc)
Return true if the node at the loc is a formula
Return true if the node at the loc is a formula
(get-anchor-location anchor)
Get the location info from an anchor so we can create a new one later
Get the location info from an anchor so we can create a new one later
(get-chart-data sheet)
Get all the data the we need to delete and then recreate the charts for this sheet
Get all the data the we need to delete and then recreate the charts for this sheet
(get-charts sheet)
Get the charts from a worksheet
Get the charts from a worksheet
(get-charts-and-anchors sheet)
Get maps representing each chart on the sheet along with its anchor
Get maps representing each chart on the sheet along with its anchor
(get-part-id sheet part)
Get the part id for a document part in the drawing patriarch
Get the part id for a document part in the drawing patriarch
(get-xml chart)
Get the XML representation of a chart
Get the XML representation of a chart
(has-chart? sheet)
Return true if the sheet has any charts on it
Return true if the sheet has any charts on it
(mjuxt & methods)
Like juxt, but for Java methods
Like juxt, but for Java methods
(new-anchor sheet old-anchor)
Get an anchor for a duplicated chart based on an anchor pulled from the original
Get an anchor for a duplicated chart based on an anchor pulled from the original
(parse-xml xml-string)
Parse the XML string using clojure.xml and return a zipper
Parse the XML string using clojure.xml and return a zipper
(part-path part)
Get the path to this part for this object in the zip file
Get the path to this part for this object in the zip file
(px x)
Put this in the middle of a thread op to print the current state and keep threading the operand
Put this in the middle of a thread op to print the current state and keep threading the operand
(reindex-series key values chart-xml)
After modifying a chart, make sure that the indices and order of the series is correct
After modifying a chart, make sure that the indices and order of the series is correct
(relocate-formula sheet old-index new-index formula)
Relocate a single chart formula from old-sheet to new-sheet
Relocate a single chart formula from old-sheet to new-sheet
(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
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 part)
Get the path to the relationship definitions for this object in the zip file
Get the path to the relationship definitions for this object in the zip file
(remove-anchors chart-data)
Returns a map of drawing sheets to functions that will move the anchors corresponding to the charts
Returns a map of drawing sheets to functions that will move the anchors corresponding to the charts
(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.
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 chart-data)
Returns a map of relationship sheets to a function that will remove the correct relationships on each one
Returns a map of relationship sheets to a function that will remove the correct relationships on each one
(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.
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? loc)
Return true if the node at the loc is a series
Return true if the node at the loc is a series
(set-xml chart xml-str)
Set new XML for the chart
Set new XML for the chart
(transform-charts sheet translation-table)
Transform the charts in a sheet according to the translation table
Transform the charts in a sheet according to the translation table
(transform-formula sheet translation-table formula)
Transform a single chart formula according to the translation table
Transform a single chart formula according to the translation table
(transform-xml sheet translation-table loc)
Transform the zipper representing the chart into a zipper with expansions
Transform the zipper representing the chart into a zipper with expansions
(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.
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 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.
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 chart-data)
filter the chart data for charts from worksheets only
filter the chart data for charts from worksheets only
cljdoc is a website building & hosting documentation for Clojure/Script libraries
× close