I believe there are libraries for doing that, but the best way to do it is
to output the data as a csv file. PHP has a function
fputcsv<http://php.net/manual/en/function.fputcsv.php>,
which outputs an array as a csv file, which excel can read.
On Wednesday, September 12, 2012 12:12:21 AM UTC-4, Diana Flores wrote:
>
> Asgallant, do you know a way to import the data from mysql to an excel. Im
> using:
>
> header('Content-type: application/vnd.ms-excel');
> header("Content-Disposition: attachment; filename=registrores.xls");
> header("Pragma: no-cache");
> header("Expires: 0");
>
> etc etc etc...
>
> but it alway pop ups a warning, but it shows me all the data. I dont have
> problem with this, but it seems its not the better way but the easiest.
> Have you ever used a lib?PHPExcel?
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/zaSo8QqPkpMJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
