java poi 导出excel 导出文本文件 工具类（以流的方式）

添加poi的依赖及其他依赖。工具类如下：

import org.apache.commons.lang.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.io.BufferedWriter;
import java.io.IOException;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.lang.reflect.Field;
import java.util.List;
import java.util.Map;
/**
* excel导出工具类
*/
public class ExcelWriteUtil {
private static Logger log = LoggerFactory.getLogger(ExcelWriteUtil.class);
/**
* 导出
* @param title 标题集合
* @param fields 字段集合
* @param data 数据 支持List<Map<String, Object>>
List<Class>
* @param fileName 文件名
* @param type 文件类型
* @param response response
* @throws Exception
*/
public static void writeExcel(List<String> title, List<String> fields, List<Object> data, String fileName, String type, HttpServletResponse response){
if (data == null || fields == null) {
return;
}
// 文件名为空，则默认为exportData
if (StringUtils.isEmpty(fileName)){
fileName = "exportData";
}
// 文件类型为空，则默认csv
if (StringUtils.isEmpty(type)){
type = "csv";
}
// 处理xls
if ("xls".equals(type)) {
writeExcel2003(title, fields, data, fileName, response);
}
// 处理xlsx
else if ("xlsx".equals(type)) {
writeExcel2007(title, fields, data, fileName, response);
}
// 处理csv
else if ("csv".equals(type)) {
writeCSV(title, fields, data, fileName, type, response);
}
// 处理txt
else if ("txt".equals(type)) {
writeCSV(title, fields, data, fileName, type, response);
}
else {
log.error("导出格式不支持");
return;
}
}
/**
* 导出文件
* @param titles
* @param fields
* @param data
* @param fileName
* @param type
* @param response
* @throws IOException
*/
public static void writeCSV( List<String> titles, List<String> fields, List<Object> data, String fileName, String type, HttpServletResponse response) {
OutputStream out = null;
OutputStreamWriter outputStreamWriter = null;
BufferedWriter bufferedWriter = null;
try {
response.setContentType("application/" + type + ";charset=utf-8");
response.setHeader("Content-Disposition", "attachment; filename="+ fileName +"." + type);
out = response.getOutputStream();
outputStreamWriter = new OutputStreamWriter(out, "utf-8");
bufferedWriter = new BufferedWriter(outputStreamWriter);
// 写入标题
if (titles != null){
for(String title : titles){
bufferedWriter.write(title);
bufferedWriter.write(",");
}
// 换行
bufferedWriter.write("rn");
}
// 写内容
if (data != null){
Field[] classFields = new Field[0];
for(Object obj : data){
if (obj instanceof Map){
Map<String, Object> map = (Map<String, Object>) obj;
for(String field : fields){
bufferedWriter.write(map.get(field).toString());
bufferedWriter.write(",");
}
//写完一行换行
bufferedWriter.write("rn");
}else {
//利用反射获取所有字段
if (classFields == null || classFields.length == 0){
classFields = obj.getClass().getDeclaredFields();
}
for(String field : fields){
for(Field classField : classFields){
//设置字段可见性
classField.setAccessible(true);
if(field.equals(classField.getName())){
bufferedWriter.write(classField.get(obj).toString());
bufferedWriter.write(",");
}
}
}
//换行
bufferedWriter.write("rn");
}
}
}
bufferedWriter.flush();
} catch (IOException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} finally {
try {
bufferedWriter.close();
outputStreamWriter.close();
out.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
/**
* 导出2003
* @param title
* @param fields
* @param data
* @param fileName
* @param response
*/
@SuppressWarnings({"all"})
public static void writeExcel2003(List<String> title, List<String> fields, List<Object> data, String fileName, HttpServletResponse response){
HSSFWorkbook workbook = null;
OutputStream output = null;
try {
workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet(fileName);
int hasTitle = 0;
// 写入标题
if (title != null){
HSSFRow row = sheet.createRow(0);
for (int i = 0; i < title.size(); i++) {
HSSFCell cell = row.createCell(i);
cell.setCellValue(title.get(i));
}
hasTitle += 1;
}
// 写入正文
if (data != null){
int rowSize = data.size();
Field[] classFields = new Field[0];
for (int rowNum = 0; rowNum < rowSize; rowNum++) {
HSSFRow row = sheet.createRow(rowNum + hasTitle);
Object obj = data.get(rowNum);
if (obj instanceof Map){
int fieldsSize = fields.size();
Map<String, Object> map = (Map<String, Object>) obj;
if (map != null){
for (int colCell = 0; colCell < fieldsSize; colCell++) {
HSSFCell cell = row.createCell(colCell);
cell.setCellValue(map.get(fields.get(colCell)).toString());
}
}
}else {
//利用反射获取所有字段
if (classFields == null || classFields.length == 0){
classFields = obj.getClass().getDeclaredFields();
}
int colCell = 0;
for(String field : fields){
for(Field classField : classFields){
//设置字段可见性
classField.setAccessible(true);
if(field.equals(classField.getName())){
HSSFCell cell = row.createCell(colCell);
cell.setCellValue(classField.get(obj).toString());
colCell ++;
}
}
}
}
}
}
response.setHeader("Content-Disposition", "attachment;filename="+fileName+".xls");
response.setContentType("application/vnd.ms-excel;");
output = response.getOutputStream();
workbook.write(output);
output.flush();
} catch (Exception e) {
e.printStackTrace();
}finally {
try {
if (workbook != null){
workbook.close();
}
if (output != null){
output.close();
}
} catch (IOException e) {
e.printStackTrace();
}
}
}
/**
*
* @param title
* @param fields
* @param data
* @param fileName
* @param response
*/
@SuppressWarnings({"all"})
public static void writeExcel2007(List<String> title, List<String> fields, List<Object> data, String fileName, HttpServletResponse response){
XSSFWorkbook workbook = null;
OutputStream output = null;
try {
workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet(fileName);
int hasTitle = 0;
// 写入标题
if (title != null){
XSSFRow row = sheet.createRow(0);
for (int i = 0; i < title.size(); i++) {
XSSFCell cell = row.createCell(i);
cell.setCellValue(title.get(i));
}
hasTitle += 1;
}
// 写入正文
int rowSize = data.size();
Field[] classFields = new Field[0];
for (int rowNum = 0; rowNum < rowSize; rowNum++) {
XSSFRow row = sheet.createRow(rowNum + hasTitle);
Object obj = data.get(rowNum);
if (obj instanceof Map){
int fieldsSize = fields.size();
Map<String, Object> map = (Map<String, Object>) obj;
if (map != null){
for (int colCell = 0; colCell < fieldsSize; colCell++) {
XSSFCell cell = row.createCell(colCell);
cell.setCellValue(map.get(fields.get(colCell)).toString());
}
}
}else {
//利用反射获取所有字段
if (classFields == null || classFields.length == 0){
classFields = obj.getClass().getDeclaredFields();
}
int colCell = 0;
for(String field : fields){
for(Field classField : classFields){
//设置字段可见性
classField.setAccessible(true);
if(field.equals(classField.getName())){
XSSFCell cell = row.createCell(colCell);
cell.setCellValue(classField.get(obj).toString());
colCell ++;
}
}
}
}
}
response.setHeader("Content-Disposition", "attachment;filenaxme="+fileName+".xls");
response.setContentType("application/vnd.ms-excel;");
output = response.getOutputStream();
workbook.write(output);
output.flush();
} catch (Exception e) {
e.printStackTrace();
}finally {
try {
if (workbook != null){
workbook.close();
}
if (output != null){
output.close();
}
} catch (IOException e) {
e.printStackTrace();
}
}
}
}

最后

以上就是笨笨毛衣为你收集整理的java poi 导出excel 导出文本文件 工具类（以流的方式）的全部内容，希望文章能够帮你解决java poi 导出excel 导出文本文件 工具类（以流的方式）所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。