1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
|
package dz.algerietelecom.portallte.mvc;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.springframework.web.servlet.view.document.AbstractExcelView;
import dz.algerietelecom.portallte.domain.SummaryModel;
public class ExcelBuilder extends AbstractExcelView {
@Override
protected void buildExcelDocument(Map<String, Object> model,
HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response)
throws Exception {
System.out.println("gggggggggggggggggggggggggg");
List<SummaryModel> resultat = (List<SummaryModel>) model.get("summary_resultat");
HSSFSheet sheet = workbook.createSheet("Employee Report");
sheet.setDefaultColumnWidth(30);
CellStyle style = workbook.createCellStyle();
Font font = workbook.createFont();
font.setFontName("Arial");
style.setFillForegroundColor(HSSFColor.BLUE.index);
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
font.setColor(HSSFColor.WHITE.index);
style.setFont(font);
HSSFRow header = sheet.createRow(0);
header.createCell(0).setCellValue("Pays Départ");
header.createCell(1).setCellValue("pays Destination");
header.createCell(2).setCellValue("Opérateur");
header.createCell(3).setCellValue("Appel");
header.createCell(3).setCellValue("Trafic");
header.createCell(3).setCellValue("Nature trafic");
header.createCell(3).setCellValue("Date");
header.createCell(3).setCellValue("Durée");
int counter = 1;
for (SummaryModel e : resultat) {
HSSFRow row = sheet.createRow(counter++);
row.createCell(0).setCellValue(e.getOriginal());
}
}
} |
Partager