import java.util.Iterator; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; public class PoiHacks { // Fix of XSSFSheet.createRow(int index) public static Row createRow(Sheet sheet, int index) { Row row = sheet.getRow(index); if(row==null) return sheet.createRow(index); Iterator it = row.iterator(); while(it.hasNext()) { it.next(); it.remove(); } return row; } }
Iterator sheetInterator = new Itertor(); Set<Object> set = new HashSet(); while(sheetInterator.hasNext()) { Row myrow = (Row) obj.next(); Iterator rowIterator = myrow.iterator(); while(rowIterator.hasNext()) { Cell cell = (Cell) rowIterator.next(); String value = cell.getValue(); if(!set.add(value)){ // value has not been added to the set -> it is at least 2nd occurrence of this value } } }
public class TakingDataFromExcel { public static void main(String[] args) { try { FileInputStream x = new FileInputStream(new File("/Users/rajesh/Documents/rajesh.xls")); //Create Workbook instance holding reference to .xlsx file Workbook workbook = new HSSFWorkbook(x); //Get first/desired sheet from the workbook Sheet sheet = workbook.getSheetAt(0); //Iterate through each rows one by one for (Iterator<Row> iterator = sheet.iterator(); iterator.hasNext();) { Row row = (Row) iterator.next(); for (Iterator<Cell> iterator2 = row.iterator(); iterator2 .hasNext();) { Cell cell = (Cell) iterator2.next(); System.out.println(cell.getStringCellValue()); } } x.close(); } catch (Exception e) { e.printStackTrace(); } } }
FileInputStream ins = new FileInputStream(new File("/driver/dir/myfile.xls")); Workbook wb = new HSSFWorkbook(ins); for(int i=0; i< wb.getNumberOfSheets();i++){ Sheet sheet = wb.getSheetAt(i); if(sheet!=null){ Row row = sheet.getRow(0); Iterator<Cell> ct = row.iterator(); while(ct.hasNext()){ Cell cell = (Cell) ct.next(); if(cell!=null){ HSSFCellStyle hssfstyle = (HSSFCellStyle) cell.getCellStyle(); hssfstyle.setFillBackgroundColor(HSSFColor.YELLOW.index); hssfstyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); cell.setStyle(hssfstyle); } } } }
columnDataIterators.add(row == null ? Collections.emptyIterator() : row.iterator());
columnDataIterators.add(row == null ? Collections.emptyIterator() : row.iterator());
columnDataIterators.add(row == null ? Collections.emptyIterator() : row.iterator());
columnDataIterators.add(row == null ? Collections.emptyIterator() : row.iterator());
PeekingIterator<ColumnData> existingIter = Iterators.peekingIterator(existingBaseRow.iterator()); for (ColumnData mergedData : mergedBaseRow)
PeekingIterator<ColumnData> existingIter = Iterators.peekingIterator(existingBaseRow.iterator()); for (ColumnData mergedData : mergedBaseRow)
PeekingIterator<ColumnData> existingIter = Iterators.peekingIterator(existingBaseRow.iterator()); for (ColumnData mergedData : mergedBaseRow)