[1.1.1] copy contents of excel cell to webpage --- use module xlrd and paste
I've watched the tutorials, but I noticed there is no obvious way to copy the text contents of an Excel cell to a web page.
In some ways this might actually end up being a recorded macro, as opposed to a programmed one, as I have well over 1000 separate records from excel to be entered into a web page one at a time.
There seems to be two issues here, the first being that it is not obvious to me how to copy existing text from the IDE console. Sure, I could use Ctrl-C as this is a Windows based program, but I was hoping that I could use something in Sikuli to facilitate this. Also, I was hoping I could use the graphic capture to choose and park text without having to switch windows fore and back between Excel and my browser during the execution of the macro.
The other thing I was hoping was if there was a way to go through an Excel spreadsheet with the macro, row by row, but it seems that I might be limited to duplicating the macro repeatedly to go down "sections" of rows at a time. The conditional repeat is very close to what I need, but it doesn't seem to have the ability to do more than one row at a time without writing the macro for every line. Correct me if I'm wrong, but the graphics are locked in location by X & Y coordinates, meaning I would have to write each row independently.
Lastly, I'm using the newest release, on your recommendation, and while experimenting with writing a macro, the IDE console disappeared after I selected an image. The java symbol (the coffee cup) disappeared, and although the command window was still up, access to the IDE console was no where to be seen. My guess is that it crashed but I was unable to restart the program because the command program was still running. I didn't locate it in the task manager (Windows 7) so the only choice I had was reboot to get the console back. It might be useful to add a "console only" restart.
Can you help with this problem?
Provide an answer of your own, or ask Rob Ward for more information if necessary.