If you want to read data live from your Excel sheet, you need server-side code that is capable of reading Excel. I am given to understand that there are some tools from Microsoft that can hook in to ASP.net and read Excel files, but I don't know where you can get them. Reading Excel files in other scripting languages is difficult at best. As an alternative, if your needs permit it, you can import the Excel file into Google Spreadsheets and query the data from there.
If you don't need to read the data live, then you can export the data to your javascript and format it for input into the DataTable. On Friday, August 2, 2013 9:29:25 AM UTC-4, kpj wrote: > > Hello, > > I have data in my excel sheet. > I have written a VBA function which converts my data in to array format( > which looks exactly like the data in google charts examples) > But, I dont know how to Read my array into > var data = google.visualization.arrayToDataTable( > I got my data array written into another file which has a function > FillSourceArray() > and i am calling that function into the VBA function using DataArray = > FillSourceArray() > I am not sure about how to read the data. > > Thanks in advance > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
