need Excel Read and Write

[232showtime]

is there any way or is it possible to read or write the values without opening the excel workbook? I googled it but did not find any auotit related example. thanks in advanced

[water]

No. To read the content of any file you have to open it.
With the Excel UDF you can open and read the workbook hidden so the user does not get disturbed.

[232showtime]

noted, but is it possible to read the whole data in excel??

[water]

What do you mean by "whole data". Everything from a worksheet? Everything from all sheets of a workbook?

[232showtime]

Sorry, I meant read all the data in excel workbook.

Edited September 19, 2016 by 232showtime

[water]

Use _Excel_SheetList to enumerate all sheets of the workbook. Then loop throught the returned array and use _Excel_RangeRead to read all data of the worksheet into an array.
Means: You will get as many arrays as there are sheets in your workbook.