B4J Question Get Excel data

[tufanv]

Hello,

I read that we can open and get xls and xlsx files into b4j. Is it possible to get data from excel directly without opening a xls file =?
I mean our b4j app and excel software will be open on the same machine. b4j app will get column a1 and a2 data every 5 seconds but excel is not saving files every 5 seconds so we will have to get the data from excel directly ? is this possible ?

Thanks

 

[Erel]

It is not possible.
jPOI library reads the data from the Excel file. It has nothing to do with Excel application.

 

[inakigarm]

You can code a vba excel module that saves the workbook every x seconds and open it from B4J/jPoi (but don't understand exactly which is the scenary)

 

[tufanv]

You can code a vba excel module that saves the workbook every x seconds and open it from B4J/jPoi (but don't understand exactly which is the scenary)

thats a good idea. I will try this. Thanks

 

[sorex]

You can enable multi user on your document. Maybe it will be possible then to read the data even when people are working in it. Doubt it tho.