On Mar 12, 2:23 pm, Nosferatum <John.Ola...@gmail.com> wrote:
> 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!

Care to share how do you it with PHP ?