jxl设置第一行单元格格式

Question

jxl设置第一行单元格格式

WritableFont wf = new WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD);

WritableCellFormat wcf = new WritableCellFormat(wf);

CellView cv = new CellView();
cv.setAutosize(true);
cv.setSize(1*256);

cv.setFormat(wcf);
sheet.setRowView(0,cv);

设置了字体为粗体，但是没有显示效果，请教，谢谢

Answer 1

[quote]setColumnView是可以用，setRowView还是没效果[/quote]
是这样的

来个更诡异的
[code="java"]import java.io.*;

import jxl.*;
import jxl.write.*;

public class JxlTest {
public static void main(String[] args) {
WritableWorkbook book = null;
try {
book = Workbook.createWorkbook(new File("d:/test.xls"));// 创建文件
WritableSheet sheet = book.createSheet("test", 0);// 创建工作表

        WritableFont wf = new WritableFont(WritableFont.TAHOMA,10,WritableFont.BOLD); 
        WritableCellFormat wcf = new WritableCellFormat(wf); 

        CellView cv = new CellView(); 
        cv.setAutosize(true); 
        cv.setSize(1*256); 

        Label label = new Label(0, 1,"测试01");
        sheet.addCell(label);

        cv.setFormat(wcf); 
        sheet.setRowView(0,cv); 
        sheet.setColumnView(0,cv); 

System.out.println(sheet.getRowView(0).getFormat()); //!!有木有发现是null。。。

        book.write();// 写数据
        book.close();

    } catch (Exception e) {
        e.printStackTrace();
    } 
}

}[/code]
我之前给你发了jxl源码的链接，你看一下它的源码里setRowView和setColumnView的不同。。。个人觉得是jxl的问题

所以干脆给lable加上format吧
[code="java"]Label label = new Label(1, 1, "测试11", wcf);[/code]