• java导出excel不须要额外jar包


       眼下我知道的在java中导出Excel能够用poi或在jsp的文件头改变输出流。

    以下再介绍一种就用java基础包导出的Excel。导出的格式形如:

    源代码例如以下:

    package csvExcel;
    
    import java.io.FileWriter;
    import java.io.IOException;
    import java.text.SimpleDateFormat;
    import java.util.ArrayList;
    import java.util.Date;
    import java.util.List;
    
    public class CsvAction {
    	
    	public static void main(String[] args) {
    		new CsvAction().exportData2CSV();
    	}
    
    	private String fileName;
    
    	public void exportData2CSV() {
    		List<Novel> novels = getNovels();
    		fileName = "D:/novels.csv";
    		writeData2CSV(novels, fileName);
    		System.out.println("D:/novels.csv下文件生成成功");
    	}
    
    	private void writeData2CSV(List<Novel> novels, String fileName2) {
    		FileWriter fw = null;
    		try {
    			fw = new FileWriter(fileName);
    			// 输出标题头
    			// 注意列之间用","间隔,写完一行须要回车换行"
    "
    			String title = "序号,小说名称,作者,出版日期
    ";
    			fw.write(title);
    
    			String content = null;
    			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
    			for (int i = 0; i < novels.size(); i++) {
    				Novel novel = novels.get(i);
    				// 注意列之间用","间隔,写完一行须要回车换行"
    "
    				content = (i + 1) + "," + novel.getName() + ","
    						+ novel.getAuthor() + ","
    						+ sdf.format(novel.getPublishTime()) + "
    ";
    				fw.write(content);
    			}
    		} catch (Exception e) {
    			e.printStackTrace();
    			throw new RuntimeException(e);
    		} finally {
    			try {
    				if (fw != null) {
    					fw.close();
    				}
    			} catch (IOException e) {
    				e.printStackTrace();
    			}
    		}
    	}
    
    	private List<Novel> getNovels() {
    		List<Novel> novels = new ArrayList<Novel>();
    
    		Novel novel1 = new Novel("风云第一刀", "古龙", new Date());
    		Novel novel2 = new Novel("书剑恩仇录", "金庸", new Date());
    		Novel novel3 = new Novel("陆小凤传奇", "古龙", new Date());
    		Novel novel4 = new Novel("鹿鼎记", "金庸", new Date());
    
    		novels.add(novel1);
    		novels.add(novel2);
    		novels.add(novel3);
    		novels.add(novel4);
    
    		return novels;
    	}
    
    }
    
    将源代码复制后能够直接执行。

  • 相关阅读:
    jQuery 核心
    Js实现内容向上无缝循环滚动
    浅析CSS postion属性值用法
    JS原生Ajax请求
    详解SQL集合运算
    Windows上开启IIS
    poj 4618 暴力
    hdu 4614 线段树
    poj 3468 线段树
    hdu 1698 线段树成段更新
  • 原文地址:https://www.cnblogs.com/gavanwanggw/p/7238517.html
Copyright © 2020-2023  润新知