The spreadsheet includes more detailted information about the setup and limitations. These are the two documents I used for testing. A spreadsheet and a database document with a HSQLDB embedded.

Row #1 gets type declarations, row #2 gets column labels, further rows gets the actual data to substitute the positional parameters with.īelow this posting you find two more attachments. If the database requires login and the two named cells are missing, the login credentials will be promtped for.Ĥ) A sheet having a data range with one additional header row of type declarations above the header row of column labels. It contains Python code with a simple install routine.Ģ) A sheet cell named 'Reg_Name' specifying the registered name of a database or the file URL of the database document.ģ) A cell named 'SQL_Statement' with a (parameterized) statement to be executed.ģa) Optional: named cells 'User_Name' and 'User_Password'. INSERT, UPDATE or DELETE statements are supported.ġ) The Writer document attached to this posting. Running statements without parameter substitution is possible as well.

Write cell range data to a database table by substituting the positional parameters of an SQL statement with cell values. The example spreadsheet contains 3 example sheets with push buttons. The 'current region' is a range of non-blank cells surrounded by blank cells or sheet boundaries.Ĭall a macro any way you prefer. Select the cell range to export or click any single cell within the 'current region'.

Libreoffice calc python