View Single Post

   
  #4 (permalink)  
Old 03-17-2008, 06:13 AM
Richard
 
Posts: n/a
Default Re: Formatting MySQL-output to XLS


"Nosferatum" <John.Olav.O@gmail.com> wrote in message
news:364ba34f-0713-4385-b442-6ac12cb8157d@q78g2000hsh.googlegroups.com...
> When I export a MySQL table as CVS (with PHP) in order to create an
> 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?


CSV means comma separated values.
It is exactly what you asked for.

You should create an import specification in Excell for your files.


Richard.


Reply With Quote