java map数据生成execl 代码
时间: 2024-05-02 19:19:13 浏览: 147
您好!生成Excel文件的Java代码可以使用Apache POI库中的API实现。在使用过程中,您可以将Java Map数据存储到Excel工作表的单元格中。以下是一个简单的例子代码:
```java
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class MapToExcelConverter {
public static void main(String[] args) {
Map<String, String> dataMap = new HashMap<>();
dataMap.put("Name", "John Doe");
dataMap.put("Age", "30");
dataMap.put("Job", "Programmer");
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("Data");
HSSFRow headerRow = sheet.createRow(0);
headerRow.createCell(0).setCellValue("Field Name");
headerRow.createCell(1).setCellValue("Field Value");
int rowIndex = 1;
for (Map.Entry<String, String> entry : dataMap.entrySet()) {
HSSFRow dataRow = sheet.createRow(rowIndex++);
dataRow.createCell(0).setCellValue(entry.getKey());
dataRow.createCell(1).setCellValue(entry.getValue());
}
try (FileOutputStream outputStream = new FileOutputStream("data.xls")) {
workbook.write(outputStream);
} catch (IOException e) {
e.printStackTrace();
}
System.out.println("Excel file generated successfully!");
}
}
```
希望对您有所帮助!
阅读全文
相关推荐















