Search the Community
Showing results for tags 'range'.
Found 9 results
-
$aTdslist = _Excel_RangeRead($oWorkbook1, Default, "B1:B" & $LastRow) $aTDSLOC = _Excel_RangeRead($oWorkbook1, Default, "H1:H" & $LastRow) MsgBox(0, "TAKSY OUTPUT LAST ROW", $LastRow) _ArrayTrim($aTDSLOC, 1, 1) _Excel_RangeWrite($oWorkbook1, $oWorkbook1.ActiveSheet, $aTDSLOC, "H2") $oWorkbook1.She...
-
Script running good but error in line 7. When i run this script : #include <IE.au3> #include <Array.au3> $oIE = _IEAttach ("Shop") $oTable = _IETableGetCollection ($oIE, 1) $aTableData = _IETableWriteToArray ($oTable) For $inumber = 1 To UBound($aTableData) -1 $table = $aTableData[4][$inum... -
Hi guys, Wondering, is there a better way, likely to use 'for...next' to add a letter to each range, by moving right -> along a range of columns in excel. I currently use this, but its clunky. If $run = 1 Then $range = "B6:B41" If $run = 2 Then $range = "C6:C41" If $run = 3 T...
-
Hi Does someone know if there is an easy way to convert numerical coordinates of row, column to an A1 notation range object (or at least to an A1 notation string)? that is: if I have 2 numerical values for row and column, say row 3 and column 5, I would get an E3 string or better an $oRange object r... -
How can I access a variable with its index of a loop inside my if statment. Code: For $i = 0 To UBound($aFileListFootageFolderRe_01) - 1 ... Next If $getTimeNewFootageFolderInit_01 <> $getTimeNewFootageFolder_01 And $aFileListFootageFolderRe_01[$i] == 11) Then ...... -
What is the best way to create an array from a filtered Excel sheet? Let say I've set a filter this way _Excel_FilterSet($oWorkbook, Default, Default, 10, "AutoIt", $xlFilterValues)How can I create an array only from the filtered values only using a range from "T2:ACxxx" whereas xxx is the last line... -
I'm stuck on how to use for range selection .Cells function. Instead of _Excel_RangeSort($oWorkbook, Default, Default, "AD:AD", Default, Default, $xlYes, False, Default, "AE:AE", Default, "L:L", Default)and $aResult = _Excel_RangeRead($oWorkbook, 1, "S2:AB" & $iRows)which works properly I want to us...
-
Hello Autoit Scripters, Using Autoit v3.3.14.1 in Windows 7, I'm trying to write an array of X rows by 34 columns to an Excel 2000 sheet as follows: _Excel_RangeWrite ($workbook, $newsheet, $outarray) It only works up to 160 rows. An array longer than that writes nothing or hangs the system. This ne...
-
Hi there. I'm trying to make a resumable winHttp upload. But stuck at reading a file within byte ranges. Tried line functions (filereadline, _filecountlines) but nothing. The file im trying to upload is a video (binary) file. I have to read byte ranges to upload my video partially. is there any udf...
