Great, thanks.
Here is what i got for now(reading data from google spreadsheet):
var query = new google.visualization.Query(
'
https://docs.google.com/a/adgorithms.com/spreadsheet/tq?tqx=out:json&range=A1%3AQ3007&key=0AsbutEBEzwjAdGpGUkIzN2xFb3pvcmlRVkZiYVRESEE&gid=0&headers=-1'
);
// Send the query with a callback function.
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
//Full data table
var data = response.getDataTable();
//do things with data....
visualization = new
google.visualization.LineChart(document.getElementById('visualization'));
visualization.draw(data,null);
On Thu, Jan 17, 2013 at 7:23 PM, asgallant <[email protected]>wrote:
> 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 <http://code.google.com/p/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
>>
>> On Thu, Jan 17, 2013 at 4:57 AM, asgallant <[email protected]>wrote:
>>
>>> 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
>>>>
>>>>
>>>> On Thu, Jan 17, 2013 at 3:15 AM, asgallant <[email protected]>wrote:
>>>>
>>>>> 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
>>>>>>
>>>>>> On Wed, Jan 16, 2013 at 12:52 AM, asgallant
>>>>>> <[email protected]>wrote:
>>>>>>
>>>>>>> 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,
>>>>>>> [email protected]:
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>> CSV file is also an option.
>>>>>>>> Can someone tell how can I do it using google visualization(again
>>>>>>>> without using google spreadsheet)?
>>>>>>>>
>>>>>>>> On Tuesday, January 15, 2013 6:43:11 PM UTC+2, asgallant wrote:
>>>>>>>>>
>>>>>>>>> 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,
>>>>>>>>> [email protected] 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
>>>>>>>>>>
>>>>>>>>> --
>>>>>>> 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/**ms****g/google-visualization-api/-**/*
>>>>>>> *7**FwclhUMXdEJ<https://groups.google.com/d/msg/google-visualization-api/-/7FwclhUMXdEJ>
>>>>>>> .
>>>>>>>
>>>>>>> To post to this group, send email to google-visua...@**googlegroups.
>>>>>>> **c**om.
>>>>>>>
>>>>>>> To unsubscribe from this group, send email to
>>>>>>> google-visualization-api+**unsub****[email protected].
>>>>>>> For more options, visit this group at http://groups.google.com/**
>>>>>>> group****/google-visualization-**api?hl=**e**n<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/*
>>>>> *ms**g/google-visualization-api/-**/**KI9vbuUol5EJ<https://groups.google.com/d/msg/google-visualization-api/-/KI9vbuUol5EJ>
>>>>> .
>>>>>
>>>>> To post to this group, send email to google-visua...@**googlegroups.**
>>>>> com.
>>>>> To unsubscribe from this group, send email to
>>>>> google-visualization-api+**unsub**[email protected].
>>>>> For more options, visit this group at http://groups.google.com/**group
>>>>> **/google-visualization-**api?hl=**en<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/-**/KLXsAxaQgRoJ<https://groups.google.com/d/msg/google-visualization-api/-/KLXsAxaQgRoJ>
>>> .
>>>
>>> To post to this group, send email to google-visua...@**googlegroups.com.
>>> To unsubscribe from this group, send email to google-visualization-api+*
>>> *[email protected].
>>> For more options, visit this group at http://groups.google.com/**
>>> group/google-visualization-**api?hl=en<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/-/Qw1VhAPue3gJ.
>
> 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.
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
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.
