关于Excel的读写，网站空间，最大众的方式就是使用POI了。。。
现在越来越懒了，服务器空间，最近太忙了：
贴个代码：
* 使用POI读取EXCEL文件 java.io.File; 5 import java.io.FileInputStream; 6 import java.util.ArrayList; org.apache.poi.hssf.usermodel.HSSFCell; 9 import org.apache.poi.hssf.usermodel.HSSFRow;10 import org.apache.poi.hssf.usermodel.HSSFSheet;11 import org.apache.poi.hssf.usermodel.HSSFWorkbook; * Hanbin ReadExcel { args the command line argumentsmain(String[] args)throws Exception {23read(“d:\\demo.xls”);24 } ArrayList read(String fileName){27ArrayList list = new ArrayList();28String sql = “”;29try{30File f = new File(fileName);31FileInputStream fis = new FileInputStream(f);32HSSFWorkbook wbs = new HSSFWorkbook(fis);33HSSFSheet childSheet = wbs.getSheetAt(0);34System.out.println(“行数:” + childSheet.getLastRowNum());35for(int i = 4;i<childSheet.getLastRowNum();i++){36HSSFRow row = childSheet.getRow(i);37System.out.println(“列数:” + row.getPhysicalNumberOfCells());38if(null != row){39for(int k=1;k<row.getPhysicalNumberOfCells();k++){40 HSSFCell cell;41cell = row.getCell((short)k);list.add(getStringCellValue(cell) + “\t”);44 }45 }46 }47}catch(Exception e){48 e.printStackTrace();49 }50return list;51 }* 获取单元格数据内容为字符串类型的数据54 * cell Excel单元格 String 单元格数据内容 String getStringCellValue(HSSFCell cell) {59String strCell = “”;60switch (cell.getCellType()) {61case HSSFCell.CELL_TYPE_STRING:62strCell = cell.getStringCellValue();63break;64case HSSFCell.CELL_TYPE_NUMERIC:65strCell = String.valueOf(cell.getNumericCellValue());66break;67case HSSFCell.CELL_TYPE_BOOLEAN:68strCell = String.valueOf(cell.getBooleanCellValue());69break;70case HSSFCell.CELL_TYPE_BLANK:71strCell = “”;72break;73default:74strCell = “”;75break;76 }77if (strCell.equals(“”) || strCell == null) {78return “”;79 }80if (cell == null) {81return “”;82 }83return strCell;84 }85 }，服务器空间做自己的决定。然后准备好承担后果。
