Thread: export data to excel

Deal All -

akp geek wrote:
> Deal All -
>
>                I would like to know if there is any plug in available
> to export the result to excel from pgadmin. if I do that now, all the
> data gets exported as csv . Appreciate your help

configure excel to use the postgres database as an ODBC 'data source'
and query it directly from your spreadsheet.

> Deal All -
>                I would like to know if there is any plug in available to
> export the result to excel from pgadmin. if I do that now, all the data gets
> exported as csv . Appreciate your help
> Regards

....Why not just save to the CSV file to XLS from within Excel? XLS,
and to a lesser extent XLSX are baroque proprietary formats which
aren't particularly well supported by most opensource tools.
Openoffice.org does a fair job at it, but that's about it.

Regards,
Peter Geoghegan

csv can easily be swallowed by Excel as a data source.

I like the ODBC based query suggestion better.  I've configured Excel to accept user inputs via text input widgets and
passthem onto the query as params in the query predicate.  I found the "QueryEditor.xla" add-in very valuable in this
regardas it allows you to edit the sql query as text instead of their goofy and limited graphical editor which is often
notup to the task.  



-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of John R Pierce
Sent: Tuesday, May 25, 2010 2:33 PM
To: akp geek
Cc: pgsql-general
Subject: Re: [GENERAL] export data to excel

akp geek wrote:
> Deal All -
>
>                I would like to know if there is any plug in available
> to export the result to excel from pgadmin. if I do that now, all the
> data gets exported as csv . Appreciate your help

configure excel to use the postgres database as an ODBC 'data source'
and query it directly from your spreadsheet.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

There is also the Java POI classes (Poor Obfuscation Implementation)
for importing and exporting doc and docx, HSSF (Horrible SpreadSheet
Format) for exporting and importing xls and xlsx,
http://poi.apache.org/

There are also implementations for Outlook, Powerpoint and Visio.

Java can be integrated with PostgreSQL using the JDBC drivers:
http://jdbc.postgresql.org/

Hope this helps.

I tried this option, the error that I was getting can not use "crypt".  The  I have used the open office as Peter mentioned and that worked for me. I will try the other options mentioned also

akp geek wrote:
> On Tue, May 25, 2010 at 2:33 PM, John R Pierce <pierce@hogranch.com
> <mailto:pierce@hogranch.com>> wrote:
>
>     akp geek wrote:
>
>         Deal All -
>
>                       I would like to know if there is any plug in
>         available to export the result to excel from pgadmin. if I do
>         that now, all the data gets exported as csv . Appreciate your help
>
>
>     configure excel to use the postgres database as an ODBC 'data
>     source' and query it directly from your spreadsheet.
>
>
> I tried this option, the error that I was getting can not use "crypt".
>  The  I have used the open office as Peter mentioned and that worked
> for me. I will try the other options mentioned also
>


not sure what "crypt" has to do with anything here.   you would need a
postgres odbc or adodb or whatever driver that windows and excel can use
to access postgres directly.