poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <acoli...@apache.org>
Subject Re: CANNOT WRITE TO BLANK SHEET 0 after reading template
Date Wed, 02 Jul 2003 00:16:40 GMT
Was there a basic executable code + xls that reproduces it?

On 7/1/03 7:40 PM, "Steve" <stephen@Basit.COM> wrote:

> ACO,
> Thanks for your reply. I guess I got more motivation to find the problem,
> and
> I believe that this is it:  There is a bug.
> This type of problem was discussed by Cliff (Clifton Craig) and you can see
> about 12 of his posts to the list around June 18.
> The subject line is:  "Cannot write to extra sheets"
> One of his emails is below.
> I solved my problem by simply writing data in one cell on the template
> sheet.
> I guess I will have my POI program later erase that value before writing the
> new xls file.
> My prior application didn't run into this problem because I put "tags" in
> sheet 0, and then erased them.
> In my current application, I started out with one tag in the template.xls,
> and things were going
> fine. I didn't make the connection of erasing that tag with the onset of my
> problem.
> Note that the problem persists if I create a new template and delete all
> the original sheets, add 6 new sheets, and save the template.xls so that
> I can read it in POI.
> I have not yet tried writing to sheet 1 or 2 or 3 etc. Only to sheet at
> index 0.
> 
> THANKS,
> Steve
> --------------------------------
> 
> Hello all,
> 
> I am having a problem writing to the extra sheets that Excel creates by
> default when you create a new workbook. I'm using the
> jakarta-poi1.8.0-dev-20020919.jar version. I've developed a conversion
> program that allows data to be merged with existing spreadsheets. The merge
> works when I attempt to write on a sheet that has already been written on.
> However, whenever I attempt to write to one of the blank sheets (sheets 2
> and 3) that Excel creates automatically with an empty workbook it doesn't
> work. I can adjust the width of cells in these sheets but they do not
> retain any info from the  cell.setCellValue() method calls. I verified in
> debug that these methods are not failing. My debugger (Eclipse) allows me
> to see the cell values before and after the method calls. I've attempted
> many tests where I enter the exact same parameters to merge data to an
> existing workbook changing only the sheet number. The data is retained only
> on the 1st sheet where I've already added data. This is the only variance
> in my test runs. In all cases I obtain references to the sheet, row and
> cell objects the same way. I do a Workbook.getSheetAt(int num) to get the
> existing sheet. (I've tried with Workbook.getSheet(String name) as well.) I
> am using Worksheet.createRow(short row) to create the row and
> Row.createCell(short cell) to create cell references. In my code I verify
> that the rows and cells do not exist prior to creating. In the latter case
> I use the corresponding methods to obtain references to the existing
> objects. What am I missing?
> 
> -Cliff
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> ----- Original Message -----
> From: "Andrew C. Oliver" <acoliver@apache.org>
> To: "POI Developers List" <poi-dev@jakarta.apache.org>
> Sent: Tuesday, July 01, 2003 5:56 PM
> Subject: Re: any ideas on what could be causing this....NEED HELP
> 
> 
>> Gosh, that could be anything.  Perhaps if you reduced to the minimum
> amount
>> of code that reproduces the problem (with a static void main), attached
> the
>> XLS to a bug in bugzilla we could help.
>> 
>> 9/10 the person reporting this finds they have an obvious coding error
>> before they ever get that far ;-)
>> 
>> 1/10 times the help us find a serious issue and we are very grateful
>> 
>> 
>> On 7/1/03 5:51 PM, "Steve" <stephen@Basit.COM> wrote:
>> 
>>> (see below)
>>> Also, if I add certain statements back into the program
>>> (these statements are not the problem) then Excel crashed
>>> after a few seconds after it opens the created file. The
>>> message box says:
>>> The instruction at "0x301bf877" referenced memory at
>>> "0x00000000". The memory could not be "read".
>>> 
>>> I'm using:  jakarta-poi-1.10.0-dev-20030222.jar
>>> THANKS,
>>> Steve
>>> ----- Original Message -----
>>> From: "Steve" <stephen@Basit.COM>
>>> To: "POI Developers List" <poi-dev@jakarta.apache.org>
>>> Sent: Tuesday, July 01, 2003 5:05 PM
>>> Subject: HELP: any ideas on what could be causing this....
>>> 
>>> 
>>>> I read in a template xls file and use POI to change it.
>>>> It was working fine for a while, but now
>>>> when I open the created  xls file,  there are
>>>> no data written to it.
>>>> Some formatting changes are visible,
>>>> such as merged cell regions, but that's
>>>> all.
>>>> It seems like my program is going through
>>>> it's paces, and there are no exceptions,
>>>> but the sheet is blank.
>>>> Any ideas what could cause this.
>>>> I'm using 1.10
>>>> THANKS,
>>>> Steve
>>>> 
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
>>>> 
>>> 
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
>>> 
>> 
>> --
>> Andrew C. Oliver
>> http://www.superlinksoftware.com/poi.jsp
>> Custom enhancements and Commercial Implementation for Jakarta POI
>> 
>> http://jakarta.apache.org/poi
>> For Java and Excel, Got POI?
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: poi-dev-help@jakarta.apache.org
>> 
> 

-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?


Mime
View raw message