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/-/47VpUStljoUJ. 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.
