java µ¼³öexcel·½·¨

µ½http://download.csdn.net/source/1781433ÏÂÔØjxl.jarÎļþ
/*TitleÊDZ£´æ³öÀ´µÄÎļþÃû£¬gbl_LastOpenPathÓÃÓڼǼÉϴδò¿ªµÄ·¾¶*/
public void ExportToExcel(JTable table, String Title){
File DefaultFile;
JFileChooser fc = new JFileChooser();
File file;
if(gbl_LastOpenPath!=null){
DefaultFile = new File(gbl_LastOpenPath+"/"+Title+".xls");
if(DefaultFile.exists()){
//fc.setSelectedFile(DefaultFile);
// fc.setCurrentDirectory(DefaultFile); //ÉèÖôò¿ªµÄĬÈÏ·¾¶
fc.setSelectedFile(DefaultFile);
}
}
if(gbl_LastOpenPath==null){
//String s = System.getProperty("user.dir");
fc.setSelectedFile(new File("c:/"+Title+".xls"));
}
int Selection = fc.showDialog(this, null);
fc.setVisible(true);
if(Selection==0){
file = fc.getSelectedFile();
gbl_LastOpenPath = file.getParent();
/*¿ªÊ¼µ¼³öÊý¾Ý*/
try {
WritableWorkbook book = Workbook.createWorkbook(file);
WritableSheet sheet=book.createSheet(Title,0); //¹¤×÷±íÃû³Æ
sheet.mergeCells(0,0,(table.getColumnCount()-1),0); //ºÏ²¢µÚÒ»ÐÐ
/*±íÍ·£º¼Ó´Ö*/
WritableFont CaptionFont = new WritableFont(WritableFont.ARIAL, 14,WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,Colour.BLACK);
/*±íÍ·£º¾ÓÖÐ*/
WritableCellFormat CatpionStyle = new WritableCellFormat(CaptionFont);
CatpionStyle.setAlignment(Alignment.CENTRE);
CatpionStyle.setVerticalAlignment(VerticalAlignment.CENTRE);
sheet.addCell(new Label(0,0,Title,CatpionStyle));
/*д±íÍ·*/
WritableFont TitleFont = new WritableFont(WritableFont.ARIAL, 10,WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,Colour.BLACK);
/*±íÍ·£º¾ÓÖÐ*