package br.mia.test.util;

 import java.io.File;

 import java.io.FileOutputStream;

 import java.io.IOException;

 import java.util.ArrayList;

 import org.apache.poi.hssf.usermodel.HSSFRow;

 import org.apache.poi.hssf.usermodel.HSSFSheet;

 import org.apache.poi.hssf.usermodel.HSSFWorkbook;

 import br.mia.test.model.CasoUso;

 import br.mia.test.testcase.CasosTeste;

 public class GeraExcel

 {

     public static void geraExcel(ArrayList<CasosTeste> casoTeste,

             CasoUso useCase) throws IOException {

         HSSFWorkbook wb = new HSSFWorkbook();

         File[] files = Util.getFiles();

         FileOutputStream stream = new FileOutputStream(files[0]

                 .getAbsolutePath());

         HSSFSheet sheet1 = wb.createSheet("Planilha de Cen�rios");

         short i = 0;

         for (CasosTeste casosTeste : casoTeste) {

             HSSFRow row = sheet1.createRow((short) i);

             i ++;

             row.createCell((short) 0).setCellValue(useCase.getName());

             row.createCell((short) 1).setCellValue(casosTeste.getDescricao());

             row.createCell((short) 2).setCellValue(casosTeste.getNome());

             row.createCell((short) 3).setCellValue(casosTeste.getEntradas());

             row.createCell((short) 4).setCellValue(

                     casosTeste.getSaidasEsperadas());

         }

         wb.write(stream);

     }

 }