Java之PDF及Excel

1.      PDF

使用iText.jar, 如果要显示中文/日文/韩文, 则需要iTextAsian.jar

网址: http://www.lowagie.com/iText/ 在tutorial中有很多范例

参考书: iText in Action 很不错, 推荐

Javadoc: http://www.1t3xt.info/api/

 

编程中一些小Tips:

             i.                显示日文/繁体中文

           BaseFont bfJapanese = BaseFont.createFont("HeiseiKakuGo-W5", "UniJIS-UCS2-HW-H", BaseFont.NOT_EMBEDDED); Font fontJapanese = new Font(bfJapanese, 9, Font.NORMAL); BaseFont bfChinese = BaseFont.createFont("MSung-Light", "UniCNS-UCS2-H", BaseFont.NOT_EMBEDDED); Font fontChinese = new Font(bfChinese, 9, Font.NORMAL); 

 

             ii.                同时显示繁体中文/英文

              BaseFont bfChinese = BaseFont.createFont("C:/WINDOWS/Fonts/mingliu.ttc,0", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); Font FontChinese = new Font(bfChinese, 8, Font.NORMAL);

           iii.                日期时间格式

               SimpleDateFormat df = new SimpleDateFormat("dd MMM yyyy"); Format printtime = new SimpleDateFormat("hh:mm:ss aaa"); 

            iv.                数字格式

                java.text.NumberFormat numberFormat = new DecimalFormat("#,##0.00");

         v.                插入图片

               Image logo = Image.getInstance("Logo.bmp"); cell = new PdfPCell(logo, true); cell.setHorizontalAlignment(Element.ALIGN_CENTER); cell.setVerticalAlignment(Element.ALIGN_MIDDLE); cell.setBorder(0); table.addCell(cell); 

 

2.      Excel

  使用jxl.jar (JExcelApi)

网址: http://jexcelapi.sourceforge.net/ FAQ不错

Tutorial: http://www.andykhan.com/jexcelapi/tutorial.html

Yahoo! Group: http://tech.groups.yahoo.com/group/JExcelApi/ 很多问题的答案都可以在这边找到

编程中一些小Tips:

i.                     插入图片

     String imageLogo = "Logo.PNG"; WritableImage image = new WritableImage(0, 0, 1, 7, new File(imageLogo)); 

ii.                     显示繁体中文/日文

     WritableFont fieldFont = new WritableFont(WritableFont.createFont("MSung-Light"), 11, WritableFont.BOLD, false, UnderlineStyle.SINGLE); fieldFormat = new WritableCellFormat(fieldFont); WritableFont fieldFont = new WritableFont(WritableFont.createFont("HeiseiKakuGo-W5"), 11, WritableFont.BOLD, false, UnderlineStyle.SINGLE); fieldFormat = new WritableCellFormat(fieldFont); 

iii.                     设置打印时fit to 1 page 及margin

     sheet = writeExcel.createSheet(sheetname, 0); sheet.setPageSetup(PageOrientation.LANDSCAPE, PaperSize.A4, 0.5, 0.5); sheet.getSettings().setFitToPages(true); sheet.getSettings().setFitWidth(1); sheet.getSettings().setFitHeight(1); SheetSettings sh = sheet.getSettings(); sh.setTopMargin(0.3); sh.setBottomMargin(0.3); sh.setLeftMargin(0.5); sh.setRightMargin(0.5); 

iv.                     设置auto fit column

     CellView cellView = new CellView(); cellView.setAutosize( true ); sheet.setColumnView( 0, cellView ); sheet.setColumnView( 1, cellView ); sheet.setColumnView( 2, cellView ); 

v.                     Formular计算total值, x为column no. y为row no.

     Formula subtotalCommission = new Formula(x, y, "SUM(N10:N" + k + ")", sumNumberFormat);

vi.                     定义数字、日期格式

    NumberFormat numberFormat = new NumberFormat("#,##0.00;(#,##0.00)"); DateFormat customDateFormat = new DateFormat("dd-MM-yyyy"); customDateFormat.setAlignment(Alignment.LEFT);