Hi Mark, What i am trying to accomplish is read a row of data from the excel file and delimit the columns with a pipe "|" character. This row of data is passed on for processing . My problem is i need to find the last column , if say i have 2 columns in my excel file my output will be
ColumnHeader1|ColumnHeader2| TextColumn1|TextColumn2| But suppose for the 3rd column in my excel sheet also returns me true (output of the celliterator.hasNext()) .My code below will give me a output ColumnHeader1|ColumnHeader2| TextColumn1|TextColumn2|| An extra pipe character at the end. How should i handle this scenario , i am interested in all cell types string,numeric,boolean etc Thanks & Regards, mathaj On Mon, Jan 25, 2010 at 10:21 PM, MSB <[email protected]> wrote: > > You would need to use an additional tool - BiffViewer - to accomplish thais > and it may well not be wirth while in this case. > > Can I ask, do the extra columns matter to you? Cannot you simply ignore the > additional blank cells that appear? It looks from the loop that you have > posted that the only cell tyep you are interested in are the String(s). > > Yours > > Mark B > > > Aju Mathai wrote: >> >> Hi Mark, >>> >>> The file is generated automatically without any user intervention. How >>> do i find out whether the excel file has been modified in the ways you >>> talk about ? . The POI version that i am using is 3.5_beta3. >>> >>> Thanks & Regards, >>> mathaj >> >> On Fri, Jan 22, 2010 at 1:12 PM, MSB <[email protected]> wrote: >>> >>> Excel can behave quite oddly at times and it will create a record for a >>> cell >>> if it has been 'touched' in any way by the user during creation of the >>> file. >>> By this, I mean that if the user entered a value into a cell and then >>> cleared that out or if they set a format and then removied it, Excel will >>> recognise that something was done to the cell and will create a record >>> for >>> it in the file. Without seeing the actual file/files you are working with >>> I >>> cannot comment much further but do suspect that this may have been the >>> case; >>> either the user or the application that created the file left a few of >>> these >>> artifacts around. I do not expect that this is a problem with POI but to >>> be >>> certain, can you post one of the files that is exhibiting this sort of >>> behaviour so that we could take a closer look at it please? Further, can >>> you >>> say which version of the API you are using and how the Excel file is >>> generated - by someone using Excel or by another application - please? >>> >>> Yours >>> >>> Mark B >>> >>> >>> >>> Aju Mathai wrote: >>>> >>>> Hi, >>>> >>>> I am using the following POI libraries to read in the files with .xls >>>> and .xlsx files. I found a strange problem ,the celliterator.hasNext() >>>> sometimes gives true even if the next column in my xls file seems to >>>> be blank, i have no additional columns. How do i take care of such >>>> blank cells ? >>>> >>>> Here is my code snippet >>>> >>>> for(Iterator<Cell> ri = row.cellIterator(); >>>> ri.hasNext();) { >>>> Cell cell = ri.next(); >>>> >>>> switch(cell.getCellType()){ >>>> case Cell.CELL_TYPE_STRING: >>>> >>>> text.append(cell.getRichStringCellValue().getString().trim()); >>>> break; >>>> case Cell.CELL_TYPE_NUMERIC: >>>> >>>> text.append(cell.getNumericCellValue()); >>>> break; >>>> case Cell.CELL_TYPE_BOOLEAN: >>>> >>>> text.append(cell.getBooleanCellValue()); >>>> break; >>>> case Cell.CELL_TYPE_FORMULA: >>>> >>>> text.append(cell.getCellFormula()); >>>> break; >>>> case Cell.CELL_TYPE_BLANK: >>>> break; >>>> default: >>>> text.append(""); >>>> } >>>> // Column Delimiter >>>> if(ri.hasNext() && !(cell.getCellType() >>>> == Cell.CELL_TYPE_BLANK)) >>>> text.append(COLUMN_DELIMITER); >>>> } >>>> >>>> >>>> Thanks >>>> mathaj >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: [email protected] >>>> For additional commands, e-mail: [email protected] >>>> >>>> >>>> >>> >>> -- >>> View this message in context: >>> http://old.nabble.com/Problem-reading-XLS-files-tp27254834p27269628.html >>> Sent from the POI - User mailing list archive at Nabble.com. >>> >>> >>> --------------------------------------------------------------------- >>> 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] >> >> >> > > -- > View this message in context: > http://old.nabble.com/Problem-reading-XLS-files-tp27254834p27307989.html > Sent from the POI - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > 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]
