package utils;

import java.util.List;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Workbook;

import com.nxdcms.entity.Subcompetition;

public class Excelutils {

public static void export(List<Subcompetition> list,Workbook wb){

int rowIndex=0;

org.apache.poi.ss.usermodel.Sheet sheet = wb.createSheet();

java.util.Iterator<Subcompetition> it = list.iterator();

org.apache.poi.ss.usermodel.Row row;

while (it.hasNext()) {

row=sheet.createRow(rowIndex++);

Cell cell=row.createCell(0);

Subcompetition subcompetition = it.next();

//System.out.println(subcompetition.getId());

cell.setCellValue(subcompetition.getCollege());

cell=row.createCell(1);

cell.setCellValue(subcompetition.getSubcompid());

}

}

}