Macros/Calc/017

Tutorial on using LibreOffice charting capabilities with data stored in a SQL database.

The following macro was developed in order to use LibreOffice charting capabilities with data stored in a SQL database.

How to use it
After downloading the Populate-spreadsheet-from-db.ods LibreOffice file:


 * 1) Open the document and enter the information to connect to your SQL database
 * 2) Press the Load data button
 * 3) If the data was successfully imported, press Create chart

NOTE: The macros connect to a database and will do nothing if that database is not available. So you can not expect it to just work from downloading the file alone.

How it works
The macro connects to a SQL database and populates the spreadsheet. This data is then used to produce a chart.

Macros