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();
}

}
}