java实现导出excel代码
时间: 2023-11-12 20:07:46 浏览: 36
以下是使用Apache POI库实现导出Excel文件的Java代码示例。需要先引入POI库的jar包。
```
import java.io.FileOutputStream;
import java.util.List;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExportExcel {
public void export(List<Object[]> dataList, String filePath) {
// 创建工作簿
XSSFWorkbook workbook = new XSSFWorkbook();
// 创建工作表
Sheet sheet = workbook.createSheet("Sheet1");
// 创建表头行
Row headerRow = sheet.createRow(0);
// 添加表头内容
String[] headerTitles = {"姓名", "年龄", "性别"};
for (int i = 0; i < headerTitles.length; i++) {
Cell cell = headerRow.createCell(i);
cell.setCellValue(headerTitles[i]);
}
// 添加数据行
for (int i = 0; i < dataList.size(); i++) {
Row dataRow = sheet.createRow(i + 1);
Object[] rowData = dataList.get(i);
for (int j = 0; j < rowData.length; j++) {
Cell cell = dataRow.createCell(j);
cell.setCellValue(String.valueOf(rowData[j]));
}
}
// 导出Excel文件
try (FileOutputStream outputStream = new FileOutputStream(filePath)) {
workbook.write(outputStream);
outputStream.flush();
} catch (Exception e) {
e.printStackTrace();
}
}
}
```
使用示例:
```
List<Object[]> dataList = new ArrayList<>();
dataList.add(new Object[]{"张三", 20, "男"});
dataList.add(new Object[]{"李四", 25, "女"});
dataList.add(new Object[]{"王五", 30, "男"});
ExportExcel exportExcel = new ExportExcel();
exportExcel.export(dataList, "D:/test.xlsx");
```
以上代码将会导出一个包含三行数据的Excel文件,保存在D盘的test.xlsx文件中。