And if u need help with CSV http://ostermiller.org/utils/CSV.html
-----Original Message----- From: Danny Mui [mailto:[EMAIL PROTECTED] Sent: Monday, September 27, 2004 11:57 AM To: POI Users List Subject: Re: POI HSSF file read in Websphere 5.1 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------- > Do you Yahoo!? > vote.yahoo.com - Register online to vote today! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
