excel - Python - Do Logical Comparisons with Different Text Encodings Make a Difference? -

-

i trying automate task of copying data excel application based on "tagname" column exists in both. i'm having python copy "tagname" , save variable each ("metertag" , "exceltag"). i've thrown tkmessagebox right before compare confirm values same (and are), if statement not being executed, else is. question is: python treat excel formatted text differently other copied texts? (how fix that?) otherwise else problem?

click(573,745) time.sleep(.3) click_hold(625,357) win32api.setcursorpos((571,357)) click_release(571,357) ctcopy() time.sleep(.3)  click(1116,264)  win32clipboard.openclipboard() metertag = win32clipboard.getclipboarddata() win32clipboard.closeclipboard()  time.sleep(.1) click(2295, 252) #top of tags excel  time.sleep(1) click(2295, 252) #top of tags excel time.sleep(1)  x in range (0,499): ctcopy() win32clipboard.openclipboard() exceltag = win32clipboard.getclipboarddata() win32clipboard.closeclipboard() time.sleep(.02)  metertag = str(metertag)     exceltag = str(exceltag) ts(metertag,exceltag)  if metertag == exceltag:   #<-- not true when know is!!?     time.sleep(.25)     press('left_arrow')     time.sleep(.25)     press('left_arrow')     ctcopy()     click(1005,747) #"enter reading" button updating reading     time.sleep(.75)     click(771,580)  #text box reading update     time.sleep(.05)     ctpaste()     time.sleep(.05)     time.sleep(.05)     click(913,580)  #"update now" button     #need case when pop-up occurs     break else:     press('down_arrow')

i have answer!! whatever reason, copying excel using clipboard above adds "\n" - looked @ length of each - 1 8, other 10. did concatonation dummy letter each discover putting in new line!


Comments

Post a Comment

Popular posts from this blog

javascript - how to protect a flash video from refresh？ -

-
<!doctype html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>flash video refresh</title> </head> <body> <div id="playerzone"><embed height="496" width="580" flashvars="flvid=19742822&amp;createtime=2012-4-19 13:46:33" wmode="opaque" allowscriptaccess="always" allowfullscreen="true" quality="high" bgcolor="#000000" name="player" id="player" src="swf/mine.swf" type="application/x-shockwave-flash"></div> <a onclick="return test();" id="test">click me popup div,and hide scrollbar</a> </body> the code upon： for example,when click a#test button,popup div,it's no problem,but want hide scrollbar while div popup. i used $('html').css('overflow','hidden') in
Read more

android - Associate same looper with different threads -

-
Image
in application, want create multiple threads working on single queue. create queue know need call looper.prepare() . i want other threads create should associated looper created first thread, how can achieve this? use 1 of java thread safe queue class java.util.concurrent package instead of looper achieve goal. it's more common practice. share queue between threads , post task queue entry 1 thread can entry thread. blockingqueue can - in 1 thread call take() , block thread until thread put() entry queue. that's all. producer consumer pattern example blockingqueue or concurrentlinkedqueue about blockingqueue
Read more

visual studio 2010 - Connect to informix database windows form application -

-
i trying figure out how connect ibm informix database. have been doing research , have found threads 5 years ago examples not working. i have installed latest sdk ibm informix. i have included ibm.data.informix.dll references in project. i have included using ibm.data.informix; i adding button , on click testing conenction. debug error "sql0035n file "c:\users\adam\documents\visual studio 2010\projects\test\test\msg\en_us\db2nmp.xml" cannot opened." this file not exist , dont see anywhere in program files (x86)\ibm informix client sdk directory. my on click code is private void button1_click(object sender, eventargs e) { const string host = "192.168.obfuscated"; const string servicenum = "1525"; //port? const string server = "serverobfuscated"; const string database = "dbobfuscatedy"; const string user = "myusername"; const string password = &
Read more