Google spreadsheets

[muhmuuh]

Hello!

I'm on a quest of writing a program, and part of it should write some data into a google spreadsheet. And here is my problem - I can't find a way to do it Debugbar doesn't help me much because the whole spreadsheets looks like one control and it doesn't distinguish the cells. Also the source code of the page is totally confusing. Would you please help with that task?

I've been here long enough to know that nobody will write me a solution just like that, and that's why I'm just asking for some ideas, some instructions about what should I look, what should I try etc. because I have no idea where should I start. Just point me the direction

Thank you in advance and I apologize for my English

[BitByteBit]

What you could do would be to first get the position of the window, calculate the position of the top left cell, then click to highlight it.

From there you could send key presses to manipulate your data?

Pseudo code:

$Position = WinGetPos("Google")
MouseClick("Left",$Position[0] + 10,$Position[1] + 10,1,0)

Thats one idea.

Do you have to edit a document currently on your google account? Or could you edit a .xls locally then upload it?

Edited June 3, 2010 by BitByteBit

[kaotkbliss]

I have never seen google spreadsheet, but if you can have it open full screen, then you can use mouse co-ordinates for cursor position, sends and so forth.

[muhmuuh]

I have never seen google spreadsheet, but if you can have it open full screen, then you can use mouse co-ordinates for cursor position, sends and so forth.

That is an example of google spreadsheet - http://spreadsheets.google.com/ccc?key=0AtlqHLcet7IBdE4tVWpCVkNobjV5N09rUzVhWHllbWc&hl=bg

What you could do would be to first get the position of the window, calculate the position of the top left cell, then click to highlight it.

From there you could send key presses to manipulate your data?

Pseudo code:

$Position = WinGetPos("Google")
MouseClick("Left",$Position[0] + 10,$Position[1] + 10,1,0)

Thats one idea.

Do you have to edit a document currently on your google account? Or could you edit a .xls locally then upload it?

Thanks for the idea, but I wanted to write on the spreadsheet without using the mouse and the keyboard. That would be plan B I want to edit the document directly, because uploading a file looks much harder.

[kaotkbliss]

Some of the _IE functions might be useful. Check in the help file under User Defined Functions Reference, IE Management. I'm not sure if anyhting in there will help since it seems this page is mostly javascript.

[suhungmung]

I know this post is old,

Here is what I do to update google spreadsheet

1) Create a form

2) Fill the form using the elements of the IE page or even BETTER

Prepopulate the form using URL parameters

https://docs.google.com/support/bin/answer.py?hl=en&answer=160000

[suhungmung]

Also look at the best answer:

http://www.google.com/support/forum/p/Google%20Docs/thread?tid=541020dc61ae94c5&hl=en

Just create a IE object, give URL something like

https://spreadsheets.google.com/formResponse?formkey=dHNSSjMxSG1yZUVESlpyVE92aXBncVE6MQ&ifq&entry.1.single=A&entry.2.single=B&entry.3.single=C&entry.0.single=D&submit=Submit and navigate to that URL.