Hi, I am trying to create a Excel file .I pull some records from the data and put these records into a cell and create an excel file. The excel gets created properly and shows some 400kb .(approximatley i will be pulling 1000 records). and this file is being mailed toa group of people and when we try to open the file, it doesnt open but there is data in the file. if we change the class file by deleting/adding some junk code and compile it and then run it. the excel file is created and is opened properly. if i try to run again with the same data..it doesnt open...can neone help me in solving thsi problem.. i dont think there is any problem with the code or with the data? is there nething that is related to the jar files? is there ne new set of jar files that are used to create an excel file. Please help me in solving this?
Send samples of invalid worksheets to acoliver at apache dot org. Confidentiality is assured. Secure methods of transmitting the data can be arranged. It would probably be most useful to see examples of ones you slightly modified as well as their original unmodified (corrupt) version. Also are you adding/modifying strings or numeric values? (This could be a problem with the static string record). It would be far more helpful to know if this occurs with a build from CVS. At the very least with 1.4583. (see downloads) -- If you can help us trace this down I'm confident we can fix it before the 1.5 release.
Hi Andy, I have sent you some sample along with valid and invalid worksheets. I am trying to run the program continously... Sometimes it workd fine and sometimes it doesnt .My name of the file is : abcd_datetime.xls Has it got to do nething with the data or the no of records... Please let me know. Thanks Naren
Hi Andy, Thanks for the prompt reply.Actually i was using the old jar files and this is a known bug in the old jar files of poi. I have started using latest jakarta- poi-1.1-dev.jar (ver 1.4583) jar files and log4j.jar. This solved my problem. Thanks Naren