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/-/yy7svA498mMJ. 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.
