导出Excel通用方法代码,Java代码库,德仔网

代码语言
代码分类
【Java】导出Excel通用方法
作者:刘石法 / 发布于2012/10/22/ 692
<div>package oa.common.utils;</div>
import java.io.OutputStream;</div>
import java.util.List;</div>
import javax.servlet.http.HttpServletResponse;</div>
import org.apache.struts2.ServletActionContext;</div>
import java.lang.reflect.Field;</div>
<div></div>
import jxl.Workbook;</div>
import jxl.format.Alignment;</div>
import jxl.format.Border;</div>
import jxl.format.BorderLineStyle;</div>
import jxl.format.VerticalAlignment;</div>
import jxl.write.Label;</div>
import jxl.write.WritableCellFormat;</div>
import jxl.write.WritableFont;</div>
import jxl.write.WritableSheet;</div>
import jxl.write.WritableWorkbook;</div>
<div>/***</div>
<div>* @author lsf</div>
<div>*/</div>
<div>public class ExportExcel {</div>
<div>/***************************************************************************</div>
<div> * @param fileName EXCEL文件名称</div>
<div> * @param listTitle EXCEL文件第一行列标题集合</div>
<div> * @param listContent EXCEL文件正文数据集合</div>
<div> * @return</div>
<div> */</div>
<div>public final static String exportExcel(String fileName,String[] Title, List<Object> listContent) {</div>
<div> String result="系统提示：Excel文件导出成功！"; </div>
<div> // 以下开始输出到EXCEL</div>
<div> try {  </div>
<div> //定义输出流，以便打开保存对话框______________________begin</div>
<div> HttpServletResponse response=ServletActionContext.getResponse();</div>
<div> OutputStream os = response.getOutputStream();// 取得输出流   </div>
<div> response.reset();// 清空输出流   </div>
<div> response.setHeader("Content-disposition", "attachment; filename="+ new String(fileName.getBytes("GB2312"),"ISO8859-1"));</div>
<div>// 设定输出文件头   </div>
<div> response.setContentType("application/msexcel");// 定义输出类型  </div>
<div> //定义输出流，以便打开保存对话框_______________________end</div>
<div></div>
<div> /** **********创建工作簿************ */</div>
<div> WritableWorkbook workbook = Workbook.createWorkbook(os);</div>
<div></div>
<div> /** **********创建工作表************ */</div>
<div></div>
<div> WritableSheet sheet = workbook.createSheet("Sheet1", 0);</div>
<div></div>
<div> /** **********设置纵横打印（默认为纵打）、打印纸***************** */</div>
<div> jxl.SheetSettings sheetset = sheet.getSettings();</div>
<div> sheetset.setProtected(false);</div>
<div></div>
<div></div>
<div> /** ************设置单元格字体************** */</div>
<div> WritableFont NormalFont = new WritableFont(WritableFont.ARIAL, 10);</div>
<div> WritableFont BoldFont = new WritableFont(WritableFont.ARIAL, 10,WritableFont.BOLD);</div>
<div></div>
<div> /** ************以下设置三种单元格样式，灵活备用************ */</div>
<div> // 用于标题居中</div>
<div> WritableCellFormat wcf_center = new WritableCellFormat(BoldFont);</div>
<div> wcf_center.setBorder(Border.ALL, BorderLineStyle.THIN); // 线条</div>
<div> wcf_center.setVerticalAlignment(VerticalAlignment.CENTRE); // 文字垂直对齐</div>
<div> wcf_center.setAlignment(Alignment.CENTRE); // 文字水平对齐</div>
<div> wcf_center.setWrap(false); // 文字是否换行</div>
<div> </div>
<div> // 用于正文居左</div>
<div> WritableCellFormat wcf_left = new WritableCellFormat(NormalFont);</div>
<div> wcf_left.setBorder(Border.NONE, BorderLineStyle.THIN); // 线条</div>
<div> wcf_left.setVerticalAlignment(VerticalAlignment.CENTRE); // 文字垂直对齐</div>
<div> wcf_left.setAlignment(Alignment.LEFT); // 文字水平对齐</div>
<div> wcf_left.setWrap(false); // 文字是否换行 </div>
<div></div>
<div></div>
<div> /** ***************以下是EXCEL开头大标题，暂时省略********************* */</div>
<div> //sheet.mergeCells(0, 0, colWidth, 0);</div>
<div> //sheet.addCell(new Label(0, 0, "XX报表", wcf_center));</div>
<div> /** ***************以下是EXCEL第一行列标题********************* */</div>
<div> for (int i = 0; i < Title.length; i++) {</div>
<div>  sheet.addCell(new Label(i, 0,Title[i],wcf_center));</div>
<div> } </div>
<div> /** ***************以下是EXCEL正文数据********************* */</div>
<div> Field[] fields=null;</div>
<div> int i=1;</div>
<div> for(Object obj:listContent){</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>  fields=obj.getClass().getDeclaredFields();</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>  int j=0;</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>  for(Field v:fields){</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>  v.setAccessible(true);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>  Object va=v.get(obj);</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>  if(va==null){</div>
<div><span class="Apple-tab-span" style="white-space:pre">			</span>  va="";</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>  }
<div><span class="Apple-tab-span" style="white-space:pre">		</span>  sheet.addCell(new Label(j, i,va.toString(),wcf_left));</div>
<div><span class="Apple-tab-span" style="white-space:pre">		</span>  j++;</div>
<div><span class="Apple-tab-span" style="white-space:pre">	</span>  }
<div><span class="Apple-tab-span" style="white-space:pre">	</span>  i++;</div>
<div> }
<div> /** **********将以上缓存中的内容写到EXCEL文件中******** */</div>
<div> workbook.write();</div>
<div> /** *********关闭文件************* */</div>
<div> workbook.close(); </div>
<div></div>
<div> } catch (Exception e) {</div>
<div> result="系统提示：Excel文件导出失败，原因："+ e.toString();</div>
<div> System.out.println(result);</div>
<div> e.printStackTrace();</div>
<div> }
<div> return result;</div>
<div>}
<div>}
试试其它关键字
　导出Excel通用方法　
同语言下
可能有用的
刘石法贡献的其它代码(3)