Lord Tennyson wrote this 1854, but it applies to working with Excel as well ;)
Theirs not to make reply, Theirs not to reason why, ...... But seriously, there are entries for many empty cells in an Excel file. Dont ask why, but history of operations could be one reason. So you cant depend on the index of a record in the file.. you can only go by the row and col numbers inside the record. On Wed, 2004-03-24 at 16:27, Karl-Heinz Zengerle wrote: > Hi world. > > In a row containing 12 elements getLastCellNum() returns 12 also Iâld > expect 11 (because of being 0-based). Also there a phantom cell seems to > be counted. > > Regards, Karl-Heinz. > > > -----UrsprÃngliche Nachricht----- > Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 24. MÃrz 2004 11:49 > An: [EMAIL PROTECTED] > Betreff: phantom cells? > > Hi world. > > In a row containing text in column A and column C and having explicitly > deleted the other cells in the line the cell table for the row (in the > debugger) shows me an entry for index 0 (which should be according to > column A) and an entry for index 14 (according to the content > corresponding to column C â intuitively Iâld expect this at index 2). > > How can that be interpreted? Is the history of manipulation operations > performed on that Excel file the reason for such a strange situation? > > MfG > Karl-Heinz Zengerle > ___________________________________________________ > More than competence in Document Management > ___________________________________________________ > > SAW AG > WaldmÃnchenerstr. 12 > 81549 MÃnchen > Tel.: ++49-89-68088368 > Fax: ++49-89-68088389 > www.sawag.com > > ___________________________________________________ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
