Hii Guys !! Below is my code to export database into excel file .Now as per my requirement i want to add header image of company at the top of the page .plz guys help me and guide me to complete the task.thanks in advance .below is my code...
Document document = new Document(PageSize.A2);
PdfWriter.getInstance(document, new FileOutputStream("d:/".concat(datum1).concat(" ").concat("To").concat(" ").concat(datum2).concat(".pdf")));
document.open();
Image logo = Image.getInstance("d:/header.png");
logo.setAlignment(Image.MIDDLE);
logo.scaleAbsoluteHeight(20);
logo.scaleAbsoluteWidth(20);
logo.scalePercent(100);
Chunk chunk = new Chunk(logo, 0, -45);
HeaderFooter header = new HeaderFooter(new Phrase(chunk), false);
header.setAlignment(Element.ALIGN_CENTER);
header.setBorder(Rectangle.NO_BORDER);
document.setHeader(header);
PdfPTable table = new PdfPTable(9);
table.setWidthPercentage(110);
table.addCell("calldate");
table.addCell("src");
table.addCell("dst");
table.addCell("dstchannel");
table.addCell("lastapp");
table.addCell("duration");
table.addCell("disposition");
table.addCell("amaflags");
table.addCell("cdrcost");
String strQuery = "";
ResultSet rs = null;
conexion conexiondb = new conexion();
conexiondb.Conectar();
strQuery = "SELECT * FROM cdrcost where date(calldate) between '" + datum1 + "' and '" + datum2 + "'";
// strQuery = "SELECT * FROM cdrcost where date(calldate) between '2011-09-01' and '2012-01-01'";
rs = conexiondb.Consulta(strQuery);
while (rs.next()) {
table.addCell(rs.getString("calldate"));
table.addCell(rs.getString("src"));
table.addCell(rs.getString("dst"));
table.addCell(rs.getString("dstchannel"));
table.addCell(rs.getString("lastapp"));
table.addCell(rs.getString("duration"));
table.addCell(rs.getString("disposition"));
table.addCell(rs.getString("amaflags"));
table.addCell(rs.getString("cdrcost"));
}
document.add(table);
document.close();