请用java写一个段代码:导出excel
时间: 2023-09-24 17:05:31 浏览: 83
### 回答1:
public void exportExcel(String fileName) {
try {
Workbook workbook = new HSSFWorkbook();
Sheet sheet = workbook.createSheet(fileName);
FileOutputStream fos = new FileOutputStream(fileName);
workbook.write(fos);
fos.close();
} catch (IOException e) {
e.printStackTrace();
}
}
### 回答2:
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExportExcel {
public static void main(String[] args) {
// 创建Excel工作簿对象
Workbook workbook = new XSSFWorkbook();
// 创建工作表
Sheet sheet = workbook.createSheet("Sheet1");
// 创建行对象
Row headerRow = sheet.createRow(0);
// 创建单元格样式对象
CellStyle headerCellStyle = workbook.createCellStyle();
headerCellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
headerCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
headerCellStyle.setAlignment(HorizontalAlignment.CENTER);
// 创建标题单元格并设置样式
Cell cell = headerRow.createCell(0);
cell.setCellValue("姓名");
cell.setCellStyle(headerCellStyle);
cell = headerRow.createCell(1);
cell.setCellValue("年龄");
cell.setCellStyle(headerCellStyle);
// 创建数据行对象
Row dataRow = sheet.createRow(1);
dataRow.createCell(0).setCellValue("张三");
dataRow.createCell(1).setCellValue(25);
dataRow = sheet.createRow(2);
dataRow.createCell(0).setCellValue("李四");
dataRow.createCell(1).setCellValue(30);
// 调整列宽以适应数据长度
sheet.autoSizeColumn(0);
sheet.autoSizeColumn(1);
// 导出Excel文件
try (FileOutputStream outputStream = new FileOutputStream("output.xlsx")) {
workbook.write(outputStream);
} catch (IOException e) {
e.printStackTrace();
}
// 关闭工作簿
try {
workbook.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
以上代码使用Apache POI库来操作Excel文件,创建一个输出名为"output.xlsx"的Excel文件,并导出到磁盘。代码先创建工作簿对象,然后创建工作表对象并设置表头样式,然后创建数据行并填充数据,最后调整列宽以适应数据长度。最后使用FileOutputStream将工作簿写入到文件中,并在结束时关闭工作簿。
### 回答3:
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExcelExporter {
public static void main(String[] args) {
Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Sheet1");
// 创建表头
Row headerRow = sheet.createRow(0);
Cell headerCell = headerRow.createCell(0);
headerCell.setCellValue("姓名");
headerCell = headerRow.createCell(1);
headerCell.setCellValue("年龄");
headerCell = headerRow.createCell(2);
headerCell.setCellValue("性别");
// 创建数据行
Row dataRow = sheet.createRow(1);
Cell dataCell = dataRow.createCell(0);
dataCell.setCellValue("张三");
dataCell = dataRow.createCell(1);
dataCell.setCellValue(25);
dataCell = dataRow.createCell(2);
dataCell.setCellValue("男");
// 导出Excel文件
try (FileOutputStream fileOut = new FileOutputStream("output.xlsx")) {
workbook.write(fileOut);
System.out.println("Excel文件导出成功!");
} catch (Exception e) {
System.out.println("出现错误:" + e.getMessage());
}
}
}