dcwebcat

Importing Data From Excel Into Xml Document

Recommended Posts

Hello -

 

Is it possible to have the data import from Excel into the XML file for an Area 2D chart? We have a chart that has hundreds of data points and to manually enter them all would be very time consuming. Any guidance is appreciated!!!

 

Thanks! :D

Share this post


Link to post
Share on other sites
Guest Sashibhusan

Hi,

 

Yes, if you have your data stored in Microsoft Excel or other spreadsheets, you can easily generate your XML file using FusionCharts visual XML Generator.

 

Only you need to copy the Excel data and paste in the "FusionCharts XT XML Generator Utility", which will convert the excel data to XML (as per FusionCharts data format) and then you can use that XML to render your charts.

 

For more information on "Plotting Charts from data contained in MS Excel or other spreadsheets", please follow the link below:

http://docs.fusioncharts.com/charts/contents/?guide-for-general-users/external-data-sources/GUI_Excel.html

 

You can find the "FusionCharts XT XML Generator Utility" form Download Pack > Tools > XMLGenerator > XMLGen > XMLGen.html

 

Please note that FusionCharts does not have the feature of automatically take the Excel data, convert to XML and render the chart, as of now.

 

Hope this helps !

Share this post


Link to post
Share on other sites
Guest Sashibhusan

Hi,

 

As I have mentioned, you can find the xmlgenerator SWF file along with all the JavaScript and HTML files, in the FusionCharts XT Download Pack > Tools > FlashXMLBuilder > XMLGen folder, which is same for both Evaluation as well as licensed version.

 

Please note that there is no feature limitation in the Evaluation version of FusionCharts XT, except for the fact that the evaluation version charts are watermarked.

 

So, only you can do the enhancement in the "SWFObject.js" file, if you are willing to do.

 

Hope this helps!

Share this post


Link to post
Share on other sites

I have looked in the "SWFObject.js" file.  Can you tell me where it does the conversion from pasting in excel text to converting to xml in that file?? I do not see it.

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