I solved this by parsing the number values stored as string to integers using parseInt and saving them to a 2d array. I then create the columns of the datatable one at a time, stating the data type for each.
Finally, I add the rows one at a time from the 2d array. Not the most efficient method, but it works. thanks! On Wednesday, 24 October 2012 09:17:47 UTC+2, Kevin Regan wrote: > > I'm using IE7. > > > > On Friday, 19 October 2012 16:01:44 UTC+2, 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/-/TqBAKvnOOycJ. 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.
