根据Excel单元格坐标修改单元格内的Value

package com.haier.demo.maven_web_demo.grid2.main;


import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFFont;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;


public class PoiTestOf2007 {
public static void main(String[] args) throws InterruptedException {
long startTime = System.currentTimeMillis(); // 获取开始时间
String currentIndex = "I47";
String one = null;


String two = null;
if (currentIndex.length() == 2) {
one = currentIndex.substring(0, 1);
two = currentIndex.substring(1, 2);
}
if (currentIndex.length() == 3) {
one = currentIndex.substring(0, 1);
two = currentIndex.substring(1, 3);
}
if (currentIndex.length() == 4) {
one = currentIndex.substring(0, 2);
two = currentIndex.substring(2, 4);
}


String[] arr = new String[] { "A", "B", "C", "D", "E", "F", "G", "H",
"I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T",
"U", "V", "W", "X", "Y", "Z", "AA", "AB", "AC", "AD", "AE",
"AF", "AG", "AH", "AI", "AJ", "AK", "AL", "AM", "AN", "AO",
"AP", "AQ", "AR", "AS", "AT", "AU", "AV", "AW", "AX", "AY",
"AZ" };
Map<String, Integer> map = new HashMap<String, Integer>();
int i = 0;
for (String string : arr) {
map.put(string, (++i));
}


int beginCell = map.get(one) - 1;
int beginRow = Integer.parseInt(two) - 1;
System.out.println(beginRow + "======" + beginCell);
String fileToBeRead = "e:/青岛小规模纳税人报表.xlsx"; // excel位置
XSSFWorkbook workbook;
// HSSFWorkbook workbook;
try {
workbook = new XSSFWorkbook(new FileInputStream(fileToBeRead));
XSSFSheet sheet = workbook.getSheet("Sheet1");
XSSFRow row = sheet.getRow(beginRow);


// 设置单元格样式
CellStyle style = workbook.createCellStyle();
style.setAlignment(XSSFCellStyle.ALIGN_RIGHT);


XSSFFont font = workbook.createFont();
font.setFontHeightInPoints((short) 8);
style.setFont(font);
// cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 居中
if (null == row) {
row = sheet.createRow(beginRow);
}
XSSFCell cell = row.getCell(beginCell);
System.out.println(cell);


if (null == cell) {
cell = row.createCell(beginCell);
}
// 向单元格中放入值
cell.setCellValue("8");
// 设置存入内容为字符串
cell.setCellType(XSSFCell.CELL_TYPE_STRING);
cell.setCellStyle(style);


FileOutputStream fileOut = new FileOutputStream(
"e:/青岛小规模纳税人报表.xlsx");
workbook.write(fileOut);
fileOut.close();
long endTime = System.currentTimeMillis(); // 获取结束时间
System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}