【java源码】如何用java代码实现对excel的操作

利用java代码对excel读取：

package com;

import java.io.IOException;

public class ExcelReader {

	public static void main(String[] args) throws IOException {
		URL url=ClassLoader.getSystemResource("myexcel.xls");
		HSSFWorkbook HWB=new HSSFWorkbook(url.openStream());
		
		List<Object> list=null;
		int sheetCount=HWB.getNumberOfSheets();
		for(int i=0;i<sheetCount;i++){
			HSSFSheet sheet=HWB.getSheetAt(i);
			int rowCount=sheet.getPhysicalNumberOfRows();
			for(int j=0;j<rowCount;j++){
				HSSFRow row=sheet.getRow(j);
				int cellCount=row.getPhysicalNumberOfCells();
				list=new ArrayList<Object>();
				for(short k=0;k<cellCount;k++){
					HSSFCell cell=row.getCell(k);
					if(cell.getCellType()==HSSFCell.CELL_TYPE_STRING){
						list.add(cell.getStringCellValue());
					}else if(HSSFDateUtil.isCellDateFormatted(cell)){
						java.util.Date d=cell.getDateCellValue();
						list.add(new java.sql.Date(d.getTime()));
					}else{
						list.add(cell.getNumericCellValue());
					}
				}
				System.out.println(list);
			}
		}

	}

}

利用java代码将数据存入excel：

package com;

import java.io.FileNotFoundException;

public class ExcelWriter {

	public static void main(String[] args) {
		//创建工作薄
		HSSFWorkbook HWB=new HSSFWorkbook();
		//创建单元格的风格
		HSSFCellStyle cellStyle=HWB.createCellStyle();
		cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
		HSSFFont font=HWB.createFont();
		font.setColor(HSSFColor.RED.index);
		font.setFontHeightInPoints((short)16);
		cellStyle.setFont(font);
		
		//创建工作表
		HSSFSheet sheet=HWB.createSheet();
		sheet.setDefaultColumnWidth((short)12);
		HWB.setSheetName(0, "第一个表格",HWB.ENCODING_UTF_16);
		
		//创建行
		HSSFRow row=sheet.createRow(0);
		
		//创建单元格
		String[] strs={"李刚","赵云","曹操","诸葛亮","苍井空"};
		for(short i=0;i<strs.length;i++){
			HSSFCell cell=row.createCell(i);
			cell.setCellStyle(cellStyle);
			cell.setEncoding(HSSFCell.ENCODING_UTF_16);
			cell.setCellValue(strs[i]);
		}
		
		try {
			HWB.write(new FileOutputStream("person.xls"));
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		
	}

}