I go further in my problem: I don't know why but there is always a cell null (the fourth beginning by the end) So I can't read it, and the worse I can't even delete it!!! Do you have an idea on the solution to my problem: how could I erase a cell that exists but that is null! Thank you
Nick Burch wrote: > > On Wed, 19 Mar 2008, lili2 wrote: >> I create an excel file with POI et my data are well displayed (first >> line: headers and the other lines are the body). I have an issue >> concerning the fourth column - counting beginning at the end - is always >> empty. For example, when I have 6 columns: the third is empty, when I >> have 10 columns: the seventh is empty. > > This does seem rather odd. Any chance you could write a small unit test > that shows up the problem, then upload this to bugzilla? That way, we'll > be able to take a look > >> In the case nobody knows this problem could you please help to delete >> this column? Does a function "remove the column where the first cell is >> empty" exists? > > There's nothing quite like that. You'd need to code it up yourself - test > the first row, then loop over the rest or the rows zapping columns > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Empty-column-Problem-in-excel-file-tp16143651p16177820.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
