SVG library for VBA
Excel is as inexhaustible as the atom, nature is infinite
Lenin, Materialism and Empirio-Criticism (1908).
This is a preleminary release of SVG library for VBA. Not everything is working properly. Not all properties are implemented. The aim of the library is to export charts in SVG format, i. e. in lossless image format. Pull requests are welcome!
Distribution
The library is distributed
- Add-in for Excel.
- Installer for add-in. "SVGlib.xlam" should be placed to the same directory as "SVGlib installer.xlsm". Simply follow instructions and install the add-in on your computer.
- Example of usage. After installation you will get a new ribbon with a single button. Use it to export all graphs shown on the page. The graphs will be saved in your working directory.
- Development table. To create add-in you have to save it as "xlam" file. Be careful, Excel tries to save it to add-in's directory! Use button "back" to return to the working directory.
Benefits
- Smaller size of the picture, all benefits of vector graphics (sharp, scallable images):
| JPG (39 kB) | SVG (7 kB) |
|---|---|
 |
 |
- The changes in the graphs can be tracked. For example, if the formula of
$$5^3$$ (cell "C6") was changed to$$5^3 + 1,$$ the difference in the graph will immediately show the changes:
- Smaller commit size.