java 操作表格选择_java 操作Excel表格 使用POI3.7

/**

* 创建Excel表格

*

* @param filename

*/

public static void createExecl(String filename) {

Workbook workbook = null;

// 产生工作簿对象

if (filename.endsWith(".xls")) {

workbook = new HSSFWorkbook();

} else {

workbook = new XSSFWorkbook();

}

// 产生工作表对象

Sheet sheet = workbook.createSheet("sheet one");

// 产生一行

Row row = sheet.createRow(0);

// 产生一个单元格

Cell cell = row.createCell(0);

// 设置单元格内容为字符串类型

// CELL_TYPE_BLANK

// CELL_TYPE_BOOLEAN

// CELL_TYPE_ERROR

// CELL_TYPE_FORMULA

// CELL_TYPE_NUMERIC

// CELL_TYPE_STRING

cell.setCellType(Cell.CELL_TYPE_STRING);

// 设置单元格内容

cell.setCellValue("序号");

cell = row.createCell(1);

cell.setCellType(Cell.CELL_TYPE_STRING);

cell.setCellValue("姓名");

cell = row.createCell(2);

cell.setCellType(Cell.CELL_TYPE_STRING);

cell.setCellValue("年龄");

cell = row.createCell(3);

cell.setCellType(Cell.CELL_TYPE_STRING);

cell.setCellValue("日期");

cell = row.createCell(4);

cell.setCellType(Cell.CELL_TYPE_STRING);

cell.setCellValue("简介");

for (int i = 0; i < 5; i++) {

row = sheet.createRow(i + 1);

cell = row.createCell(0);

cell.setCellType(Cell.CELL_TYPE_STRING);

cell.setCellValue("2012080300" + i);

cell = row.createCell(1);

cell.setCellType(Cell.CELL_TYPE_STRING);

cell.setCellValue("080300" + i);

cell = row.createCell(2);

cell.setCellType(Cell.CELL_TYPE_STRING);

cell.setCellValue("080300" + i);

cell = row.createCell(3);

cell.setCellType(Cell.CELL_TYPE_STRING);

cell.setCellValue(new Date());

cell = row.createCell(4);

cell.setCellType(Cell.CELL_TYPE_STRING);

cell.setCellValue("哈哈enemy哦凹阿拉" + i);

}

OutputStream outputStream = null;

try {

outputStream = new FileOutputStream(filename);

workbook.write(outputStream);

outputStream.flush();

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} finally {

if (outputStream != null) {

try {

outputStream.close();

} catch (IOException e) {

e.printStackTrace();

}

}

}

}

/**

* 读取Excel表格

*

* @param filename

*/

public static void readExcel(String filename) {

InputStream inputStream = null;

Workbook workbook = null;

Sheet sheet = null;

Row row = null;

Cell cell = null;

StringBuffer stringBuffer = new StringBuffer();

try {

inputStream = new FileInputStream(filename);

if (filename.endsWith(".xls")) {

workbook = new HSSFWorkbook(inputStream);

} else {

workbook = new XSSFWorkbook(inputStream);

}

for (int sheetIndex = 0, sheets = workbook.getNumberOfSheets(); sheetIndex < sheets; sheetIndex++) {

sheet = workbook.getSheetAt(sheetIndex);

if (null != sheet) {

stringBuffer.append(sheet.getSheetName() + "\n");

for (int rowIndex = 0, rows = sheet.getLastRowNum(); rowIndex <= rows; rowIndex++) {

row = sheet.getRow(rowIndex);

if (null != row) {

for (int cellnum = 0, cells = row.getLastCellNum(); cellnum < cells; cellnum++) {

cell = row.getCell(cellnum);

if (!(cell.getCellType() == Cell.CELL_TYPE_NUMERIC)

|| !(DateUtil.isCellDateFormatted(cell))) {

cell.setCellType(Cell.CELL_TYPE_STRING);

stringBuffer.append(cell

.getStringCellValue() + "\t");

} else {

Date date = cell.getDateCellValue();

stringBuffer.append(new SimpleDateFormat(

"HH:mm:ss").format(date) + "\t");

}

}

stringBuffer.append("\n");

}

}

stringBuffer.append("\n\n");

}

}

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} finally {

try {

inputStream.close();

} catch (IOException e) {

e.printStackTrace();

}

}

System.out.println(stringBuffer);

}