You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Thouin, Alexandre" <Al...@CMCElectronics.ca> on 2011/07/07 17:09:28 UTC
Shared workbook support for XLS documents
Hi all,
First, I just want to thank you for giving us the opportunity to work
with XLS files from Java. This is great!
So the question, I'm trying to modify a shared XLS file with POI but it
does not work as expected. Instead of "participating" to the shared
workbook, it overwrites the file (overwriting changes from other people)
when I'm saving the XLS file from Java. Is there a way to "push" the
modified data and then participate to the shared workbook?
Thanks!
Alexandre
RE: Shared workbook support for XLS documents
Posted by "Thouin, Alexandre" <Al...@CMCElectronics.ca>.
Thanks for trick but it won't work since it's not an NFS volume (I tried
it anyway to double check).
I will just be careful and double check so I don't screw the data...
Thanks!
Alexandre
-----Original Message-----
From: Dave Fisher [mailto:dave2wave@comcast.net]
Sent: July 7, 2011 3:28 PM
To: POI Users List
Subject: Re: Shared workbook support for XLS documents
On Jul 7, 2011, at 12:19 PM, Thouin, Alexandre wrote:
> Thanks Dave,
>
> Yes, I understand that the Microsoft Sharing thing is beyond the scope
> of POI. I will get the users to close their copy which will be far
> easier than doing all those changes manually like before anyway.
If you have a user that won't close, then the following might work for
you.
(1) Rename the file on the server.
(2) Copy it back to the old name - to preserve shares.
(3) Run your Apache POI based update.
The user who doesn't close works with an old generation of the file.
On an NFS volume this would work. You'll need to ask your sysadmin.
Regards,
Dave
>
> Thanks!
> Alexandre
>
> -----Original Message-----
> From: Dave Fisher [mailto:dave2wave@comcast.net]
> Sent: July 7, 2011 3:08 PM
> To: POI Users List
> Subject: Re: Shared workbook support for XLS documents
>
> POI works with the file in Java without any concern for issues like
> Microsoft Sharing which is really beyond the scope of the project.
>
> Here are a couple of ideas:
>
> If you can segregate the part you want POI to update as another
workbook
> and have the shared user maintained part separate. Try having that use
a
> formula to pull from the POI maintained workbook. That way refresh
> calculations in the Shared book will pull your changes.
>
> If your POI application is cleaning the workbook, then you'll need to
> get the users to close their copy before you update.
>
> Regards,
> Dave
>
> On Jul 7, 2011, at 11:54 AM, Thouin, Alexandre wrote:
>
>> Hi again,
>>
>>
>>
>> I realized that my first message might not be very well detailed and
I
>> just found an old thread about the same problem with no solution:
>>
>>
>>
>>
>
http://mail-archives.apache.org/mod_mbox/poi-user/200405.mbox/%3C02F8EC1
>> EFFA95249B91E50BA8CED3E0E015DAEAF@stpmse05.stp.guidant.com%3E
>>
>>
>>
>> To the question asked in the old thread: if the person in the excel
>> client closes/reopens the spreadsheet, do they see the reflected
>> automatic changes?
>>
>> The answer is: yes, it will see the reflected changes if he does NOT
>> save the document before exiting.
>>
>>
>>
>> Thanks again,
>>
>> Alexandre
>>
>>
>>
>> ________________________________
>>
>> From: Thouin, Alexandre
>> Sent: July 7, 2011 11:09 AM
>> To: 'user@poi.apache.org'
>> Subject: Shared workbook support for XLS documents
>>
>>
>>
>> Hi all,
>>
>>
>>
>> First, I just want to thank you for giving us the opportunity to work
>> with XLS files from Java. This is great!
>>
>>
>>
>> So the question, I'm trying to modify a shared XLS file with POI but
> it
>> does not work as expected. Instead of "participating" to the shared
>> workbook, it overwrites the file (overwriting changes from other
> people)
>> when I'm saving the XLS file from Java. Is there a way to "push" the
>> modified data and then participate to the shared workbook?
>>
>>
>>
>> Thanks!
>>
>> Alexandre
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Shared workbook support for XLS documents
Posted by Dave Fisher <da...@comcast.net>.
On Jul 7, 2011, at 12:19 PM, Thouin, Alexandre wrote:
> Thanks Dave,
>
> Yes, I understand that the Microsoft Sharing thing is beyond the scope
> of POI. I will get the users to close their copy which will be far
> easier than doing all those changes manually like before anyway.
If you have a user that won't close, then the following might work for you.
(1) Rename the file on the server.
(2) Copy it back to the old name - to preserve shares.
(3) Run your Apache POI based update.
The user who doesn't close works with an old generation of the file.
On an NFS volume this would work. You'll need to ask your sysadmin.
Regards,
Dave
>
> Thanks!
> Alexandre
>
> -----Original Message-----
> From: Dave Fisher [mailto:dave2wave@comcast.net]
> Sent: July 7, 2011 3:08 PM
> To: POI Users List
> Subject: Re: Shared workbook support for XLS documents
>
> POI works with the file in Java without any concern for issues like
> Microsoft Sharing which is really beyond the scope of the project.
>
> Here are a couple of ideas:
>
> If you can segregate the part you want POI to update as another workbook
> and have the shared user maintained part separate. Try having that use a
> formula to pull from the POI maintained workbook. That way refresh
> calculations in the Shared book will pull your changes.
>
> If your POI application is cleaning the workbook, then you'll need to
> get the users to close their copy before you update.
>
> Regards,
> Dave
>
> On Jul 7, 2011, at 11:54 AM, Thouin, Alexandre wrote:
>
>> Hi again,
>>
>>
>>
>> I realized that my first message might not be very well detailed and I
>> just found an old thread about the same problem with no solution:
>>
>>
>>
>>
> http://mail-archives.apache.org/mod_mbox/poi-user/200405.mbox/%3C02F8EC1
>> EFFA95249B91E50BA8CED3E0E015DAEAF@stpmse05.stp.guidant.com%3E
>>
>>
>>
>> To the question asked in the old thread: if the person in the excel
>> client closes/reopens the spreadsheet, do they see the reflected
>> automatic changes?
>>
>> The answer is: yes, it will see the reflected changes if he does NOT
>> save the document before exiting.
>>
>>
>>
>> Thanks again,
>>
>> Alexandre
>>
>>
>>
>> ________________________________
>>
>> From: Thouin, Alexandre
>> Sent: July 7, 2011 11:09 AM
>> To: 'user@poi.apache.org'
>> Subject: Shared workbook support for XLS documents
>>
>>
>>
>> Hi all,
>>
>>
>>
>> First, I just want to thank you for giving us the opportunity to work
>> with XLS files from Java. This is great!
>>
>>
>>
>> So the question, I'm trying to modify a shared XLS file with POI but
> it
>> does not work as expected. Instead of "participating" to the shared
>> workbook, it overwrites the file (overwriting changes from other
> people)
>> when I'm saving the XLS file from Java. Is there a way to "push" the
>> modified data and then participate to the shared workbook?
>>
>>
>>
>> Thanks!
>>
>> Alexandre
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Shared workbook support for XLS documents
Posted by "Thouin, Alexandre" <Al...@CMCElectronics.ca>.
Thanks Dave,
Yes, I understand that the Microsoft Sharing thing is beyond the scope
of POI. I will get the users to close their copy which will be far
easier than doing all those changes manually like before anyway.
Thanks!
Alexandre
-----Original Message-----
From: Dave Fisher [mailto:dave2wave@comcast.net]
Sent: July 7, 2011 3:08 PM
To: POI Users List
Subject: Re: Shared workbook support for XLS documents
POI works with the file in Java without any concern for issues like
Microsoft Sharing which is really beyond the scope of the project.
Here are a couple of ideas:
If you can segregate the part you want POI to update as another workbook
and have the shared user maintained part separate. Try having that use a
formula to pull from the POI maintained workbook. That way refresh
calculations in the Shared book will pull your changes.
If your POI application is cleaning the workbook, then you'll need to
get the users to close their copy before you update.
Regards,
Dave
On Jul 7, 2011, at 11:54 AM, Thouin, Alexandre wrote:
> Hi again,
>
>
>
> I realized that my first message might not be very well detailed and I
> just found an old thread about the same problem with no solution:
>
>
>
>
http://mail-archives.apache.org/mod_mbox/poi-user/200405.mbox/%3C02F8EC1
> EFFA95249B91E50BA8CED3E0E015DAEAF@stpmse05.stp.guidant.com%3E
>
>
>
> To the question asked in the old thread: if the person in the excel
> client closes/reopens the spreadsheet, do they see the reflected
> automatic changes?
>
> The answer is: yes, it will see the reflected changes if he does NOT
> save the document before exiting.
>
>
>
> Thanks again,
>
> Alexandre
>
>
>
> ________________________________
>
> From: Thouin, Alexandre
> Sent: July 7, 2011 11:09 AM
> To: 'user@poi.apache.org'
> Subject: Shared workbook support for XLS documents
>
>
>
> Hi all,
>
>
>
> First, I just want to thank you for giving us the opportunity to work
> with XLS files from Java. This is great!
>
>
>
> So the question, I'm trying to modify a shared XLS file with POI but
it
> does not work as expected. Instead of "participating" to the shared
> workbook, it overwrites the file (overwriting changes from other
people)
> when I'm saving the XLS file from Java. Is there a way to "push" the
> modified data and then participate to the shared workbook?
>
>
>
> Thanks!
>
> Alexandre
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Shared workbook support for XLS documents
Posted by Dave Fisher <da...@comcast.net>.
POI works with the file in Java without any concern for issues like Microsoft Sharing which is really beyond the scope of the project.
Here are a couple of ideas:
If you can segregate the part you want POI to update as another workbook and have the shared user maintained part separate. Try having that use a formula to pull from the POI maintained workbook. That way refresh calculations in the Shared book will pull your changes.
If your POI application is cleaning the workbook, then you'll need to get the users to close their copy before you update.
Regards,
Dave
On Jul 7, 2011, at 11:54 AM, Thouin, Alexandre wrote:
> Hi again,
>
>
>
> I realized that my first message might not be very well detailed and I
> just found an old thread about the same problem with no solution:
>
>
>
> http://mail-archives.apache.org/mod_mbox/poi-user/200405.mbox/%3C02F8EC1
> EFFA95249B91E50BA8CED3E0E015DAEAF@stpmse05.stp.guidant.com%3E
>
>
>
> To the question asked in the old thread: if the person in the excel
> client closes/reopens the spreadsheet, do they see the reflected
> automatic changes?
>
> The answer is: yes, it will see the reflected changes if he does NOT
> save the document before exiting.
>
>
>
> Thanks again,
>
> Alexandre
>
>
>
> ________________________________
>
> From: Thouin, Alexandre
> Sent: July 7, 2011 11:09 AM
> To: 'user@poi.apache.org'
> Subject: Shared workbook support for XLS documents
>
>
>
> Hi all,
>
>
>
> First, I just want to thank you for giving us the opportunity to work
> with XLS files from Java. This is great!
>
>
>
> So the question, I'm trying to modify a shared XLS file with POI but it
> does not work as expected. Instead of "participating" to the shared
> workbook, it overwrites the file (overwriting changes from other people)
> when I'm saving the XLS file from Java. Is there a way to "push" the
> modified data and then participate to the shared workbook?
>
>
>
> Thanks!
>
> Alexandre
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Shared workbook support for XLS documents
Posted by "Thouin, Alexandre" <Al...@CMCElectronics.ca>.
Hi again,
I realized that my first message might not be very well detailed and I
just found an old thread about the same problem with no solution:
http://mail-archives.apache.org/mod_mbox/poi-user/200405.mbox/%3C02F8EC1
EFFA95249B91E50BA8CED3E0E015DAEAF@stpmse05.stp.guidant.com%3E
To the question asked in the old thread: if the person in the excel
client closes/reopens the spreadsheet, do they see the reflected
automatic changes?
The answer is: yes, it will see the reflected changes if he does NOT
save the document before exiting.
Thanks again,
Alexandre
________________________________
From: Thouin, Alexandre
Sent: July 7, 2011 11:09 AM
To: 'user@poi.apache.org'
Subject: Shared workbook support for XLS documents
Hi all,
First, I just want to thank you for giving us the opportunity to work
with XLS files from Java. This is great!
So the question, I'm trying to modify a shared XLS file with POI but it
does not work as expected. Instead of "participating" to the shared
workbook, it overwrites the file (overwriting changes from other people)
when I'm saving the XLS file from Java. Is there a way to "push" the
modified data and then participate to the shared workbook?
Thanks!
Alexandre