Skip to content

The SVG library lets you save diagrams in SVG format. This allows you to export graphs in a more compact and clear format.

Notifications You must be signed in to change notification settings

Excel-lent/SVG-library-for-VBA

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 

Repository files navigation

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. ExportSvg ribbon with a single button
  • 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

  1. Smaller size of the picture, all benefits of vector graphics (sharp, scallable images):
JPG (39 kB) SVG (7 kB)
  1. 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:

  1. Smaller commit size.

Useful references

Creating An Add-in From An Excel Macro

About

The SVG library lets you save diagrams in SVG format. This allows you to export graphs in a more compact and clear format.

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages