java向Excel固定单元格写入值

package com.test;

import java.io.FileInputStream;
import java.io.FileOutputStream;

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;

public class Tests {
	
	public static void main(String[] args) {
		String filePath = "d:\\test.xls";
		int x=2;//横向值,从1开始
		int y=2;//纵向值,从0开始
		String value="测试值";
		new Tests().test(filePath,x,y,value);
	}
	public void test(String filePath,int x,int y,String value) {
		try {
			// 创建Excel的工作书册 Workbook,对应到一个excel文档
			HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(filePath));
			HSSFSheet sheet=wb.getSheetAt(0);
			HSSFRow row=sheet.getRow(x);
			HSSFCell cell=row.getCell((short) y);
			cell.setCellValue(value);
			FileOutputStream os;
			os = new FileOutputStream(filePath);
			wb.write(os);
			os.close();
		} catch (Exception e) {
			e.printStackTrace();
		}

	}
}