flex datagrid 数据导出

 //alarmLogExport.action

 /**
  * 日志导出
  *
  */
 @SuppressWarnings("unchecked")
 public String alarmLogExport() throws IOException {
  
    
    try {

  // AlarmLog 是model

//数据库查询数据放到List
List<AlarmLog>   list = alarmLogService.getAlarmLogList(beginTime, endTime,alarmMode, result);
   } catch (Exception e1) {

   }

   response = (HttpServletResponse) ServletActionContext.getResponse();
   OutputStream os = null;
   try {
    os = response.getOutputStream();
   } catch (IOException e) {

   }
   response.reset();
   response.setHeader("Content-disposition", "p_w_upload; filename="
    + "alarmLog.xls");
   response.setContentType("application/msexcel");
   LogExport  excelExport = new LogExport();
   inputStream = excelExport.exportAlarmLog(list, os);
   return SUCCESS;
 }

 

 

 

//工具类

//LogExport.java

import java.io.ByteArrayInputStream;

import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.model. AlarmLog;

public class LogExport {

 //警报日志AlarmLog
 public InputStream exportAlarmLog(List<AlarmLog> alarmLog, OutputStream os) throws IOException {
  

  //SimpleDateFormat df=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  //创建excel
  HSSFWorkbook hwb = new HSSFWorkbook();
  int k = 1;

//创建sheet页
  HSSFSheet sheet = hwb.createSheet("警报日志" + k);
  k++;

//创建标题行
  HSSFRow row1 = sheet.createRow(0);
  row1.createCell(0).setCellValue(new HSSFRichTextString("通知的用户名"));
  row1.createCell(1).setCellValue(new HSSFRichTextString("通知的用户组织"));
  row1.createCell(2).setCellValue(new HSSFRichTextString("通知的用户邮箱"));
  row1.createCell(3).setCellValue(new HSSFRichTextString("通知的用户电话"));
  row1.createCell(4).setCellValue(new HSSFRichTextString("警报通知时间"));
  row1.createCell(5).setCellValue(new HSSFRichTextString("警报内容"));
  
  int row = 0;
  for (int i = 0; i < alarmLog.size(); i++) {
   if (i > 0 && i % 10000 == 0) {
    sheet = hwb.createSheet("警报日志" + k); // 建立新的BirthSheet对象
    k++;
    row1.createCell(0).setCellValue(new HSSFRichTextString("通知的用户名"));
    row1.createCell(1).setCellValue(new HSSFRichTextString("通知的用户组织"));
    row1.createCell(2).setCellValue(new HSSFRichTextString("通知的用户邮箱"));
    row1.createCell(3).setCellValue(new HSSFRichTextString("通知的用户电话"));
    row1.createCell(4).setCellValue(new HSSFRichTextString("警报通知时间"));
    row1.createCell(5).setCellValue(new HSSFRichTextString("警报内容"));
   }
   HSSFRow row2 = sheet.createRow((row % 10000) + 1);// 创建表格的行
   row2.createCell(0).setCellValue(new HSSFRichTextString(alarmLog.get(i).getUserName()));
   row2.createCell(1).setCellValue(new HSSFRichTextString(alarmLog.get(i).getUserDepart()));
   row2.createCell(2).setCellValue(new HSSFRichTextString(alarmLog.get(i).getUserEmail()));
   row2.createCell(3).setCellValue(new HSSFRichTextString(alarmLog.get(i).getUserTelephone()));
   row2.createCell(4).setCellValue(new HSSFRichTextString(df.format(alarmLog.get(i).getAlarmTime())));
   row2.createCell(5).setCellValue(new HSSFRichTextString(alarmLog.get(i).getAlarmContent()));
   row++;
  }
  try {
   hwb.write(os);
   os.flush();
   return new ByteArrayInputStream(hwb.getBytes());
  } catch (IOException e) {

   return null;
  }
 }

 

}

 

到此就成功导出了。