Leaderboard

The following works for me: $oExcel.Selection.FormatConditions.Add(1, 6, "=0")

By the way, for future members/searchers seeking help in finding text in Scanned PDFs. If you need to make a tool for schools/college/universities or non-profit organizations, this company offers a number of free licenses for various target groups.

nooneclose, With such a small array I would suggest that is the most sensible solution. You will need to keep track of the rows and/or columns that you fill so as to correctly insert the next data point and you could easily use those variables to determine which elements actually hold data. If you can produce some example code i would be happy to look at it and make any suggestions that spring to mind. M23

As the WebDriver UDF - Help & Support thread has grown too big, I started a new one. The prior thread can be found here.

AutoIt v3.3.15.3 Beta View File 3.3.15.3 (16th May, 2020) (Beta) AutoIt: - Added #3681: Lang Variable prefix "o". - Fixed #2915: Map memory leak. - Fixed: Map errors with index < 0. UDFs: - Changed #3620: Removed "stable" from _ArraySort function header. - Added #3670: DriveGetDrive() @error doc clarification. - Added #3574: GuiCtrlCreateInput() Doc $ES_AUTOHSCROLL precision. - Fixed: Problem with _WinAPI_GetFontResourceInfo & _WinAPI_GetFontMemoryResourceInfo - Fixed #3728: Added optional parameter to force single column 2D array to 1D. - Fixed #3678: Amended Help file to show that function with no text blanks a line, not removes it. - Fixed #3757: Added note to GUICtrlListView_SetColor* pages about need to use BGR format. - Fixed #3697: _WinAPI_GetOverlappedResult() failure. Submitter Jon Submitted 05/16/2020 Category Beta  

@Danp2 I just finished editing it and got it to work right as you finished your reply. XD The working code is : $itmNumber = _WD_FindElement($sSession, $_WD_LOCATOR_ByXPath, "//div[@class='ui left action input']//div[@class='ui icon input']//div[@class='ui input mini']//input[@ptidatafld='idfItemID']") $rArray[$i][$ac] = _WD_ElementAction($sSession, $itmNumber, 'property', 'value') I can not thank you enough. This issue has been bothering me for two days now.

@nooneclose I would recommend that you take a look at the Chropath browser add-on. It's very helpful with these types of issues. You could also check out the Copy option from the right-click menu in Developer Tools. If gives options for xpath, css, etc.

@seadoggie01 Looks like the function header needs updating. -1 was the original default before I started using the Default keyword. Opening an issue on GH is good for things that potentially require coding changes and you don't want them to get overlooked / forgotten in the forums.

Have you looked into using their API? This might be the easiest way to obtain the data. P.S. You can find the data by entering this in the browser console -- rootReduxStore.getState().chartComponentList[0].dataStore.getState().main.mainChartData

Okay so, I had a look at the Assign and Eval functions and I don't believe they would've helped me accomplish what I wanted to. That or it didn't click with me. However, you're right about arrays being the better option. I looked into arrays more and was able to accomplish my task with the following test code: AutoItSetOption ( "ExpandVarStrings", 1 ) $VarAA = 1 $VarAB = 2 $VarAC = 3 $VarAD = 4 $VarAE = 5 $VarAF = 6 $VarBA = 7 $VarBB = 8 $VarBC = 9 $VarBD = 10 $VarBE = 11 $VarBF = 12 ; Declaring a 2 dimensional array Global $Var[2][6] = [[ $VarAA, $VarAB, $VarAC, $VarAD, $VarAE, $VarAF ],[ $VarBA, $VarBB, $VarBC, $VarBD, $VarBE, $VarBF ]] For $a = 0 to 1 For $b = 0 to 5 If $Var[$a][$b] = ($a*6)+$b+1 Then $VarX = $Var[$a][$b] MsgBox ( 0, "Test", "($a$*6)+$b$+1 = $VarX$" ) EndIf Next Next Thanks a lot for the guidance!

That seems to be what @Melba23 is suggesting. You can then check to see elements in the array are not used while looping through it using something like If StringIsSpace ( $array[1][1] ) Or $array[1][1] = Null Then

This is the best time to start understanding this kind of solutions, it's not so complicated, and the usage is simple. The idea is to set hotkeys and hold them in array, and when needed, unset it by the data in this array.

@guinness, thanks for the great work. But when I compiled my script on the new AutoIT version, the ResourcesEx.au3 needs an include file: #include <WinAPISysWin.au3> needed by _WinAPI_SetWindowLong Regards, Jowy