当前位置:软件学习 > Excel >>

JAVA 导出EXCEL DEMO

[java] 
package qs.com; 
 
import java.io.File; 
 
import jxl.Workbook; 
import jxl.write.Label; 
import jxl.write.WritableCellFormat; 
import jxl.write.WritableFont; 
import jxl.write.WritableSheet; 
import jxl.write.WritableWorkbook; 
 
public class Java2ExcelAction2 { 
 
    /**
     * @param args
     */ 
    public static void main(String[] args) { 
        // TODO Auto-generated method stub 
 
        String path = "c:\\JAVA2EXCELDEMO.xls"; 
        try { 
 
            WritableWorkbook wbook = Workbook.createWorkbook(new File(path));// 创建一个名字为JAVA2EXCELDEMO.xls的EXCEl文件,同样是全部修改 
 
            WritableSheet wSheet = wbook.createSheet("第一页", 0);// 单页的名字 
            WritableSheet wSheet2 = wbook.createSheet("第二页", 1); 
 
             
            // 
            wSheet.mergeCells(0, 0, 8, 0);// 单元格合并 (0,0)合并(8,0) 
 
             
            // 
            WritableFont wFont = new WritableFont(WritableFont.ARIAL, 10);//table样式 
             
            WritableCellFormat wCellFormat = new WritableCellFormat(wFont);//tableCell样式 
             
             wCellFormat.setAlignment(jxl.format.Alignment.CENTRE);//水平方向居中 
             wCellFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//竖直方向居中 
             wCellFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);//边框设置 
             wCellFormat.setWrap(true);//自动换行 
 
              
             
             // 
              
            wSheet.addCell(new Label(1, 1, "B2", wCellFormat));//往某个单元格加字符串 
             
            wSheet.addCell(new Label(9, 2, "j3", wCellFormat)); 
 
             
             
            wbook.write();//写入 www.zzzyk.com
            wbook.close();//关闭,必须的 
             
 
        } catch (Exception e) {//createWorkbook时会出异常,抛出 
            // TODO: handle exception 
            System.out.println(e.getMessage()); 
            e.printStackTrace(); 
        } 
 
    } 
 
补充:软件开发 , Java ,
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,