;***************************** ;* RoboTask Task file ;* Do not edit in text editor! ;***************************** [Root] ActionAfterRun=INTEGER|0 Actions=FOLDER Automat=INTEGER|-1 CatID=INTEGER|2099193306 Comment=STRINGLIST ContinueOnError=INTEGER|0 Events=FOLDER ExternalName=STRING|"Task253" Hide=INTEGER|0 ID=INTEGER|1514201180 LogOnAsUser=INTEGER|1 Name=STRING|"Copy cells from excell document to notepad" OnErrorTaskID=INTEGER|0 Priority=INTEGER|3 RunOnClose=INTEGER|0 RunOnStartup=INTEGER|0 ToLog=INTEGER|3 WriteGeneralLog=INTEGER|0 [Actions] Action1=FOLDER Action10=FOLDER Action11=FOLDER Action12=FOLDER Action13=FOLDER Action14=FOLDER Action15=FOLDER Action16=FOLDER Action17=FOLDER Action18=FOLDER Action19=FOLDER Action2=FOLDER Action20=FOLDER Action21=FOLDER Action22=FOLDER Action23=FOLDER Action24=FOLDER Action25=FOLDER Action26=FOLDER Action27=FOLDER Action28=FOLDER Action29=FOLDER Action3=FOLDER Action30=FOLDER Action31=FOLDER Action32=FOLDER Action33=FOLDER Action4=FOLDER Action5=FOLDER Action6=FOLDER Action7=FOLDER Action8=FOLDER Action9=FOLDER [Actions\Action1] ActionID=STRING|"A_VARIABLES_CREATE" Enabled=INTEGER|-1 Name=STRING|"Create local variable ""CELL1"" with value ""1""" Params=FOLDER [Actions\Action1\Params] expand=STRING|"0" varkind=STRING|"1" varname=STRING|"CELL1" varvalue=STRING|"1" [Actions\Action10] ActionID=STRING|"A_WINDOW_COMMAND" Enabled=INTEGER|-1 Name=STRING|"Focus window ""Microsoft Excel""" Params=FOLDER [Actions\Action10\Params] action=STRING|"0" caption=STRING|"1" child=STRING|"0" class=STRING|"0" classexact=STRING|"0" exact=STRING|"0" findmode=STRING|"0" hidden=STRING|"0" processall=STRING|"0" wincaption=STRING|"Microsoft Excel" [Actions\Action11] ActionID=STRING|"A_CLIPBOARD_COPY" Enabled=INTEGER|-1 Name=STRING|"Copy" Params=FOLDER [Actions\Action11\Params] mode=STRING|"1" [Actions\Action12] ActionID=STRING|"A_CLIPBOARD_GET" Enabled=INTEGER|-1 Name=STRING|"Get Text" Params=FOLDER [Actions\Action12\Params] variable=STRING|"cell1" [Actions\Action13] ActionID=STRING|"A_GENERAL_SENDKEYS" Enabled=INTEGER|-1 Name=STRING|"Send keys to active window" Params=FOLDER [Actions\Action13\Params] currentwindow=STRING|"1" fixedwindow=STRING|"0" keylayout=STRING|"0" keys=STRING|"{right}" pause=STRING|"20" release=STRING|"0" sendkind=STRING|"0" wincaption=STRING|"Notepad" [Actions\Action14] ActionID=STRING|"A_CLIPBOARD_COPY" Enabled=INTEGER|-1 Name=STRING|"Copy" Params=FOLDER [Actions\Action14\Params] mode=STRING|"1" [Actions\Action15] ActionID=STRING|"A_CLIPBOARD_GET" Enabled=INTEGER|-1 Name=STRING|"Get Text" Params=FOLDER [Actions\Action15\Params] variable=STRING|"cell2" [Actions\Action16] ActionID=STRING|"A_GENERAL_SENDKEYS" Enabled=INTEGER|-1 Name=STRING|"Send keys to active window" Params=FOLDER [Actions\Action16\Params] currentwindow=STRING|"1" fixedwindow=STRING|"0" keylayout=STRING|"0" keys=STRING|"{right}" pause=STRING|"20" release=STRING|"0" sendkind=STRING|"0" wincaption=STRING|"Notepad" [Actions\Action17] ActionID=STRING|"A_CLIPBOARD_COPY" Enabled=INTEGER|-1 Name=STRING|"Copy" Params=FOLDER [Actions\Action17\Params] mode=STRING|"1" [Actions\Action18] ActionID=STRING|"A_CLIPBOARD_GET" Enabled=INTEGER|-1 Name=STRING|"Get Text" Params=FOLDER [Actions\Action18\Params] variable=STRING|"cell3" [Actions\Action19] ActionID=STRING|"A_GENERAL_SENDKEYS" Enabled=INTEGER|-1 Name=STRING|"Send keys to active window" Params=FOLDER [Actions\Action19\Params] currentwindow=STRING|"1" fixedwindow=STRING|"0" keylayout=STRING|"0" keys=STRING|"{right}" pause=STRING|"20" release=STRING|"0" sendkind=STRING|"0" wincaption=STRING|"Notepad" [Actions\Action2] ActionID=STRING|"A_VARIABLES_CREATE" Enabled=INTEGER|-1 Name=STRING|"Create local variable ""CELL2"" with value """"" Params=FOLDER [Actions\Action2\Params] expand=STRING|"0" varkind=STRING|"1" varname=STRING|"CELL2" [Actions\Action20] ActionID=STRING|"A_CLIPBOARD_COPY" Enabled=INTEGER|-1 Name=STRING|"Copy" Params=FOLDER [Actions\Action20\Params] mode=STRING|"1" [Actions\Action21] ActionID=STRING|"A_CLIPBOARD_GET" Enabled=INTEGER|-1 Name=STRING|"Get Text" Params=FOLDER [Actions\Action21\Params] variable=STRING|"cell4" [Actions\Action22] ActionID=STRING|"A_GENERAL_SENDKEYS" Enabled=INTEGER|-1 Name=STRING|"Send keys to active window" Params=FOLDER [Actions\Action22\Params] currentwindow=STRING|"1" fixedwindow=STRING|"0" keylayout=STRING|"0" keys=STRING|"{DOWN}{LEFT}{LEFT}{LEFT}" pause=STRING|"20" release=STRING|"0" sendkind=STRING|"0" wincaption=STRING|"Notepad" [Actions\Action23] ActionID=STRING|"A_STR_TRIM" Enabled=INTEGER|-1 Name=STRING|"STR Trim" Params=FOLDER [Actions\Action23\Params] custom=STRING|"0" eol=STRING|"1" lead=STRING|"1" source=STRING|"{cell1}" spaces=STRING|"1" tabs=STRING|"1" trailing=STRING|"1" variable=STRING|"cell1" [Actions\Action24] ActionID=STRING|"A_STR_TRIM" Enabled=INTEGER|-1 Name=STRING|"STR Trim" Params=FOLDER [Actions\Action24\Params] custom=STRING|"0" eol=STRING|"1" lead=STRING|"1" source=STRING|"{cell2}" spaces=STRING|"1" tabs=STRING|"1" trailing=STRING|"1" variable=STRING|"cell2" [Actions\Action25] ActionID=STRING|"A_STR_TRIM" Enabled=INTEGER|-1 Name=STRING|"STR Trim" Params=FOLDER [Actions\Action25\Params] custom=STRING|"0" eol=STRING|"1" lead=STRING|"1" source=STRING|"{cell3}" spaces=STRING|"1" tabs=STRING|"1" trailing=STRING|"1" variable=STRING|"cell3" [Actions\Action26] ActionID=STRING|"A_STR_TRIM" Enabled=INTEGER|-1 Name=STRING|"STR Trim" Params=FOLDER [Actions\Action26\Params] custom=STRING|"0" eol=STRING|"1" lead=STRING|"1" source=STRING|"{cell4}" spaces=STRING|"1" tabs=STRING|"1" trailing=STRING|"1" variable=STRING|"cell4" [Actions\Action27] ActionID=STRING|"A_FLOW_IF" Enabled=INTEGER|-1 Name=STRING|"If Then" Params=FOLDER [Actions\Action27\Params] case=STRING|"0" operator=STRING|"7" type=STRING|"0" value1=STRING|"{cell1}" [Actions\Action28] ActionID=STRING|"A_LOOP_BREAK" Enabled=INTEGER|-1 Name=STRING|"Break" [Actions\Action29] ActionID=STRING|"A_FLOW_ENDIF" Enabled=INTEGER|-1 Name=STRING|"End If" [Actions\Action3] ActionID=STRING|"A_VARIABLES_CREATE" Enabled=INTEGER|-1 Name=STRING|"Create local variable ""CELL3"" with value """"" Params=FOLDER [Actions\Action3\Params] expand=STRING|"0" varkind=STRING|"1" varname=STRING|"CELL3" [Actions\Action30] ActionID=STRING|"A_WINDOW_COMMAND" Enabled=INTEGER|-1 Name=STRING|"Focus window ""notepad""" Params=FOLDER [Actions\Action30\Params] action=STRING|"0" caption=STRING|"1" child=STRING|"0" class=STRING|"0" classexact=STRING|"0" exact=STRING|"0" findmode=STRING|"0" hidden=STRING|"0" processall=STRING|"0" wincaption=STRING|"notepad" [Actions\Action31] ActionID=STRING|"A_GENERAL_SENDKEYS" Enabled=INTEGER|-1 Name=STRING|"Send keys to active window" Params=FOLDER [Actions\Action31\Params] currentwindow=STRING|"1" fixedwindow=STRING|"0" keylayout=STRING|"0" keys=STRING|"""Row {num}: {cell1} | {cell2} | {cell3} | {cell4}{enter}""" pause=STRING|"20" release=STRING|"0" sendkind=STRING|"0" wincaption=STRING|"Notepad" [Actions\Action32] ActionID=STRING|"A_VARIABLES_INCREMENT" Enabled=INTEGER|-1 Name=STRING|"Increment variable ""num""" Params=FOLDER [Actions\Action32\Params] incement=STRING|"1" vaiable=STRING|"num" [Actions\Action33] ActionID=STRING|"A_LOOP_END" Enabled=INTEGER|-1 Name=STRING|"End Loop" [Actions\Action4] ActionID=STRING|"A_VARIABLES_CREATE" Enabled=INTEGER|-1 Name=STRING|"Create local variable ""CELL4"" with value """"" Params=FOLDER [Actions\Action4\Params] expand=STRING|"0" varkind=STRING|"1" varname=STRING|"CELL4" [Actions\Action5] ActionID=STRING|"A_VARIABLES_CREATE" Enabled=INTEGER|-1 Name=STRING|"Create local variable ""NUM"" with value ""1""" Params=FOLDER [Actions\Action5\Params] expand=STRING|"0" varkind=STRING|"1" varname=STRING|"NUM" varvalue=STRING|"1" [Actions\Action6] ActionID=STRING|"A_MISK_SHIFTKEYSSTATE" Enabled=INTEGER|-1 Name=STRING|"Release keys: Shift, Ctrl, Alt" Params=FOLDER [Actions\Action6\Params] action=STRING|"1" alt=STRING|"1" ctrl=STRING|"1" shift=STRING|"1" win=STRING|"0" [Actions\Action7] ActionID=STRING|"A_GENERAL_RUN_PROG" Enabled=INTEGER|-1 Name=STRING|"Run ""Notepad """ Params=FOLDER [Actions\Action7\Params] ifnonzero=STRING|"0" program=STRING|"Notepad" runas=STRING|"0" wait=STRING|"0" [Actions\Action8] ActionID=STRING|"A_GENERAL_PAUSE" Enabled=INTEGER|-1 Name=STRING|"Delay 1000 ms" Params=FOLDER [Actions\Action8\Params] delay=STRING|"10" [Actions\Action9] ActionID=STRING|"A_LOOP_WHILE" Enabled=INTEGER|-1 Name=STRING|"While loop" Params=FOLDER [Actions\Action9\Params] case=STRING|"0" operator=STRING|"8" type=STRING|"0" value1=STRING|"{cell1}" [Events] Event1=FOLDER [Events\Event1] Enabled=INTEGER|-1 EventID=STRING|"E_GENERAL_HOTKEY" Params=FOLDER UnigueID=INTEGER|1634817 [Events\Event1\Params] hotkey=STRING|"49219"