Question

如何使用POI导出excel，求完整代码

Answer 1

导出？是读取吗？

追问

差不多，算是读取吧

追答

在c盘目录下建一个book1.xls，然后在B2输入一个数值，用下面的示例代码读取：

package demo.excel;

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;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class ExcelDemo {

/**
* @param args
*/
public static void main(String[] args) {
try{
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("C:/book1.xls"));
HSSFWorkbook book = new HSSFWorkbook(fs);

HSSFSheet sheet1 = book.getSheet("Sheet1");
HSSFRow row = sheet1.getRow(1);
HSSFCell cell = row.getCell((short) 1);
System.out.println(cell.getNumericCellValue());

}catch(Exception e){
e.printStackTrace();
}
}

}