Java导入导出Excel表格-优快云博客

本文链接：https://blog.youkuaiyun.com/bswangjian/article/details/6650886

本文介绍了一个Java程序示例，演示了如何使用JExcelAPI读取和写入Excel文件。示例代码展示了基本的读写操作，包括从Excel中读取指定行的数据和向Excel中写入简单的数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package house.data;

import java.io.File;
import java.io.IOException;

import jxl.*;
import jxl.read.biff.BiffException;
import jxl.write.*;
import jxl.write.biff.RowsExceededException;

public class ExcelHandler {

	/**
	 * @param args
	 * @throws IOException
	 * @throws BiffException
	 * @throws WriteException
	 * @throws RowsExceededException
	 */
	public static void main(String[] args) throws BiffException, IOException,
			RowsExceededException, WriteException {
		ExcelHandler eh = new ExcelHandler();
		eh.readFromExcel("C:\\HMSys\\导入数据\\房屋信息导入数据.xls");
		eh.writeIntoExcel("C:\\HMSys\\导入数据\\房屋信息导出数据.xls");
	}

	public void readFromExcel(String url) throws BiffException, IOException {
		Workbook workbook = Workbook.getWorkbook(new File(url));
		Sheet sheet = workbook.getSheet(0);
		Cell[] cells = sheet.getRow(5);
		for (int i = 0; i < cells.length; i++) {
			System.out.println(cells[i].getContents());
		}

		workbook.close();
	}

	public void writeIntoExcel(String url) throws IOException,
			RowsExceededException, WriteException {
		WritableWorkbook wb = Workbook.createWorkbook(new File(url));
		WritableSheet sheet = wb.createSheet("房屋信息", 0);
		Label label = new Label(0, 0, "姓名");
		sheet.addCell(label);
		label = new Label(0, 1, "吕富平");
		sheet.addCell(label);
		wb.write();
		wb.close();
	}
}

参考资料：
http://www.andykhan.com/jexcelapi/

http://lavasoft.blog.51cto.com/62575/174244

http://hi.baidu.com/luozhh/blog/item/e7f4a3fa9c5b5a9159ee90e2.html