You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Danny Mui <da...@muibros.com> on 2004/09/27 17:44:19 UTC
Re: POI HSSF file read in Websphere 5.1
would you be running excel on the server? is that what you mean??
Kishore Kandikonda wrote:
> My websphere app server(v 5.1) at times shuts down when the my code is unable to read the excel spreadsheet uploaded through the web-app. I am supposed to read a csv file, but since poi asks for an ole type component to read, I am having to convert the .csv file into .xls manually through the MS Excel app. Does anybody think that I could be messing around with the spreadsheet format by doing this?
>
> Also, it scares me that an error in file read actually causes the jvm to dump and write to a core file, rather than it being hadled in my catch block. I cannot possibly allow this to happen in on a live web site. Does anybody know how this can be handled?
>
> Thanks,
> Kishore
>
> P.S. I have tried various ways to convert .csv to .xls and there is no one way which allow the file to be read for sure.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> vote.yahoo.com - Register online to vote today!
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: POI HSSF file read in Websphere 5.1
Posted by Danny Mui <da...@muibros.com>.
why not just upload the CSV file and parse it out yourself?
Can your HSSF program parse the Excel file outside of WAS 5.1?
HSSF doesn't do anything fancy enough to blow up the application server
other than Out of Memory exceptions. It's hard to help you pinpoint the
fault without anything concrete.
Kishore Kandikonda wrote:
> The user does this activity of "save as" on the user's terminal prior to uploading, so the web app receives only the xls file type.
>
> Danny Mui <da...@muibros.com> wrote:
> would you be running excel on the server? is that what you mean??
>
>
> Kishore Kandikonda wrote:
>
>>My websphere app server(v 5.1) at times shuts down when the my code is unable to read the excel spreadsheet uploaded through the web-app. I am supposed to read a csv file, but since poi asks for an ole type component to read, I am having to convert the .csv file into .xls manually through the MS Excel app. Does anybody think that I could be messing around with the spreadsheet format by doing this?
>>
>>Also, it scares me that an error in file read actually causes the jvm to dump and write to a core file, rather than it being handled in my catch block. I cannot possibly allow this to happen in on a live web site. Does anybody know how this can be handled?
>>
>>Thanks,
>>Kishore
>>
>>P.S. I have tried various ways to convert .csv to .xls and there is no one way which allow the file to be read for sure.
>>
>>
>>
>>---------------------------------
>>Do you Yahoo!?
>>vote.yahoo.com - Register online to vote today!
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> vote.yahoo.com - Register online to vote today!
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: POI HSSF file read in Websphere 5.1
Posted by Kishore Kandikonda <kn...@yahoo.com>.
The user does this activity of "save as" on the user's terminal prior to uploading, so the web app receives only the xls file type.
Danny Mui <da...@muibros.com> wrote:
would you be running excel on the server? is that what you mean??
Kishore Kandikonda wrote:
> My websphere app server(v 5.1) at times shuts down when the my code is unable to read the excel spreadsheet uploaded through the web-app. I am supposed to read a csv file, but since poi asks for an ole type component to read, I am having to convert the .csv file into .xls manually through the MS Excel app. Does anybody think that I could be messing around with the spreadsheet format by doing this?
>
> Also, it scares me that an error in file read actually causes the jvm to dump and write to a core file, rather than it being handled in my catch block. I cannot possibly allow this to happen in on a live web site. Does anybody know how this can be handled?
>
> Thanks,
> Kishore
>
> P.S. I have tried various ways to convert .csv to .xls and there is no one way which allow the file to be read for sure.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> vote.yahoo.com - Register online to vote today!
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!