java poi读取excel
来源:互联网 发布:csgo淘宝买钥匙 编辑:程序博客网 时间:2024/06/12 01:32
首先到poi的官网http://poi.apache.org/上下载最新版的poi包,目前最新版是3.9。
操作excel需要用到如下几个jar包:
然后在java工程中导入上述jar包。
代码如下:
import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.InputStream;import java.util.ArrayList;import java.util.Iterator;import java.util.List;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.DateUtil;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;public class Main {public static void main(String[] args) {InputStream in = null;Workbook wb = null;String path = "C:\\Users\\cht\\Desktop\\test.xlsx";try {in = new FileInputStream(path);if (path.endsWith(".xls"))wb = new HSSFWorkbook(in);if (path.endsWith(".xlsx"))wb = new XSSFWorkbook(in);int sheetNum = wb.getNumberOfSheets();if (sheetNum == 0)return;for (int i = 0; i < sheetNum; i++) {Sheet sheet = wb.getSheetAt(i);Iterator<Row> iterRow = sheet.rowIterator();while (iterRow.hasNext()) {Row row = iterRow.next();Iterator<Cell> iterCell = row.cellIterator();while (iterCell.hasNext()) {Cell cell = iterCell.next();System.out.println(getCellValue(cell));}}}} catch (FileNotFoundException fnfEx) {// throw fnfEx;} catch (IOException ioEx) {// throw ioEx;} finally {try {in.close();} catch (Exception ex) {}}}/** * 获取每个excel单元格的值 * * @param cell * 单元格 * @return 单元格的内容 */private static String getCellValue(Cell cell) {String val = null;switch (cell.getCellType()) {case Cell.CELL_TYPE_STRING:val = cell.getRichStringCellValue().getString();break;case Cell.CELL_TYPE_NUMERIC:if (DateUtil.isCellDateFormatted(cell)) {val = cell.getDateCellValue().toGMTString();} else {double d = cell.getNumericCellValue();val = String.valueOf(d);int index = val.indexOf(".");if (-1 != index) {val = val.substring(0, index);}}break;case Cell.CELL_TYPE_BOOLEAN:val = String.valueOf(cell.getBooleanCellValue());break;case Cell.CELL_TYPE_FORMULA:val = cell.getCellFormula();break;default:}return val;}}
- Java POI 读取Excel
- java poi读取excel
- java Excel 读取 poi
- Java POI 读取Excel
- java poi读取excel
- java poi 读取Excel
- java poi 读取excel
- Java读取Excel:POI
- java poi 读取Excel
- Java POI Excel读取
- java利用poi读取excel
- java poi 读取Excel demo
- java利用poi读取excel
- Java用poi读取excel
- java利用poi读取excel
- java-poi方式读取excel
- Java poi读取Excel表格
- java poi读取excel文件
- 用HTML5 Audio API开发游戏音乐
- 排序算法
- play framework2开发(五)
- 换个心境搞IT–在IT职场如何打拼?
- 2013年工作中遇到的20个问题:41-60
- java poi读取excel
- 新 m的注意事项
- How to Setup Public Key Use Globally on SecureCRT
- 用定时器进行PIE编码的另一种思考
- C语言中的常用的几种系统时间结构体类型
- wxWidgets,wxgtk,gtk有什么区别?
- mysql cluster集群安装全纪录
- 用eclipse调试android源代码
- hdu4534