On 11 Mar, 15:28, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> On Tue, 11 Mar 2008 05:59:45 -0700 (PDT), Nosferatum wrote:
> > On 11 Mar, 13:41, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> >> 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.
>
> > Thanks, I'll give it a try. I'm not the one that must have excel,
> > believe me.
>
> FWIW, the perl thing is probably worth a long, hard look. It IS
> complicated, but the module does work better than (at least I) expected,
> and more than one person has parlayed that kind of skill into really
> good job security.
>
> --
> The consquences of any action will never be fully understood until after
> it's too late to do anything about it.
> -- Schwartz's Second Law- Skjul sitert tekst -
>
> - Vis sitert tekst -

I did it all in PHP and it works just as I wanted! Perfect export to
Excel!