You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Frizz <fr...@gmail.com> on 2010/07/01 13:02:09 UTC
Listen for a cell value change
I want to develop a program that do something every time a value of a Excel
cell change. Can I do it with poi?
--
View this message in context: http://old.nabble.com/Listen-for-a-cell-value-change-tp29044396p29044396.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Listen for a cell value change
Posted by Frizz <fr...@gmail.com>.
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 the same process that modifies
> the workbook's cell not also act as the trigger for the java method you
> want to call?
>
> Yours
>
> Mark B
>
>
--
View this message in context: http://old.nabble.com/Listen-for-a-cell-value-change-tp29044396p29047924.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Listen for a cell value change
Posted by MSB <ma...@tiscali.co.uk>.
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
call?
Yours
Mark B
Frizz wrote:
>
> 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 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/edit files that are compatible with Excel.
>>
>> Yours
>>
>> Mark B
>>
>>
>> Frizz wrote:
>>>
>>> I want to develop a program that do something every time a value of a
>>> Excel cell change. Can I do it with poi?
>>>
>>
>>
>
>
--
View this message in context: http://old.nabble.com/Listen-for-a-cell-value-change-tp29044396p29047480.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Listen for a cell value change
Posted by MSB <ma...@tiscali.co.uk>.
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 ability to send a DDE message and use that to trigger
off the java method you were talking of. If this is the case then you could
message Excel and then message the java app.
Yours
Mark B
Frizz wrote:
>
> 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 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/edit files that are compatible with Excel.
>>
>> Yours
>>
>> Mark B
>>
>>
>> Frizz wrote:
>>>
>>> I want to develop a program that do something every time a value of a
>>> Excel cell change. Can I do it with poi?
>>>
>>
>>
>
>
--
View this message in context: http://old.nabble.com/Listen-for-a-cell-value-change-tp29044396p29047749.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Listen for a cell value change
Posted by Frizz <fr...@gmail.com>.
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 console.
>
> Here - http://jdde.pretty-tools.com/examples.php
>
> and it looks like that is what you are after.
>
> Yours
>
> Mark B
>
>
> Frizz wrote:
>>
>> 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 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/edit files that are compatible with Excel.
>>>
>>> Yours
>>>
>>> Mark B
>>>
>>>
>>> Frizz wrote:
>>>>
>>>> I want to develop a program that do something every time a value of a
>>>> Excel cell change. Can I do it with poi?
>>>>
>>>
>>>
>>
>>
>
>
--
View this message in context: http://old.nabble.com/Listen-for-a-cell-value-change-tp29044396p29047966.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Listen for a cell value change
Posted by MSB <ma...@tiscali.co.uk>.
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/examples.php
and it looks like that is what you are after.
Yours
Mark B
Frizz wrote:
>
> 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 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/edit files that are compatible with Excel.
>>
>> Yours
>>
>> Mark B
>>
>>
>> Frizz wrote:
>>>
>>> I want to develop a program that do something every time a value of a
>>> Excel cell change. Can I do it with poi?
>>>
>>
>>
>
>
--
View this message in context: http://old.nabble.com/Listen-for-a-cell-value-change-tp29044396p29047763.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Listen for a cell value change
Posted by Frizz <fr...@gmail.com>.
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 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/edit files that are compatible with Excel.
>
> Yours
>
> Mark B
>
>
> Frizz wrote:
>>
>> I want to develop a program that do something every time a value of a
>> Excel cell change. Can I do it with poi?
>>
>
>
--
View this message in context: http://old.nabble.com/Listen-for-a-cell-value-change-tp29044396p29047308.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Listen for a cell value change
Posted by MSB <ma...@tiscali.co.uk>.
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/edit files that are compatible with Excel.
Yours
Mark B
Frizz wrote:
>
> I want to develop a program that do something every time a value of a
> Excel cell change. Can I do it with poi?
>
--
View this message in context: http://old.nabble.com/Listen-for-a-cell-value-change-tp29044396p29047136.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org