Recommended Posts

How to generate interactive graphs daily,weekly,monthly,yearly on it which pull their data from excel files from other website which get updated with time.

Share this post


Link to post
Share on other sites
Guest Sashibhusan

Hi,

 

FusionCharts does not have any native API to read data from excel files and update the new data in Real-Time graph automatically.

 

However, you could write your own code (in any server-side scripting language) to read the data from excel file and then check the condition, whether any new data is getting updated in the file > if yes, update the data in data provider page, which will update the data in Real-Time graphs.

 

If I will consider PHP as server-side scripting language, please find one sample attached here, which will read the data from the excel file and update the Real-Time Line chart in 2 seconds interval, for your reference.

 

Hope this helps!

 

RealTime_Chart_from_EXCEL.zip

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now