Excel Embedding into Google Charts

thecroghanlad · 2011-11-30 18:49:55

Hi folks Newby here - Quick question - I am trying to set up a chart via google charts that can reference an excel file - Can anybody pass me on the PHP syntax to access the Excel file ie - my file path is c:\desktop\test.xls Mods - If this is the incorrect location for this post please advise Thanks

30-11-2011 07:49PM

#1

thecroghanlad

Registered Users, Registered Users 2 Posts: 3 ✭

Join Date: November 2011

Posts: 1

Hi folks

Newby here - Quick question - I am trying to set up a chart via google charts that can reference an excel file - Can anybody pass me on the PHP syntax to access the Excel file

ie - my file path is

c:\desktop\test.xls

Mods - If this is the incorrect location for this post please advise

Thanks

0

Comments

#2 01-12-2011 09:55AM

amen

Registered Users, Registered Users 2 Posts: 2,781 ✭✭✭

Join Date: October 1999

Posts: 2598

Not a php head but I would imagine this is a little trickey. Excel stores files in MS Excel format so you will have to open the file, figure out the format, read the data and the pass to the chart.

Could you save the file Excel as csv format (comma seperated format) if so then I believe PHP can read csv files and it should be trivial to pass the data to google charts.

0