Xls java表格的读取，写入，以及从读取到写入（自己写的，亲测可用）

package com.test;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

/**
 * 
 * @author comeonzeze 表格的工具类 可以读 可以写 可以从写的里面读到新的表格里
 *
 */
public class XlsUtil {

	public static void main(String[] args) {
		// 读xls
		// readExcel("f:/a.xls");

		// 写xls
		// writeExcel("f:/b.xls");

		// 从xls里面读写入一个新的xls
		// readAndwriteExcel("f:/a.xls","f:/c.xls");

	}

	public static void readAndwriteExcel(String frompath, String topath) {
		// 创建目标表格
		// *****************
		Workbook to_wb = new HSSFWorkbook();
		CreationHelper createHelper = to_wb.getCreationHelper();
		Sheet to_sheet = to_wb.createSheet("new sheet");
		// Row row1 = sheet.createRow(0);
		// row1.createCell(0).setCellValue("Id");
		// *****************

		try {
			// 读取源表
			InputStream inp = new FileInputStream(frompath);
			HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inp));
			for (Sheet sheet : wb) {
				int i = 0;
				int j = 0;
				for (Row row : sheet) {
					j = 0;
					Row to_row = to_sheet.createRow(i);
					for (Cell cell : row) {
						// 向目标表写入值
						to_row.createCell(j).setCellValue(cell.toString());
						j++;
						System.out.print(cell + "\t");
					}
					i++;
					System.out.println();
				}
			}
			// 创建目标表或者覆盖目标表
			try {
				OutputStream fileOut = new FileOutputStream(topath);
				to_wb.write(fileOut);
			} catch (Exception e) {
				e.printStackTrace();
			}

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

	/**
	 * 读取目标excel并输出到控制台
	 * 
	 * @param path
	 *            输入路径来源 f:/a.xls
	 */
	public static void readExcel(String path) {
		try {
			InputStream inp = new FileInputStream(path);
			HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inp));
			for (Sheet sheet : wb) {
				for (Row row : sheet) {
					for (Cell cell : row) {
						System.out.print(cell + "\t");
					}
					System.out.println();
				}
			}
			wb.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 
	 * @param path
	 *            输入存储路径 f:/b.xls
	 */
	public static void writeExcel(String path) {
		Workbook wb = new HSSFWorkbook();
		CreationHelper createHelper = wb.getCreationHelper();
		Sheet sheet = wb.createSheet("new sheet");
		Row row1 = sheet.createRow(0);
		row1.createCell(0).setCellValue("Id");
		row1.createCell(1).setCellValue("name");
		row1.createCell(2).setCellValue("score");
		Row row2 = sheet.createRow(1);
		row2.createCell(0).setCellValue("1");
		row2.createCell(1).setCellValue("张飞");
		row2.createCell(2).setCellValue("85");
		Row row3 = sheet.createRow(2);
		row3.createCell(0).setCellValue("2");
		row3.createCell(1).setCellValue("赵云");
		row3.createCell(2).setCellValue("90");
		try {
			OutputStream fileOut = new FileOutputStream(path);
			wb.write(fileOut);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}