jxl的冻结窗口
先上设置表格的代码:
//OutputStream os = response.getOutputStream();
//WritableWorkbook excel = Workbook.createWorkbook(os);
WritableWorkbook excel= Workbook.createWorkbook(new File("绝对路径"+"文档名称"));//创建文档
WritableSheet ws = excel.createSheet("sheet1", 0);//创建sheet表
SheetSettings ss = ws.getSettings();//设置sheet表格式
ss.setHorizontalFreeze(2);//冻结前两行(本人测试,没有效果)
ss.setVerticalFreeze(2);//冻结前两行(这个能用)