java读取Excel文件

 

package restart;

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

import java.io.FileInputStream;
import java.io.FileOutputStream;// code run against the jakarta-poi-1.5.0-FINAL-20020506.jar. 
import java.io.IOException;

public class Cls_Read_Write {
	static public void main(String[] args) throws Exception {
		// FileOutputStream fos = new FileOutputStream("c://scylla//java.xls");
		// HSSFWorkbook wb = new HSSFWorkbook();
		// HSSFSheet s = wb.createSheet();
		// wb.setSheetName(0, "first sheet");
		// HSSFRow row = s.createRow(0);
		// HSSFCell cell = row.createCell((short) 0);
		// cell.setCellValue("Hello! This message is generated from POI.");
		// wb.write(fos);
		// fos.close();

		POIFSFileSystem fs = null;
		HSSFWorkbook wb = null;
		try {
			fs = new POIFSFileSystem(new FileInputStream("c://scylla//java.xls"));
			wb = new HSSFWorkbook(fs);
		} catch (IOException e) {
			e.printStackTrace();
		}
		if(wb==null)
		{
			System.out.println("wb is null!");
			return;
		}
		else
		for (int numSheets = 0; numSheets < wb.getNumberOfSheets(); numSheets++) {
			if (null != wb.getSheetAt(numSheets)) {
				HSSFSheet sheet = wb.getSheetAt(numSheets);// 獲得一個sheet
				for (int rowNumOfSheet = 0; rowNumOfSheet <= sheet.getLastRowNum(); rowNumOfSheet++) {
					if (null != sheet.getRow(rowNumOfSheet)) {
						HSSFRow row = sheet.getRow(rowNumOfSheet);// 獲得一個行
						for (short cellNumOfRow = 0; cellNumOfRow < row.getLastCellNum(); cellNumOfRow++) {
							if (null != row.getCell(cellNumOfRow)) {
								HSSFCell cell = row.getCell(cellNumOfRow);// 獲得列值
								cell.setEncoding(HSSFCell.ENCODING_UTF_16);			
								if(cell.getCellType()==1){
									String msg = cell.getStringCellValue();
									System.out.print(msg + " ");
								}
								else if(cell.getCellType()==0){
									double msg = cell.getNumericCellValue();
									System.out.print(msg + " ");
								}				
								if (cellNumOfRow == row.getLastCellNum()-1) {
									System.out.println("");
								}
							}
						}
					}
				}
			}
		}
		// for (int numSheets = 0; numSheets <
		// wb.getNumberOfSheets();numSheets++) {
		// if (null != wb.getSheetAt(numSheets)) {
		// HSSFSheet aSheet = wb.getSheetAt(numSheets);// 獲得一個sheet
		// for (int rowNumOfSheet = 0; rowNumOfSheet <=
		// aSheet.getLastRowNum();rowNumOfSheet++) {
		// if (null != aSheet.getRow(rowNumOfSheet)) {
		// HSSFRow aRow = aSheet.getRow(rowNumOfSheet); // 獲得一個行
		// for (short cellNumOfRow = 0; cellNumOfRow <= aRow .getLastCellNum();
		// cellNumOfRow++) {
		// if (null != aRow.getCell(cellNumOfRow)) {
		// HSSFCell aCell = aRow.getCell(cellNumOfRow);// 獲得列值
		// content.append(aCell.getStringCellValue());
		// }
		// }
		// }
		// }
		// }
		// }
	}
}

package restart;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import java.io.FileOutputStream;

public class NewXls {

	public static String outputFile = "c:/junman/ gongye.xls";

	public static void main(String argv[]) {
		try {
			HSSFWorkbook workbook = new HSSFWorkbook();
			HSSFSheet sheet = workbook.createSheet();
			HSSFRow row = sheet.createRow((short) 0);
			HSSFCell cell = row.createCell((short) 0);
			cell.setCellType(HSSFCell.CELL_TYPE_STRING);
			cell.setCellValue("yestoday");
			FileOutputStream fOut = new FileOutputStream(outputFile);
			workbook.write(fOut);
			fOut.flush();
			fOut.close();
			System.out.println("文件生成...");
		} catch (Exception e) {
			System.out.println("已運行 xlCreate() : " + e);
		}
	}
}