If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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

Options

30-11-2011 7:49pm

#1

thecroghanlad

Registered Users 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

Options
#2 01-12-2011 9:55am
amen

Registered Users 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