How to Import data from SQL query to Open office calc

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
pdehariya
Posts: 2
Joined: Thu May 21, 2009 7:32 am

How to Import data from SQL query to Open office calc

Post by pdehariya »

Hi,
I want to import data from sql query to open office calc and want to save that file in a specified path. Please help!.
-----------------
Last edited by pdehariya on Tue Dec 07, 2010 11:43 am, edited 2 times in total.
OOo 2.4.X on Ms Windows XP
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to Import data from SQL query to Open office calc

Post by Villeroy »

Are you aware that you normally don't need any code to import queries into office documents?
[Tutorial] Using registered data sources in Calc
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
pdehariya
Posts: 2
Joined: Thu May 21, 2009 7:32 am

Re: How to Import data from SQL query to Open office calc

Post by pdehariya »

Hi Villeroy,
Yes i know its not required any code to import data to openoffice. Without code also i can import the data but i wanted it to automate backoffice job. I want that the end user should just click a button and the report should be generated with data and should get saved in a particular path. Could you please help?
OOo 2.4.X on Ms Windows XP
Post Reply