学步园

1.下载jar包：http://poi.apache.org/download.html

2.实例代码

import java.io.File;<br /> import java.io.FileNotFoundException;<br /> import java.io.FileOutputStream;<br /> import java.io.IOException;<br /> import javax.swing.JOptionPane;<br /> import org.apache.poi.hssf.usermodel.HSSFCell;<br /> import org.apache.poi.hssf.usermodel.HSSFRichTextString;<br /> import org.apache.poi.hssf.usermodel.HSSFRow;<br /> import org.apache.poi.hssf.usermodel.HSSFSheet;<br /> import org.apache.poi.hssf.usermodel.HSSFWorkbook;<br /> import org.junit.Test;<br /> public class TestPOI {<br /> @Test<br /> public void generateExcel(){<br /> HSSFWorkbook workbook = new HSSFWorkbook(); //产生工作簿对象<br /> HSSFSheet sheet = workbook.createSheet(); //产生工作表对象<br /> workbook.setSheetName(0, "test");//设置工作表位置和工作表名<br /> HSSFRow row=sheet.createRow(0);//生成一行<br /> HSSFCell cell = row.createCell((short) 0, HSSFCell.CELL_TYPE_STRING);//生成单元格，设定类型<br /> HSSFRichTextString text=new HSSFRichTextString("oh,好耶!");<br /> cell.setCellValue(text);<br /> FileOutputStream fOut = null;<br /> try {<br /> fOut = new FileOutputStream(new File("c:/test.xls"));<br /> } catch (FileNotFoundException e) {<br /> e.printStackTrace();<br /> }<br /> try {<br /> workbook.write(fOut);<br /> fOut.flush();<br /> fOut.close();<br /> } catch (IOException e) {<br /> e.printStackTrace();<br /> }<br /> JOptionPane.showMessageDialog(null,"导出数据成功！");<br /> }<br /> }<br />  

参考：http://www.360doc.com/content/10/0526/14/8667_29610917.shtml