poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avik Sengupta <avik.sengu...@itellix.com>
Subject Re: Opening HSSFSheets in MS Project - Is it a bug?
Date Sat, 24 Jan 2004 10:25:56 GMT
You'll probably need to test this with a hand crafted excel file, to
find out if this is POI issue or an MS project issue. 

On Fri, 2004-01-23 at 14:15, Andrea Nenni wrote:
> Hello everybody,
> 
> I still could not find a solution for my MS Project import problem.
> 
> Perhaps I shoud give you some more detailed information:
> 
> I create Excel sheets with POI and open them with Microsoft Project.
> Each row in my sheet corresponds to a "task" in MS Project. (You can  
> define special mappings to and from MS Excel in MS Project.)
> 
> Everything works fine, when the number of rows in the created Excel
> file is odd. However, when the row number is even, MS Project will just
> ignore the last row, i.e. one "task" is missing. There seems to be some
> difference in the file ending between HSSFSheets with odd and even row 
> numbers. Im still not sure, if this is a bug or just part of Microsoft's 
> definition of the MS Excel format.
> 
> Next, I tried to cheat MS Project, by using an additional empty row at 
> the end of the sheet. Consequentially, MS Project shows an empty "task"
> at the bottom.
> 
> What I found somehow amazing: When I remove the additional row immediately
> after adding it in POI, MS Project still shows the additional "task".
> 
> Has anybody an idea how to work around this problem?
> Please help me.
> 
> Andrea
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message