Gesendet: Dienstag, 27. April 2004 14:56
An: POI Users List
Betreff: Re: AW: excel crashes
hi karl,
thanks for the info.We are planning to go for a n alternative-use JAXP
n
modify the excel xml file n do data integration with excel sheet instead
of using poi API as it has many limitations to fit
hi karl,
thanks for the info.We are planning to go for a n alternative-use JAXP n
modify the excel xml file n do data integration with excel sheet instead
of using poi API as it has many limitations to fit in to our project right
now
thanks for all your time n help
kamala
: POI Users List
Betreff: excel crashes
hello,
I have an excel file consisting of 16 sheets.many of these sheets make
use
of 3D reference.
Iam trying to read the file using poi and then write to it .
problems that i faced
1)I used poi 2.5 initially and i got foll exception when tried reading
the
file
how come the new
version has no support for lists.
2)Now once i read the file ,i try writing to the file.After done,and try
opening the excel file-excel crashes and if i try to open the file in the
recovery mode,excel complains the file is damaged,repairs it n then opens
it.
I get the "u
This problem is now solved using the v2.0 RC1. This morning a file was processed which
crashed Excel, upgrading to the latest version resulted in a spreadsheet which didn't
crash Excel.
Many thanks for your help,
Matt
Avik Sengupta <[EMAIL PROTECTED]> wrote:
>Have you any idea how many uniqu
Hi!
In you workbook, in the first sheet (All Data), there are two named ranges
defined (Insert->Name->Define) one is PM which is defined as ='All
Data'!$T$1:$U$2. The other is PM_1 which seems to be defined to 'All Data'!#REF
. This causes the resulting xl file to become corrupt. ( Unknown Ptg 3d
I'll look into this later today. with the code and the file available, i
should at least be able to tell whats wrong, if not fix it.
On Sat, 2003-10-25 at 01:11, Jean, Victor [IT] wrote:
> I'm using POI to do a exact copy of an excel file.
>
> here's the code:
>
> HSSF hssf = ne
I'm using POI to do a exact copy of an excel file.
here's the code:
HSSF hssf = new HSSF("c:/upload/test.xls");
HSSFWorkbook wb = hssf.hssfworkbook;
FileOutputStream stream = new FileOutputStream("c:/upload/output.xls");
wb.write(stream);
stream.close();
>Have you any idea how many unique strings this version
>(2.0-pre3-20030728) was limited to?
Nope, its also linked to the size of each string, i believe :(. I think
the best thing would be if you could try the latest build from CVS. We
could take it from there. It looks probable that this will so
Avik,
Thanks for the info. I'm using 2.0-pre3-20030728 because I needed eventusermodel to
work and that version seemed to work best.
The tool which uses POI is a data reconciliation utility which processes 3 millions
rows a year for the bank I work for and saves a fortune in reconciliation c
Yeah sure, I appreciate the data could be confidential.
The problem is, its quite impossible to debug a situation like this
unless both the code and data are available .. so all we can do is
provide pointers...
In many such bugs have been fixed recently, but its of course
impossible to prove th
I'll have a go at providing some source but it's tricky because I use POI to write the
output from a data reconciliation tool. It's not particular bits of data which cause
the crash but also the amount. Also the data is reasonably confidential and I can't
just send it out.
What's the best way
yeah, that happens if there is any error in writing out the xl file.
We've fixed some important one's recently
To help debug your case, you must supply the minimum code required to
replicate your case, and the example xl file, otherwise its impossible
to figure out whats happening. Also, tell
Has anyone got any experience of POI writing a XLS file which cannot be opened in
Excel? In fact I have an application which creates a spreadsheet and if you give it
certain kinds of data then when you try to open the resulting spreadsheet, Excel
throws a Dr. Watson.
---
14 matches
Mail list logo
