SikuliX

copy individual excel cell and put it to a different program using Sikuli 1.1.0

Asked by rupayan nath

from xlrd import open_workbook
from xlutils.copy import copy
rb = open_workbook('C:\\Users\\rupayan.nath\\Desktop\\New Microsoft Excel Worksheet.xls', formatting_info=True, on_demand=True)
wb=copy(rb)
wb.get_sheet(0).write(0,1,'changed!')
wb.save(join('C:\\Users\\rupayan.nath\\Desktop\\output.xls'))
rb = open_workbook('C:\\Users\\rupayan.nath\\Desktop\\output.xls')

This my code to to copy an excel document and edit it by writing some data. But I want to copy individual cell data and paste it to a different program. I request for your help

Thanks

Question information

Language:
English Edit question
Status:
Answered
For:
SikuliX Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Karl (k-d) said : 		#1

If you use sikuli, you could use screenshots or regions to get to the cell you want, you could use the click and type commands to copy the cell contents, you could use the App class to open your other program, you could use screenshots and regions to get to where you want to put the data, and you could use the click and type commands to paste the data to the new app.

Your script can even leverage the strengths of xlrd plus all of the other capabilities of python/jython in conjunction with SIkuli commands.

Can you help with this problem?

Provide an answer of your own, or ask rupayan nath for more information if necessary.

To post a message you must log in.