export data in excel format

[lucafr]

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

[rski]

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.

[lucafr]

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!

[foneman]

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 SpreadsheetWrit er module in Pear.