You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Ananth <An...@cognizant.com> on 2008/05/19 11:14:20 UTC

Issue with HSSF

I have used POI through Liferay. I am having an issue with POI. 


Our workflow using POI is that, we create an excel sheet with description of 
jobs and then email the excel sheet to the administrator. When the admin tries 
to open the excel sheet the excel sheet is closing saying ‘Microsoft word has 
encountered an illegal operation and needs to close’. 

Why is this happening. If it is required I will send the code too. 

Regards,
Ananth. 


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


RE: Issue with HSSF

Posted by An...@cognizant.com.
Hi Sebestian,
              How can we use the reference of the template excel sheet?
Do we have a problem if the same excel is accessed by two users?

Regards,
Ananth. 

-----Original Message-----
From: Sebastian Frehmel [mailto:uhbdz@stud.uni-karlsruhe.de] 
Sent: Monday, May 19, 2008 4:38 PM
To: POI Users List; Majumdar, Ananth (Cognizant)
Cc: user@poi.apache.org
Subject: Re: Issue with HSSF

Hi Ananth

I had this problem several times. too.
I solved it by using a template excel sheet which had been created by 
Excel and then was being read in by POI using POIFS. I modified this 
sheet and wrote it back to the disk. It could be opened without 
problems.

So just create an empty or almost empty sheet in excel and use this 
sheet as your basis to work on.

Regards


Zitat von Ananth <An...@cognizant.com>:

> Ananth <Ananth.Majumdar <at> cognizant.com> writes:
>
>>
>> I have used POI through Liferay. I am having an issue with POI.
>>
>> Our workflow using POI is that, we create an excel sheet with
description of
>> jobs and then email the excel sheet to the administrator. When the
admin
> tries
>> to open the excel sheet the excel sheet is closing saying 'Microsoft
word
> has
>> encountered an illegal operation and needs to close'.
>>
>> Why is this happening. If it is required I will send the code too.
>>
>> Regards,
>> Ananth.
>>
> I have missed something in my previous post. Actually the excel sheet
opens
> correctly but if I try to save it or edit it and save it then it is
closing
> with the error message.
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>




This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. 
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly 
prohibited and may be unlawful.

  

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: Issue with HSSF

Posted by Sebastian Frehmel <uh...@stud.uni-karlsruhe.de>.
Hi Ananth

I had this problem several times. too.
I solved it by using a template excel sheet which had been created by 
Excel and then was being read in by POI using POIFS. I modified this 
sheet and wrote it back to the disk. It could be opened without 
problems.

So just create an empty or almost empty sheet in excel and use this 
sheet as your basis to work on.

Regards


Zitat von Ananth <An...@cognizant.com>:

> Ananth <Ananth.Majumdar <at> cognizant.com> writes:
>
>>
>> I have used POI through Liferay. I am having an issue with POI.
>>
>> Our workflow using POI is that, we create an excel sheet with description of
>> jobs and then email the excel sheet to the administrator. When the admin
> tries
>> to open the excel sheet the excel sheet is closing saying ‘Microsoft word
> has
>> encountered an illegal operation and needs to close’.
>>
>> Why is this happening. If it is required I will send the code too.
>>
>> Regards,
>> Ananth.
>>
> I have missed something in my previous post. Actually the excel sheet opens
> correctly but if I try to save it or edit it and save it then it is closing
> with the error message.
>
>
>
>
> ---------------------------------------------------------------------
> 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: Issue with HSSF

Posted by Ananth <An...@cognizant.com>.
Ananth <Ananth.Majumdar <at> cognizant.com> writes:

> 
> I have used POI through Liferay. I am having an issue with POI. 
> 
> Our workflow using POI is that, we create an excel sheet with description of 
> jobs and then email the excel sheet to the administrator. When the admin 
tries 
> to open the excel sheet the excel sheet is closing saying ‘Microsoft word 
has 
> encountered an illegal operation and needs to close’. 
> 
> Why is this happening. If it is required I will send the code too. 
> 
> Regards,
> Ananth. 
> 
I have missed something in my previous post. Actually the excel sheet opens 
correctly but if I try to save it or edit it and save it then it is closing 
with the error message. 




---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org