Leaderboard

Hi @ioa747 The official AutoIt3 executable requires a file on disk to run. As far as i know it is not possible to make it run a stream of data, if it was you could download it in ram, and pipe it to the executable. So you either download all the files before running, somewhere (temporary files directory example) or you try to find an unofficial working AutoIt3 parser and executor.

This UDF provides 2 functions to read data directly from xlsx files or to output data as xlsx file. Only the cell contents are considered - no cell formatting and the like. It is therefore explicitly not a full replacement for the Excel UDF, since its scope goes well beyond that. But to quickly read in data or to work with xlsx files without having Excel installed, the UDF can be quite useful. There may also be specially formatted xlsx files which I have not yet encountered during testing and which may cause problems. In this case it is best to make a message about it here and upload the file. Note: xlsx files must be unpacked for reading. To make this as fast as possible it is recommended to put a >>7za.exe<< file into the script directory, otherwise a slow alternative will be used. Otherwise an example says more than 1000 words: >>sourcecode and download on github<< Changelog:

You will have to change the stop hotkey. on the german keyboard (which i'm using) the Shift 2 is the " char. so here i would replace the with you have to see which char is on the shift 2 and place it insead of " (i guess it is the @ char, as @Danp2 said)

Yes @SOLVE-SMART, That's exactly what i was missing, Thank you so much, @ioa747 Your post are also helpfull.. Gives materials to study :D, Thanks guys

90% of my contracts nowadays are RPA (Automation Anywhere & UIPAth mainly), and I have used PowerAutomate. To your questions: I have not noticed extreme slowness with Power Automate. I guess it depends on what version you are using (Base or Desktop) and what you are trying to do. To dig in to why it is running so slowly for you, I would agree with the above comment - this is really not the best place for that. A Power Automate forum should be your next stop. As to a viable alternative to AutoIt, that is comparing apples and oranges It does indeed do things natively AutoIt does not, such as IDP with applied AI and ML It also comes with a very high price tag, depending on your Microsoft licensing model - you could be charged per bot in some cases. Power Automate's base package is only intended for automating the O365 suite of MS applications. If you want a broader range of automation you need to purchase Desktop. Finally, if true RPA is what you're after (it sounds like you're unsure what it actually is), Power Automate is a distant 4th behind Automation Anywhere, UIPath, and Blue Prism. If, after doing some research, you find that is the path you want to take, I would suggest investigating the other platforms before investing in this one.

The hex value representing the key should be contained within quotes.

To be honest @ioa747, I was actually thinking about such toggle function: HotKeySet('{ESC}', '_Exit') HotKeySet('1', '_ToggleMouse') Global $bIsDown = False Func _Exit() Exit EndFunc Func _ToggleMouse() $bIsDown = Not $bIsDown If $bIsDown Then MouseDown('middle') Return EndIf MouseUp('middle') EndFunc While True Sleep(200) WEnd Simply press "1" to do the mouse down ("middle" key) action and press "1" again for the mouse up action (and again and again 😅). I think this is exactly what @SevenScript wanted to know, am I right? Best regards Sven

I think I've sorted the column name array. Created an array with: Local $ColumnInTab[0] Then: _ArrayAdd ( $ColumnInTab, _Excel_ColumnToLetter($iCol + 1)) and for the single column: _ArrayAdd ( $ColumnInTab, "A") Thanks again for your help, what would I do without this forum!

@Trong you have right about the concept of remote scripting. Wrong expression! @genius257I was impressed, I took a link example it was yours, @SOLVE-SMART suggested a program which was also yours, and now you answer to the thread !! you look like a soul of AutoIt3 Thank you all for explanation !

Perfect. I have modified the function so it works for a 1D array as well: #include <Excel.au3> Global $iSheet = 2 ; create a Range holding all used cells including unused rows at the top and unused columns on the left ; See: https://www.autoitscript.com/wiki/Excel_Range#Used_Range With $oWorkbook.Sheets($iSheet) $oRangeLast = .UsedRange.SpecialCells($xlCellTypeLastCell) $oRange = .Range(.Cells(1, 1), .Cells($oRangeLast.Row, $oRangeLast.Column)) EndWith ; Process the Range Global $aUsedRange = _Excel_RangeRead($oWorkbook, $iSheet, $oRange) _ArrayDisplay($aUsedRange) If UBound($aUsedRange, 0) = 2 Then For $iCol = 0 To UBound($aUsedRange, 2) - 1 ; Process all columns For $iRow = 0 To UBound($aUsedRange, 1) - 1 ; Process all rows If $aUsedRange[$iRow][$iCol] <> "" Then ; add checks for valid columns here ; ConsoleWrite(_Excel_ColumnToLetter($iCol + 1) & @CRLF) ConsoleWrite($iCol + 1 & @CRLF) ExitLoop ; Process next column EndIf Next Next Else For $iRow = 0 To UBound($aUsedRange, 1) - 1 ; Process all rows If $aUsedRange[$iRow] <> "" Then ; add checks for valid columns here ; ConsoleWrite(_Excel_ColumnToLetter($iCol + 1) & @CRLF) ConsoleWrite("A" & @CRLF) ExitLoop EndIf Next EndIf If this works we will add a few lines to create an array with the column names.

Something like this. #include <Array.au3> Global $aTV_Array[11][2] = [["TV1", 0], ["TV2", 0], ["TV3", 0], ["TV4", 0], ["TV5", 0], ["TV6", 0], ["TV7", 0], ["TV8", 0], ["TV9", 0], ["TV10", 0], ["TV11", 0]] _ArrayDisplay($aTV_Array) InitArray($aTV_Array) _ArrayDisplay($aTV_Array) Func InitArray(ByRef $aArray) Local $iOffset = 11 For $i = 0 To UBound($aArray, 1) - 1 $aArray[$i][1] = $i + $iOffset Next EndFunc ;==>InitArray

and when tray no needed this just with HotKey #include <misc.au3> Local $Enabled, $SleepTime Enabled() While 1 Sleep($SleepTime) WEnd Func start(); ;MouseDown("middle") MouseWheel("down") EndFunc Func stop(); ;MouseUp("middle") MouseWheel("up") EndFunc Func Enabled() if $Enabled = True Then $Enabled = False $SleepTime = 1000 HotKeySet("1") HotKeySet("2") Else $Enabled = True $SleepTime = 10 HotKeySet("{ESC}", "Enabled") HotKeySet("1", "start") HotKeySet("2", "stop") EndIf ConsoleWrite("$Enabled=" & $Enabled & @CRLF) EndFunc

maybe help

Hi @SevenScript, I guess you are looking for a toggle function. Please search the forum for toggle and you will get examples that are similar to your question. I don't have enough time at the moment to script a quick script as an example, because I am in rush. Maybe later today. Best regards Sven

No, because This is the case with all these 'no-code/low-code' packages, it's actually one of the reasons I decided to learn how to code, I tried out practically every no-code RPA solution out there and they were all ridiculously slow.

Simply: download and run it! The concept of remote scripting is that the program does not run on your machine, but runs from a computer on the network like a web server!

I'll just interpret that by "workbook" you meant "worksheets" instead - right? As I understand it, there is only one workbook in an xlsx file - am I right? So I added a new function _xlsx_getWorkSheets() which returns a list of the existing worksheets. This is being used as follows: #include "xlsxNative.au3" Local $sFile = @ScriptDir & "\Test.xlsx" ; determine the worksheets of a file Local $aSheets = _xlsx_getWorkSheets($sFile) _ArrayDisplay($aSheets, "Sheet List", "", 64 + 32 , Default, "ID|Name")