Re: Using excel file on google visualisation

[asgallant]

If you have a Windows-based server, I believe there is a module for IIS that will allow ASP.net applications to read Excel files (I don't recall what it is called and don't know how it works, so you'll have to do the research there).  IMHO, reading from Excel files is not worth the effort to make it happen.  It is much easier to save the Excel file as a CSV and read that.

On Tuesday, January 15, 2013 6:10:28 AM UTC-5, ita...@adgorithms.com wrote:

I'm trying to build a google visualisation chart using excel file as my data source.

I don't want to use google spreadsheets in order to do so.

Is there any other way to read the excel file directly and create the chart from it?

Thanks

[asgallant]

There are a multitude of different ways to handle input from a CSV.  What is your server environment (Linux/Apache/PHP, Windows/IIS, Java)?

On Tuesday, January 15, 2013 4:18:13 PM UTC-5, ita...@adgorithms.com wrote:

Thanks,

CSV file is also an option.

Can someone tell how can I do it using google visualization(again without using google spreadsheet)?

[asgallant]

What server-side scripting language do you plan to use (PHP, ASP.net, Java, Python, other)?

On Wednesday, January 16, 2013 7:54:42 PM UTC-5, Itamar Yoniso wrote:

I'm working on Windows.

Thanks again

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

To post to this group, send email to google-visua...@googlegroups.com.
To unsubscribe from this group, send email to google-visualization-api+unsub...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

[asgallant]

You're definitely going to be using javascript client-side, but I just want to be clear here and make sure that's what you meant.  It *is* possible to use javascript for server-side scripting, but it's not common.

On Wednesday, January 16, 2013 8:34:40 PM UTC-5, Itamar Yoniso wrote:

Javascript

Thanks again

To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

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

[asgallant]

Ok.  By default, javascript doesn't support reading from files on the local machine.  If you use an HTML5-compatible browser (Chrome, FF, Safari, Opera, IE 9+), you can use the form input type "file" to get the CSV and then use something like jQuery.csv to parse the CSV into an array that you can use for the API.  I'll try to build a demonstration script for you.

On Thursday, January 17, 2013 8:16:40 AM UTC-5, Itamar Yoniso wrote:

Yeah sorry, I meant client side.

I'm not dealing yet with server side. for now my goal is very simple.

I have a csv file on my windows folder and i want to read it into a line chart using google visualization.

This works for me now by opening the csv file in google spreadsheet.

I want to do the reading directly through the csv file(without using google spreadsheet).

Thanks again

To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/KLXsAxaQgRoJ.