JAVA 读Excel 表格中的数据.
import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.text.SimpleDateFormat;import java.util.Date;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 ImportExcel {public static void main(String[] args) {String filePath = "E:\\kemu.xls";File myFile = new File(filePath);String strAdd = "";try {FileInputStream fis = new FileInputStream(myFile);HSSFWorkbook workbook;workbook = new HSSFWorkbook(fis);HSSFSheet sheet = null;HSSFRow row = null;HSSFCell cell = null;SimpleDateFormat sdf1 = new SimpleDateFormat("yyyyMMdd");String strPrefix = sdf1.format(new Date());if (workbook != null) {sheet = workbook.getSheetAt(0);}if (sheet == null) {System.out.println("不能导入空的Excel文件！");}if (sheet != null) {row = sheet.getRow(5);// 从第五行开始读取}for (int j = 5; row != null; j++, row = sheet.getRow(j)) {strAdd = "";for (int index = 1; index <= 10; index++) {cell = row.getCell((short) (index - 1));if (cell != null) {if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {strAdd = cell.getStringCellValue();}else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {strAdd = String.valueOf(cell.getNumericCellValue());}else if (cell.getCellType() == HSSFCell.CELL_TYPE_BLANK) {strAdd = "";}}System.out.println(strAdd);}}} catch (FileNotFoundException e) {e.printStackTrace();}catch( IOException ie ){ie.printStackTrace();}}}
页:
[1]