Jump to content
Sign in to follow this  
muhmuuh

Google spreadsheets

Recommended Posts

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 :P 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 :mellow:

Thank you in advance and I apologize for my English


I ran. I ran until my muscles burned and my veins pumped battery acid. Then I ran some more.

Share this post


Link to post
Share on other sites
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 by BitByteBit

Share this post


Link to post
Share on other sites
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.


010101000110100001101001011100110010000001101001011100110010000

001101101011110010010000001110011011010010110011100100001

My Android cat and mouse game
https://play.google.com/store/apps/details?id=com.KaosVisions.WhiskersNSqueek

We're gonna need another Timmy!

Share this post


Link to post
Share on other sites
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 :mellow: I want to edit the document directly, because uploading a file looks much harder.

I ran. I ran until my muscles burned and my veins pumped battery acid. Then I ran some more.

Share this post


Link to post
Share on other sites
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.


010101000110100001101001011100110010000001101001011100110010000

001101101011110010010000001110011011010010110011100100001

My Android cat and mouse game
https://play.google.com/store/apps/details?id=com.KaosVisions.WhiskersNSqueek

We're gonna need another Timmy!

Share this post


Link to post
Share on other sites
suhungmung

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.