Read out excel to array

Hi All, How is it possible to read out a Excel file without opening the excel file itself in excel? With the current posts on the forum it's for me not possible to fix my issue. I was looking at the Excel.au3 include file but this did not help me. Could someone help me please? Regards, lrstndm

By lrstndm, February 2, 2016
8 replies

Use _Excel_RangeFind to get the row where your key is located. Then use the Offset method to get the value of the column right to it. $aResult = _Excel_RangeFind($oExcel, "key", "column:column") $vValue = $oExcel.Range($aResult[0][2]).Offset(0, 1).Value