upload excel file validation in java

Question

i am new for upload Excel file POI API so i need to validate duplicate cell in particular column . example like

String dupcolumn  = myRow.getcell(0);
Iterator iter = new Iterator();
while(iter.hesnext())
{
myRow = (Row) iter.next();

dupcolumn.contains(iter.toString());


}

Above code cannot support to read in particular column , but always continuous reading column .

Now i have write code like that String[] dupcolumn = myRow.getcell(0); boolean dup =true; if(dup){for(int i=0 ; i<dupcolumn.length;i++){for(int j=i+1;j<dupcolumn .length;j++){if(dupcolumn [j]==dupcolumn [i]){System.out.println("Duplicate cell");}}} this code is correct . — sameer
– sameer, Commented Nov 7, 2012 at 2:07

ravindra · Accepted Answer · 2012-11-07 04:53:54Z

6

This code may helpful to you.

InputStream xlsStream = excelFileUpload.getInputstream();
XSSFWorkbook wb  = new XSSFWorkbook(xlsStream);
XSSFSheet sheet = wb.getSheetAt(0);
Iterator<Row> rows=sheet.iterator();
//need to keep retrieved values in a collection to check duplicates. 
Set<String> values = new HashSet<String>();

//check all rows in excel sheet
while(rows.hasNext()){
    //get next row
    XSSFRow row =(XSSFRow)rows.next();
    //pass '0' means first cell (column) in current row. if you need to get other cell value, you can pass relevant cell number instead of '0'. 
    XSSFCell cell=row.getCell(0);
    if(values.contains(cell.getStringCellValue())){
        //duplicated value
    }else{
        values.add(cell.getStringCellValue());
    }
}

edited Nov 7, 2012 at 4:53

answered Nov 6, 2012 at 4:49

ravindra

1861 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sameer Over a year ago

its useful code me . but i have check cell space , @, #,like special characters in java

sameer Over a year ago

Now i have write code like that String[] dupcolumn = myRow.getcell(0); boolean dup =true; if(dup){for(int i=0 ; i<dupcolumn.length;i++){for(int j=i+1;j<dupcolumn .length;j++){if(dupcolumn [j]==dupcolumn [i]){System.out.println("Duplicate cell");}}} this code is correct .

Collectives™ on Stack Overflow

upload excel file validation in java

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related