How to get data from excel file without open it

[val75]

Hi,

I try to consolidate data from big xlsx files without open them

I would like to use something like Microsoft.ACE.OLEDB.12.

Does AutoIt allow to do this?

Thanks for any help.

[ViciousXUSMC]

Your best bet for anything like this is Waters ExcelUDF.

'?do=embed' frameborder='0' data-embedContent>>

It does not open the file for viewing it handles it in the background. 

[val75]

Hi :-)

I've found also this: https://www.autoitscript.com/wiki/ADO

Thanks

[water]

As well written by water