excelsample6.java

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

package cn.com.chengang.myplugin.poi;

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

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.Region;

public class ExcelSample6 {
	public static void main(String[] args) throws IOException {
		HSSFWorkbook wb = new HSSFWorkbook();
		HSSFSheet sheet = wb.createSheet("new sheet");
		HSSFRow row = sheet.createRow((short) 1);
		// 将单元格从第2行第2列合并到第3行第5列
		HSSFCell cell = row.createCell((short) 1);
		cell.setCellValue("Hello World");
		sheet.addMergedRegion(new Region(1, (short) 3, 2, (short) 4));
		// 写入文件
		FileOutputStream fileOut = new FileOutputStream("c:\\workbook.xls");
		wb.write(fileOut);
		fileOut.close();
	}
}