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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
