生成excel

最新推荐文章于 2024-05-20 09:45:31 发布

御景

最新推荐文章于 2024-05-20 09:45:31 发布

阅读量96

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/h155344/article/details/84774098

版权

java 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

public static void testExcel(){
        List<Log> logs = new ArrayList<Log>();
        Log log1 = new Log();
        log1.setId(1L);
        log1.setName("111");
        Log log2 = new Log();
        log2.setId(2L);
        log2.setName("222");
        logs.add(log1);
        logs.add(log2);
        
        
        HSSFWorkbook wb = new HSSFWorkbook();  
        HSSFSheet sheet = wb.createSheet("学生表一");  
        HSSFRow row = sheet.createRow((int) 0);  
        HSSFCellStyle style = wb.createCellStyle();  
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式 
        
        
        HSSFCell cell = row.createCell((short) 0);  
        cell.setCellValue("ID");  
        cell.setCellStyle(style);  
        cell = row.createCell((short) 1);  
        cell.setCellValue("名称");  
        cell.setCellStyle(style);  
        
        for (int i = 0; i < logs.size(); i++)  {  
            row = sheet.createRow((int) i + 1);  
            Log log = logs.get(i);  
            row.createCell((short) 0).setCellValue(log.getId());  
            row.createCell((short) 1).setCellValue(log.getName());  
        }  
        
        try  {  
            FileOutputStream fout = new FileOutputStream("D:/students.xls");  
            wb.write(fout);  
            fout.close();  
        }catch (Exception e) {  
            e.printStackTrace();  
        }  
        
        
    }
    public static void main(String[] args) {
        testExcel();
    }