Re: Listen for a cell value change

2010-07-01 Thread Frizz
I'll try it.. MSB wrote: > > Sorry to post again but I have just read this sentence; > > Subscribe to Excel cells modification. > > The following example listens to changes in Excel cells. The > setEventListener method is used to set event handler which will print A1 > cell changes to consol

Re: Listen for a cell value change

2010-07-01 Thread Frizz
Yes, it's a DDE flow, but I can't find anything free and functional for use DDE with java MSB wrote: > > So, if I have this clear in my mind, you have a process that will interact > with Excel - updating cells on a workbook - and want to perform some > operation whenever a cell is updated. Can

Re: Listen for a cell value change

2010-07-01 Thread MSB
Sorry to post again but I have just read this sentence; Subscribe to Excel cells modification. The following example listens to changes in Excel cells. The setEventListener method is used to set event handler which will print A1 cell changes to console. Here - http://jdde.pretty-tools.com/exam

Re: Listen for a cell value change

2010-07-01 Thread MSB
Have no idea if these are of any use, but it might be worth looking here; http://jdde.pretty-tools.com/ http://www.javaparts.com/ and there were lots of other references discussing Java and DDE, I just Google'd 'DDE Java' and they appeared close to the top of the list. This may give you the abi

Re: Listen for a cell value change

2010-07-01 Thread MSB
So, if I have this clear in my mind, you have a process that will interact with Excel - updating cells on a workbook - and want to perform some operation whenever a cell is updated. Can the same process that modifies the workbook's cell not also act as the trigger for the java method you want to c

Re: Listen for a cell value change

2010-07-01 Thread Frizz
well, yes. I want to use excel like a bridge. Excel must be update via DDE and I want to wake up some java method at every update. Do you know some api that can do it? MSB wrote: > > Can I just be clear about what you are asking please? Are you saying that > someone will have a workbook open i

Re: Listen for a cell value change

2010-07-01 Thread MSB
Can I just be clear about what you are asking please? Are you saying that someone will have a workbook open in Excel and you want to detect if they make a change to a cell and then perform some action? If this is the case then no, you cannot do this with POI. The API can be used only to create/edi