SikuliX

How to Retrieve the Column number if we know the Column name in excel using Sikuli ?

Asked by kamal

 I need to retrieve the Column number, if we know the Column name of the Excel using Sikuli.. Is tat possible ???

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
scott f (sfeister) said : 		#1

First of all, what version of Excel are you using? (2003. 2007, 2010)?

Secondly, what do you mean by "Column number" and "Column name"? (By "Column name" do you mean column letter A, B, C, D...?)

If by Column name you do mean column "A", "B", "C", "D",... then try this solution from within Excel:
http://en.kioskea.net/faq/9718-excel-change-the-columns-index-from-letter-to-number

If you are looking for the cell identifier (e.g. "A9") of the currently selected cell, in Excel 2010 at least that is located in the upper left corner of the Excel window. If that information is needed, you could copy and paste that region using Sikuli.

Revision history for this message
RaiMan (raimund-hocke) said : 		#2

might be, that xlrd helps (faq 2208)

Can you help with this problem?

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

To post a message you must log in.