On Tue, 11 Mar 2008 01:56:02 -0700 (PDT), Nosferatum wrote:
> When I export a MySQL table as CVS (with PHP) in order to create an

csv. CVS is a versioning system, or a pharmacy.

> Excel-document, all data outout are comma separated. The excel-file
> have all values separated with commas on one row each.
> Is it possible to make all the data appear ordered in coloumns on an
> Excel file, just as it is viwed in MySQL? Even better: With a styled
> Excel-sheet?

Write it in order, and it'll show up in the sheet in order.

Styled formatting of data in the rows will require a lot more work, and
you may want to look at perl's Spreadsheet::WriteExcel package. But
that's about as far as this should be taken here, as it's got 100%
nothing to do with MySQL.

--
I picked up a Magic 8-Ball the other day and it said 'Outlook not so good.'
I said 'Sure, but Microsoft still ships it.'
-- Anonymous