将我的Google Chart（表格）数据导出到excel或csv [英] Export my Google Chart (table) data to excel or csv

问题描述

我有一个谷歌图表，我需要一个选项来导出数据到Excel或CSV。 API？我找到了一些带有代码的页面，但是这些数据来自Google文档，因为我的数据来自mySQL。我的表也有一些StringFilters，所以导出的数据应该只是过滤后留下的数据。

如果这不能通过API，那么最好的方法是什么做到这一点...我可以获得过滤的数据到任何其他格式，我可以使用？

任何帮助非常感谢
谢谢

解决方案

使用PHP上传到Google Spreadsheet（您可能希望使用ajax）或者选择服务器端语言，并将其转换为Excel

或

使用内置的工具栏功能：

https://developers.google.com/chart/interactive/ docs / gallery / toolbar

I have a google chart which is a table and I need to have an option to export the data to excel or csv.

Can this be done within google charts API? I found a few pages with code but that was with the data coming from google docs where as my data is coming from mySQL. My table also has some StringFilters so the exported data should only be the data left after filtering.

If this can't be dont via the API what would be the best way to do this... Can I get the filtered data into any other format that I can use?

Any help is much appreciated Thanks

解决方案

Upload to a Google Spreadsheet using PHP (you may want to use ajax for this) or server side language of your choice and convert to Excel from there.

OR

Use the built in toolbar functionality:

https://developers.google.com/chart/interactive/docs/gallery/toolbar

这篇关于将我的Google Chart（表格）数据导出到excel或csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！