当前位置:编程学习 > JAVA >>

POI Excel 设置单元格 缩小字体填充

各位大哥大姐大牛们,怎么实现POI操作Excel自动缩小字体填充呢?别的jar包支持也可以推荐一下,拜谢! excel POI jxl 缩小字体填充 --------------------编程问答-------------------- --------------------编程问答-------------------- 没人气啊!!! --------------------编程问答--------------------
package cn.hit;

import java.io.File;
import java.io.IOException;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class Jxl {
    public static void main(String[] args) {
        try {
            String testPathString = "F:\\Users\\sun\\Desktop\\New folder\\";
            WritableWorkbook workbook = Workbook.createWorkbook(new File(testPathString + "output.xls"));
            WritableSheet sheet = workbook.createSheet("First Sheet", 0);
            Label label = new Label(0, 2, "A label record");
            WritableCellFormat wcf = new WritableCellFormat();
            wcf.setShrinkToFit(true);
            label.setCellFormat(wcf);
            sheet.addCell(label); 
            workbook.write(); 
            workbook.close();
        } catch (IOException e) {
            e.printStackTrace();
        } catch (RowsExceededException e) {
            e.printStackTrace();
        } catch (WriteException e) {
            e.printStackTrace();
        }
    }
}
用jExcelApi就能设置,POI有还是没有呢??????
补充:Java ,  Java相关
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,