JuanMa

Fusion Charts From A Xls File

Recommended Posts

Hello everybody,

 

we have an Excel file where people drop their information (for example: payments). We want to create a chart that automatically refresh its data from that Excel, instead of charging the data into an XML file everytime. Is that possible?

 

If not, could we programme the XML file so it automatically refreshes its data from that Excel?

 

Thanks all.

Share this post


Link to post
Share on other sites
Guest Sumedh

Hi JuanMa,

 

Apologies for the delayed response.

 

FusionCharts XT is a JavaScript charting library and ultimately it accepts data in XML/JSON formats.

 

Charts will not be rendered if you pass Excel data directly to the charts.

 

However, you can change Excel data and depending on the changes in the Excel file, you would need to generate chart XML/JSON each time. This can be done pragmatically, for this you would need to write your own logic.

Share this post


Link to post
Share on other sites

Thanks a lot for the answer

 

Isn't there an example of an excel file that creates XML code? I was expecting to use macros to save the hole XML code as a XML file. But it does not seem to work so well. Maybe you can give me some tips to find a solution.

 

Thanks again for your cooperation

Share this post


Link to post
Share on other sites
Guest Sashibhusan

Hi,

 

We do not have any sample implementation of the same.

 

However, you could use macros to create XML file from your excel data. But please note that the XML code should follow the FusionCharts data format.

 

For more information on "FusionCharts XT and XML > Overview", please follow the link below:

http://docs.fusioncharts.com/charts/contents/?DataFormats/XML/Overview.html

 

Also, please visit the link of "Converting Excel to XML using macros" mentioned below, and see if it is of any help.

http://am-blog.no-ip.org/BlogEngine/post/2010/05/17/Converting-Excel-to-XML-using-a-macro.aspx

 

Hope this helps!

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