[code]

/**
?*
?*/
package org;

import java.io.FileOutputStream;

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;

/**
?* @author parable
?*
?*/
public class TestPoi {

??? /**
??? ?* @param args
??? ?*/
??? public static String outputFile = "D:/gongye.xls";

??? public static void main(String[] args) {
??? ??? // TODO Auto-generated method stub
??? ??? try {
??? ??? ??? // 創建新的Excel 工作簿
??? ??? ??? HSSFWorkbook workbook = new HSSFWorkbook();
??? ??? ??? // 在Excel工作簿中建一工作表，其名為缺省值
??? ??? ??? // 如要新建一名為"效益指標"的工作表，其語句為：
??? ??? ??? // HSSFSheet sheet = workbook.createSheet("效益指標");
??? ??? ??? HSSFSheet sheet = workbook.createSheet();
??? ??? ??? // 在索引0的位置創建行（最頂端的行）
??? ??? ??? HSSFRow row = sheet.createRow((short) 0);
??? ??? ??? // 在索引0的位置創建單元格（左上端）
??? ??? ??? HSSFCell cell = row.createCell((short) 0);
??? ??? ??? // 定義單元格為字符串類型???
??? ??? ??? cell.setEncoding(HSSFCell.ENCODING_UTF_16);
??? ??? ??? cell.setCellType(HSSFCell.CELL_TYPE_STRING);
??? ??? ??? // 在單元格中輸入一些內容
??? ??? ??? cell.setCellValue("青山不老");
??? ??? ??? // 新建一輸出文件流
??? ??? ??? FileOutputStream fOut = new FileOutputStream(outputFile);
??? ??? ??? // 把相應的Excel 工作簿存盤
??? ??? ??? workbook.write(fOut);
??? ??? ??? fOut.flush();
??? ??? ??? // 操作結束，關閉文件
??? ??? ??? fOut.close();
??? ??? ??? System.out.println("文件生成...");

??? ??? } catch (Exception e) {
??? ??? ??? System.out.println("已運行 xlCreate() : " + e);
??? ??? }

??? }

}
/**
?*
?*/
package org;

import java.io.FileInputStream;

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;

/**
?* @author parable
?*
?*/
public class TestReadPoi {

??? /**
??? ?* @param args
??? ?*/
??? /** Excel文件的存放位置。注意是正斜線 */
??? public static String fileToBeRead = "D:/gongye.xls";

??? public static void main(String[] args) {
??? ??? // TODO Auto-generated method stub
??? ??? try {
??? ??? ??? // 創建對Excel工作簿文件的引用
??? ??? ??? HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(fileToBeRead));
??? ??? ???
??? ??? ??? // 創建對工作表的引用。
??? ??? ??? // 本例是按名引用（讓我們假定那張表有著缺省名"Sheet1"）
??? ??? ??? HSSFSheet sheet = workbook.getSheetAt(0);//workbook.getSheet("Sheet0");
??? ??? ??? // 也可用getSheetAt(int index)按索引引用，
??? ??? ??? // 在Excel文檔中，第一張工作表的缺省索引是0，
??? ??? ??? // 其語句為：HSSFSheet sheet = workbook.getSheetAt(0);
??? ??? ??? // 讀取左上端單元
??? ??? ??? HSSFRow row = sheet.getRow(0);??? ??? ???
??? ??? ??? HSSFCell cell = row.getCell((short) 0);
??? ??? ??? // 輸出單元內容，cell.getStringCellValue()就是取所在單元的值
??? ??? ??? System.out.println("左上端單元是： " + cell.getStringCellValue());
??? ??? ??? HSSFSheet sheet1 = workbook.getSheetAt(1);
??? ??? ??? HSSFRow row1=sheet1.getRow(0);
??? ??? ??? HSSFCell cell1 = row1.getCell((short) 0);
??? ??? ??? System.out.println("左上端單元是： " + cell1.getStringCellValue());
??? ??? ???
??? ??? } catch (Exception e) {
??? ??? ??? System.out.println("已運行xlRead() : " + e);
??? ??? }
??? }

}
[/code]