use of org.apache.poi.hssf.usermodel.HSSFFont in project processdash by dtuma.
the class StyleCache method getStyle.
public HSSFCellStyle getStyle(StyleKey key) {
if (DEFAULT_STYLE.equals(key))
return null;
HSSFCellStyle style = styleCache.get(key);
if (style == null) {
style = xls.createCellStyle();
key.configure(style);
HSSFFont font = xls.createFont();
key.configure(font);
style.setFont(font);
styleCache.put(key, style);
}
return style;
}
use of org.apache.poi.hssf.usermodel.HSSFFont in project adempiere by adempiere.
the class SmjXlsReport method reportTable.
// titleTable
/**
* llena los datos del reporte - fill report data
* @param book
* @param data
* @param sheet
* @param fila
*/
public void reportTable(HSSFWorkbook book, LinkedList<ReportTO> data, HSSFSheet sheet, int fila) {
HSSFRow row;
// crea fuente - create font
HSSFFont font = book.createFont();
font.setFontHeightInPoints((short) 10);
font.setFontName(HSSFFont.FONT_ARIAL);
HSSFRichTextString text;
Iterator<ReportTO> itRep = data.iterator();
Boolean newRow = false;
sheet.setColumnWidth((short) 0, (short) (13 * 256));
sheet.setColumnWidth((short) 1, (short) (60 * 256));
for (int i = 2; i < (cols); i++) {
sheet.setColumnWidth((short) i, (short) (15 * 256));
}
//for
// estio celda - cell style
HSSFCellStyle cellStyle = book.createCellStyle();
HSSFCellStyle cellStyleD = book.createCellStyle();
HSSFCellStyle cellStyleN = book.createCellStyle();
while (itRep.hasNext()) {
short col = 0;
ReportTO rpt = itRep.next();
if (!newRow) {
cellStyle = book.createCellStyle();
cellStyleD = book.createCellStyle();
cellStyleN = book.createCellStyle();
}
//if
newRow = false;
if (rpt.getReportlinestyle() != null && rpt.getReportlinestyle().equals("T")) {
// Coloca titulo - put title
row = sheet.createRow(fila++);
HSSFFont fontT = book.createFont();
fontT.setFontHeightInPoints((short) 12);
fontT.setFontName(HSSFFont.FONT_ARIAL);
fontT.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
HSSFCellStyle cellStyleT = book.createCellStyle();
cellStyleT.setWrapText(true);
cellStyleT.setAlignment(HSSFCellStyle.ALIGN_CENTER);
cellStyleT.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);
cellStyleT.setFont(fontT);
Region region = new Region(fila - 1, (short) 0, fila - 1, endRegion);
sheet.addMergedRegion(region);
text = new HSSFRichTextString(rpt.getDescription());
HSSFCell cellT = row.createCell(col);
cellT.setCellStyle(cellStyleT);
cellT.setCellValue(text);
newRow = true;
} else if (rpt.getReportlinestyle() != null && rpt.getReportlinestyle().equals("L")) {
// coloca linea en el reporte - Put under line in the report
cellStyle.setWrapText(true);
cellStyle.setBorderTop(HSSFCellStyle.BORDER_MEDIUM);
cellStyle.setBottomBorderColor((short) 8);
cellStyleD.setWrapText(true);
cellStyleD.setBorderTop(HSSFCellStyle.BORDER_MEDIUM);
cellStyleD.setBottomBorderColor((short) 8);
cellStyleN.setWrapText(true);
cellStyleN.setBorderTop(HSSFCellStyle.BORDER_MEDIUM);
cellStyleN.setBottomBorderColor((short) 8);
newRow = true;
} else if (rpt.getReportlinestyle() != null && rpt.getReportlinestyle().equals("X")) {
// coloca linea de total - Put total line
cellStyle.setWrapText(true);
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);
cellStyle.setBorderTop(HSSFCellStyle.BORDER_MEDIUM);
cellStyle.setBottomBorderColor((short) 8);
newRow = true;
} else if (rpt.getReportlinestyle() != null && rpt.getReportlinestyle().equals("Z")) {
// coloca linea doble de total - Put total line doble
cellStyle.setWrapText(true);
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);
cellStyle.setBorderTop(HSSFCellStyle.BORDER_DOUBLE);
cellStyle.setBottomBorderColor((short) 8);
//--------------
row = sheet.createRow(fila++);
ReportTO rptD = new ReportTO();
putRow(cellStyle, cellStyleD, cellStyleN, sheet, row, fila, rptD);
cellStyle = book.createCellStyle();
newRow = true;
} else if (rpt.getReportlinestyle() != null && rpt.getReportlinestyle().equals("D")) {
// coloca liena de descripcion - put description line
cellStyleD.setWrapText(true);
cellStyleD.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);
cellStyleD.setBorderTop(HSSFCellStyle.BORDER_MEDIUM);
cellStyleD.setBottomBorderColor((short) 8);
newRow = true;
} else if (rpt.getReportlinestyle() != null && rpt.getReportlinestyle().equals("S")) {
// coloca linea en blanco - put empty line
row = sheet.createRow(fila++);
newRow = true;
} else if (rpt.getTablevel() != null && rpt.getTablevel() > 0) {
// coloca espacios a la izquierda para simular jeraquia - put
// left spaces to simulate hierarchy
row = sheet.createRow(fila++);
String jerarchy = "";
for (int i = 1; i <= rpt.getTablevel(); i++) {
jerarchy = jerarchy + " ";
}
//for
Region region = new Region(fila - 1, (short) 0, fila - 1, endRegion);
sheet.addMergedRegion(region);
text = new HSSFRichTextString(jerarchy + rpt.getDescription());
HSSFCell cellJ = row.createCell(col);
cellJ.setCellValue(text);
newRow = true;
} else {
row = sheet.createRow(fila++);
putRow(cellStyle, cellStyleD, cellStyleN, sheet, row, fila, rpt);
}
//else
}
// while itData
}
use of org.apache.poi.hssf.usermodel.HSSFFont in project adempiere by adempiere.
the class SmjXlsReport method generate.
public HSSFWorkbook generate(LinkedList<ReportTO> data, String[] generalTitle, String clientName, String clientNIT, String periodName, String currencyName, MReportColumn[] m_columns, String city, Integer logoId) {
int fila = 0;
HSSFRow row;
cols = m_columns.length + 2;
endRegion = (short) (cols - 1);
try {
// create workbook
HSSFWorkbook book = new HSSFWorkbook();
// crea hoja - create sheet
// Goodwill BF: Invalid sheet name
HSSFSheet sheet = book.createSheet(StringUtils.makePrefix(generalTitle[0]));
// crea fuente - Create Font
HSSFFont font = book.createFont();
font.setFontHeightInPoints((short) 13);
font.setFontName(HSSFFont.FONT_ARIAL);
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
// estio celda - cell style
HSSFCellStyle cellStyle = book.createCellStyle();
cellStyle.setWrapText(true);
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);
cellStyle.setFont(font);
// add logo
if (logoId > 0) {
MImage mimage = MImage.get(Env.getCtx(), logoId);
byte[] imageData = mimage.getData();
HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
HSSFClientAnchor anchor;
anchor = new HSSFClientAnchor(100, 50, 200, 255, (short) 0, 0, (short) 1, 1);
anchor.setAnchorType(2);
int pictureIndex = book.addPicture(imageData, HSSFWorkbook.PICTURE_TYPE_PNG);
patriarch.createPicture(anchor, pictureIndex);
for (int i = 0; i < 5; i++) row = sheet.createRow(fila++);
}
//if Logo report
// Titulo General - general Title
row = sheet.createRow(fila++);
HSSFRichTextString text = new HSSFRichTextString(generalTitle[0]);
HSSFCell cell = row.createCell((short) 0);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(text);
Region region = new Region(fila - 1, (short) 0, fila - 1, endRegion);
sheet.addMergedRegion(region);
// empresa - Company
row = sheet.createRow(fila++);
text = new HSSFRichTextString(clientName);
cell = row.createCell((short) 0);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(text);
region = new Region(fila - 1, (short) 0, fila - 1, endRegion);
sheet.addMergedRegion(region);
// Ciudad - City
row = sheet.createRow(fila++);
text = new HSSFRichTextString(city);
cell = row.createCell((short) 0);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(text);
region = new Region(fila - 1, (short) 0, fila - 1, endRegion);
sheet.addMergedRegion(region);
// NIT
row = sheet.createRow(fila++);
text = new HSSFRichTextString(clientNIT);
cell = row.createCell((short) 0);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(text);
region = new Region(fila - 1, (short) 0, fila - 1, endRegion);
sheet.addMergedRegion(region);
// periodo - Period
String pn = "";
if (generalTitle[1] != null && generalTitle[1].length() > 0) {
pn = generalTitle[1] + " " + periodName;
} else {
pn = periodName;
}
if (generalTitle[2] != null && generalTitle[2].length() > 0) {
pn = pn + " " + generalTitle[2];
}
row = sheet.createRow(fila++);
text = new HSSFRichTextString(pn);
cell = row.createCell((short) 0);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(text);
region = new Region(fila - 1, (short) 0, fila - 1, endRegion);
sheet.addMergedRegion(region);
// tipo moneda - currency
row = sheet.createRow(fila++);
text = new HSSFRichTextString(currencyName);
cell = row.createCell((short) 0);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(text);
region = new Region(fila - 1, (short) 0, fila - 1, endRegion);
sheet.addMergedRegion(region);
row = sheet.createRow(fila++);
titleTable(book, sheet, fila++, m_columns);
// llena datos del reporte - fill data report
reportTable(book, data, sheet, fila);
return book;
} catch (Exception e) {
e.printStackTrace();
return null;
}
//try/catch
}
use of org.apache.poi.hssf.usermodel.HSSFFont in project adempiere by adempiere.
the class SmjXlsReport method titleTable.
// generate
/**
* Crea la fila de titulos - create title row
* @param wb
* @param hs
* @param fila
* @param colsName
*/
private void titleTable(HSSFWorkbook book, HSSFSheet sheet, int fila, MReportColumn[] m_columns) {
short col = 0;
// crea fuente - create font
HSSFFont font = book.createFont();
font.setFontHeightInPoints((short) 13);
font.setFontName(HSSFFont.FONT_ARIAL);
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
// font.setColor(HSSFColor.BLUE.index);
// estio celda - cell style
HSSFCellStyle cellStyle = book.createCellStyle();
cellStyle.setWrapText(true);
cellStyle.setAlignment(HSSFCellStyle.ALIGN_JUSTIFY);
cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_TOP);
// cellStyle.setFillPattern(HSSFCellStyle.SPARSE_DOTS);
// cellStyle.setFillBackgroundColor(HSSFColor.GREY_40_PERCENT.index);
cellStyle.setFont(font);
// //Titulos de la tabla - Table titles
HSSFRow row = sheet.createRow(fila);
// Nombre - name
HSSFRichTextString text = new HSSFRichTextString(Msg.translate(Env.getCtx(), "name").toUpperCase());
HSSFCell cell = row.createCell(col++);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(text);
// Desripcion - description
text = new HSSFRichTextString(Msg.translate(Env.getCtx(), "description").toUpperCase());
cell = row.createCell(col++);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(text);
// columnas de valores - Value Columns
for (MReportColumn mcol : m_columns) {
String colName = mcol.getName();
text = new HSSFRichTextString(colName.toUpperCase());
cell = row.createCell(col++);
cell.setCellStyle(cellStyle);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(text);
}
//for columnas
}
use of org.apache.poi.hssf.usermodel.HSSFFont in project adempiere by adempiere.
the class AbstractExcelExporter method getFont.
private HSSFFont getFont(boolean isHeader) {
HSSFFont font = null;
if (isHeader) {
if (m_fontHeader == null) {
m_fontHeader = m_workbook.createFont();
m_fontHeader.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
}
font = m_fontHeader;
} else if (isFunctionRow()) {
font = m_workbook.createFont();
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
font.setItalic(true);
} else {
if (m_fontDefault == null) {
m_fontDefault = m_workbook.createFont();
}
font = m_fontDefault;
}
return font;
}
Aggregations