excelsample9.java

来自「此源码程序实现的是eclipse开发工具中插件的开发实现参考程序」· Java 代码 · 共 30 行

package cn.com.chengang.myplugin.poi;

import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ExcelSample9 {
	public static void main(String[] args) throws IOException {
		HSSFWorkbook wb = new HSSFWorkbook();
		// 冻结第一行
		HSSFSheet sheet1 = wb.createSheet("sheet1");
		sheet1.createFreezePane(0, 1, 0, 1);
		// 冻结第一列
		HSSFSheet sheet2 = wb.createSheet("sheet2");
		sheet2.createFreezePane(1, 0, 1, 0);
		// 冻结前两列，及前三行
		HSSFSheet sheet3 = wb.createSheet("sheet3");
		sheet3.createFreezePane(2, 3);
		// 列宽1000/20像素，行宽2000/20像素。PANE_UPPER_RIGHT指焦点停在上方右边的窗口
		sheet3 = wb.createSheet("sheet4");
		sheet3.createSplitPane(1000, 2000, 0, 0, HSSFSheet.PANE_UPPER_RIGHT);
		// 写入文件
		FileOutputStream fileOut = new FileOutputStream("workbook.xls");
		wb.write(fileOut);
		fileOut.close();
	}
}