Java导出数据行写入到Excel表格：基于Apache POI

桃扇骨 2024-02-19 15:33 60阅读 0赞

## Java导出数据行写入到Excel表格：基于Apache POI ##

import java.io.File;
    import java.io.FileOutputStream;
    
    import org.apache.poi.hssf.usermodel.HSSFRow;
    import org.apache.poi.hssf.usermodel.HSSFSheet;
    import org.apache.poi.hssf.usermodel.HSSFWorkbook;
    
    public class ExcelUtil {
    	public static void main(String[] args) throws Exception {
    		HSSFWorkbook mWorkbook = new HSSFWorkbook();
    
    		HSSFSheet mSheet = mWorkbook.createSheet("Student");
    
    		// 创建Excel标题行，第一行。
    		HSSFRow headRow = mSheet.createRow(0);
    		headRow.createCell(0).setCellValue("id");
    		headRow.createCell(1).setCellValue("name");
    		headRow.createCell(2).setCellValue("gender");
    		headRow.createCell(3).setCellValue("age");
    
    		// 往Excel表中写入3行测试数据。
    		createCell(1, "zhang", "男", 18, mSheet);
    		createCell(2, "phil", "男", 19, mSheet);
    		createCell(3, "fly", "男", 20, mSheet);
    
    		File xlsFile = new File("f.xls");
    		mWorkbook.write(xlsFile);// 或者以流的形式写入文件 mWorkbook.write(new FileOutputStream(xlsFile));
    		mWorkbook.close();
    	}
    
    	// 创建Excel的一行数据。
    	private static void createCell(int id, String name, String gender, int age, HSSFSheet sheet) {
    		HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum() + 1);
    
    		dataRow.createCell(0).setCellValue(id);
    		dataRow.createCell(1).setCellValue(name);
    		dataRow.createCell(2).setCellValue(gender);
    		dataRow.createCell(3).setCellValue(age);
    	}
    }

最终生成的Excel表格数据如图所示：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncGhpbA_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncGhpbA_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/74feeb975d1e41978a5cea286ca0cbd1.png