生成代码java导出excel表格
时间: 2024-05-05 08:15:16 浏览: 13
以下是一个简单的Java代码示例,用于将数据导出为Excel表格:
```
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
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.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExcelExporter {
public void exportDataToExcel(List<String[]> data, String fileName) throws IOException {
Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Sheet1");
int rowNum = 0;
for (String[] rowData : data) {
Row row = sheet.createRow(rowNum++);
int colNum = 0;
for (String cellData : rowData) {
Cell cell = row.createCell(colNum++);
cell.setCellValue(cellData);
}
}
FileOutputStream outputStream = new FileOutputStream(fileName);
workbook.write(outputStream);
workbook.close();
outputStream.close();
}
public static void main(String[] args) throws IOException {
List<String[]> data = new ArrayList<String[]>();
data.add(new String[] {"Name", "Age", "Gender"});
data.add(new String[] {"John", "25", "Male"});
data.add(new String[] {"Jane", "30", "Female"});
ExcelExporter exporter = new ExcelExporter();
exporter.exportDataToExcel(data, "example.xlsx");
}
}
```
这个例子使用Apache POI库来创建Excel工作簿和工作表,然后循环遍历数据列表并将其写入单元格中。最后,将工作簿写入文件并关闭它。在主方法中,创建一个包含示例数据的数据列表,然后将其传递给导出器对象,并指定要导出的文件名。