Read out excel to array

[lrstndm]

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

[Jfish]

I do not believe Excel has to be open if you connect to it as if it were a database.  That is the only way I am aware of that it can be queried without opening it (but @water may know better).  This is an older example of a SQL connection to Excel.

Edited February 2, 2016 by Jfish

[water]

Why do you need to avoid opening the file using the Excel application?

• Is there no Excel installed?
• Do you need to run your script invisible?
• Anything else?

[lrstndm]

I do not want it to be opened. That is what happens when I tried to retrieve data from the Excel file. And also I was not possible to get some information from the opened Excel file.

[lrstndm]

It needs to be invisible like reading out a text file from memory. Or is this not possible?

[water]

I understand what you want. But If I understand why you want it I can provide a solution!

[water]

It's possible. Please check the help file how to open Excel invisible with the Excel UDF, function _Excel_Open.

[lrstndm]

I have a "key-value" collumn. Which I want to read out. Where I just can enter a key and get the value from the cell next to it.

[water]

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