Check the csvArray to make sure it is being parsed correctly. If your numbers are being parsed as strings, then there is either a problem in your csv file or there is a problem in the toArrays method (more likely the former than the latter, as I've seen the latter work).
If there isn't anything wrong with the csv file (or you can't fix it if there is), then you can force data type conversion by manually parsing the array and reassigning the strings to numbers using the parseInt and/or parseFloat functions. If you're still having trouble with it, post a sample csv that replicates the problem (preferably something small) and I'll take a look. On Tuesday, October 23, 2012 8:52:15 AM UTC-4, Kevin Regan wrote: > > Hi, I managed to get this working using a script which reads the a csv > string. I use an ajax call to return the csv string and pass te string to a > javascript function (called csv.toArrays) which 'loads' the csv data into a > 2 dimensional array which can then be passed to arrayToDataTable to create > a google vis data table. > > It works,as in I can then draw a table. > > However, the issue which arises is that, by using arrayToDataTable, the data > types of each column are interpreted automatically from the data given. It > appears the number types are wrongly being interpreted as strings. > Therefore I can not draw graphs. When I try I receive the error "Data > column(s) for axis #0 cannot be of type string". Is there any way to force > the data type to be the correct type? Thanks. > > > *the script to convert a csv string into a 2D array is here:* > http://code.google.com/p/jquery-csv/ > > *my code to read the csv file is below.* > > <script type="text/javascript" src="https://www.google.com/jsapi > "></script> > <script type="text/javascript" src="jquery-1.6.2.min.js"></script> > <script type="text/javascript" src=" > http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js";></script> > <script type="text/javascript" > src="https:/whereeveryousaveitlocally/jquery.csv-0.64.js"></script> > <script type="text/javascript"> > > // Load the Visualization API and the piechart package. > google.load('visualization', '1', {packages:['table']}); > google.load("visualization", "1", {packages:["corechart"]}); > > // Set a callback to run when the Google Visualization API is loaded. > google.setOnLoadCallback(drawChart); > > > function drawChart() { > > //looad and prepare data > var csvString = $.ajax({ > url: "https://....file.csv";, > dataType:"text", > async: false > }).responseText; > > var csvArray = $.csv.toArrays(csvString) > > // Create our data table out of csv file data loaded > var data = new google.visualization.arrayToDataTable(csvArray); > > var table = new > google.visualization.Table(document.getElementById('table_div')); > table.draw(data, {showRowNumber: true}); } > > > cheers > K > > On Friday, 19 October 2012 19:02:42 UTC+2, asgallant wrote: >> >> Parsing Excel files manually is a painful process. I'm given to >> understand that there is an Office service that ties into ASP.net which can >> handle the hard part of parsing the Excel file, but I don't know what it is >> or how it works. The simple thing to do is to save the file as a csv, >> which makes it easy to read. >> >> What scripting language do you plan to use server-side? >> >> On Friday, October 19, 2012 10:01:44 AM UTC-4, Kevin Regan wrote: >>> >>> Hi, >>> >>> I'm having trouble understanding how to generate json files to use in >>> Google charts. >>> >>> Basically, I have excel files which I want to convert to json on a >>> monthly basis in order to display the data in Google charts. >>> >>> I would like to automate this process. I guess I need to have something >>> parse the excel file according to some defined structure and generate the >>> json file. Can someone help me understand how this could work? >>> >>> thanks, >>> K >>> >>> >>> >>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/0NJVNOP9F04J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
