Search the Community
Showing results for tags 'rangeread'.
Hello, I'm struggling and not sure what I'm missing with how to use the _Excel_RangeRead function. Based on: https://www.autoitscript.com/autoit3/docs/libfunctions/_Excel_RangeRead.htm The second parameter should allow me to select different sheet names, however I can't seem to get it to work. I was thinking something like this (see below) would be all I need to get an array for the sheet named as "test sheet". $array = _Excel_RangeRead($oWorkbook, "test sheet") Can someone please help tell me what I'm missing here? Thank you,
Dear all, first of all hi. I`m in trouble, again 😕 I can`t find right solution, tried all possible combinations generated by my mind and nothing. I need to copy range of values depending by values from two different cells in excel sheet. I put an example in attachment. I have two values which is never changed (is changed only TEXT). I need to copy all the rows from VALUE 1 to VALUE 2 in new Sheets (Output 1, Output 2, ... , Output X). It is possible to do this using Autoit? 🤔 Also in attachment you can find last example which I have tried and it`s s
Hey guys I'm new to autoit, so this could be a simple question. I'm trying to read the value from the currently selected cell in Excel. I read on the forum and tired to find videos, but I couldn't quite get to it. This is what I have got so far: Local $oExcel_1 = _Excel_Open() Local $var = "C:\Users\Acer\xy" Local $oWorkbook = _Excel_BookOpen($oExcel_1,$var) Local $_read1 = _Excel_RangeRead($oWorkbook, Default.Application.ActiveCell.Address) Whatever I try, I either get an error or it only reads "0". Thank you very much for an