jar包:
poi-3.8-20120326.jar
poi-examples-3.8-20120326.jar
poi-ooxml-3.8-20120326.jar
poi-ooxml-schemas-3.8-20120326.jar
dom4j-1.6.1.jar
stax-api-1.0.1.jar
xmlbeans-2.3.0.jar
commons-logging-1.1.jar
junit-3.8.1.jar
log4j-1.2.13.jar
官方下载地址:http://poi.apache.org/download.html
package com.ying.hss;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.text.SimpleDateFormat;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
public class ExcelImport {
public static void main(String[] args) {
FileInputStream in = null;
try {
File file = new File("my.xlsx");
in = new FileInputStream(file);
Workbook wb = WorkbookFactory.create(in);
Sheet sheet = wb.getSheetAt(0);
for (Row row : sheet) {
int i = row.getRowNum();
if (i == 0 || i == 1) {
continue;
}
for (Cell cell : row) {
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC: // 数字
Object value;
if (HSSFDateUtil.isCellDateFormatted(cell)) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
// 如果是date类型则 ,获取该cell的date值
value = sdf.format(HSSFDateUtil.getJavaDate(cell
.getNumericCellValue()));
} else { // 纯数字
value = Double.parseDouble(String.valueOf(cell
.getNumericCellValue()));
}
System.out.print(value + " ");
break;
case HSSFCell.CELL_TYPE_STRING: // 字符串
System.out.print(cell.getStringCellValue() + " ");
break;
case HSSFCell.CELL_TYPE_BOOLEAN: // Boolean
System.out.println(cell.getBooleanCellValue() + " ");
break;
case HSSFCell.CELL_TYPE_FORMULA: // 公式
System.out.print(cell.getCellFormula() + " ");
break;
case HSSFCell.CELL_TYPE_BLANK: // 空值
System.out.println(" ");
break;
case HSSFCell.CELL_TYPE_ERROR: // 故障
System.out.println(" ");
break;
default:
System.out.print("未知类型 ");
break;
}
}
System.out.println(" ");
}
} catch (Exception e) {
e.printStackTrace();
} finally {
if (in != null) {
try {
in.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
}
分享到:
相关推荐
poi excel poi excel poi excel poi excel poi excel poi excel poi excel poi excel
关于java EXCEL poi 合并后无法显示或无法设置边框问题 【本人亲测】 excel poi 新手! 坑了1.5天!
java导出excel POI jar包 java代码地址http://blog.csdn.net/awenluck/article/details/51488537
POI生成Excel POI读取Excel java操作Excel Servlet生成Excel web项目,包含含读取Excel与生成Excel方法
poi log4j excel poi log4j excel poi log4j excel poi log4j excel poi log4j excel poi log4j excel poi log4j excel
Excel poi 支持xls 和xlsx,支持03 和07 版表格,excel 通用工具类及使用参考
JAVA操作excel poi poi.jarJAVA操作excel poi poi.jarJAVA操作excel poi poi.jarJAVA操作excel poi poi.jar
excelpoi导出导入java.zip java的poi-excel 导出导入模型 将项目下载后,用idea的open打开,maven自动下包, 用浏览器地址栏访问一定的ip后,项目输出写出流,带特殊请求头部 ,浏览器会弹出一个下载框,点击确认...
java 控制Excel poi 3.1 java 控制Excel poi 3.1 java 控制Excel poi 3.1 java 控制Excel poi 3.1 java 控制Excel poi 3.1
提供java版excel的导入导出的功能.支持尸体的注解这个是源码!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
java excel poi合并单元格
1. poi-scratchpad-3.9-20121203.jar ; 2.poi-ooxml-schemas-3.9-20121203.jar; 3.poi-ooxml-3.9-20121203.jar; 4.poi-excelant-3.9-20121203.jar; 5.poi-examples-3.9-20121203.jar; 6.poi-3.9-20121203.jar.
poi基于模板导出excel,poi基于模板导出excelpoi,基于模板导出excel
using excel poi for rows copy.
excel poi3.6 excel poi3.6 excel poi3.6
Excel POI读取封装(文件+示范代码) package org.excel.service; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileWriter; import java.io.IOException; import java....
excel poi工具类 导入 导出 合并单元格 计算公式
excelPOI 代码 学习用
用Java导出页面内容为excel表格的jar包,包含使用方法
EXCEL POI jar包 提供java对microsoft文档的访问支持