Connecting Tech Pros Worldwide Help | Site Map

export data in excel format

Newbie
 
Join Date: Feb 2008
Posts: 2
#1: Feb 16 '08
is it possible to export data from a postgresql table to a excel format?
tnx a lot!
Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 292
#2: Feb 16 '08

re: export data in excel format


Quote:

Originally Posted by lucafr

is it possible to export data from a postgresql table to a excel format?
tnx a lot!

you mean .xls? if so it is impossible (if i am right :)) but you can export it to a text file and open it with excel, it will convert the file for you to excel format.
Newbie
 
Join Date: Feb 2008
Posts: 2
#3: Feb 17 '08

re: export data in excel format


Quote:

Originally Posted by rski

you mean .xls? if so it is impossible (if i am right :)) but you can export it to a text file and open it with excel, it will convert the file for you to excel format.

thank you for the precious information, i'll try!
Newbie
 
Join Date: Mar 2008
Posts: 15
#4: Mar 16 '08

re: export data in excel format


If it will export data as a CSV file, comma delimited that is, then Excel can convert it. I do it with a PHP script on a web server using the SpreadsheetWriter module in Pear.
Reply