JAVA 导出EXCEL DEMO

package qs.com;

import java.io.File;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class Java2ExcelAction2 {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		String path = "c:\\JAVA2EXCELDEMO.xls";
		try {

			WritableWorkbook wbook = Workbook.createWorkbook(new File(path));// 创建一个名字为JAVA2EXCELDEMO.xls的EXCEl文件，同样是全部修改

			WritableSheet wSheet = wbook.createSheet("第一页", 0);// 单页的名字
			WritableSheet wSheet2 = wbook.createSheet("第二页", 1);

			
			//
			wSheet.mergeCells(0, 0, 8, 0);// 单元格合并 （0,0）合并（8,0）

			
			//
			WritableFont wFont = new WritableFont(WritableFont.ARIAL, 10);//table样式
			
			WritableCellFormat wCellFormat = new WritableCellFormat(wFont);//tableCell样式
			
			 wCellFormat.setAlignment(jxl.format.Alignment.CENTRE);//水平方向居中
			 wCellFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//竖直方向居中
			 wCellFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);//边框设置
			 wCellFormat.setWrap(true);//自动换行

			 
			
			 //
			 
			wSheet.addCell(new Label(1, 1, "B2", wCellFormat));//往某个单元格加字符串
			
			wSheet.addCell(new Label(9, 2, "j3", wCellFormat));

			
			
			wbook.write();//写入
			wbook.close();//关闭，必须的
			

		} catch (Exception e) {//createWorkbook时会出异常，抛出
			// TODO: handle exception
			System.out.println(e.getMessage());
			e.printStackTrace();
		}

	}

}

要导入jxl.jar包