导出文件csv格式

最新推荐文章于 2024-04-26 12:04:39 发布

原创最新推荐文章于 2024-04-26 12:04:39 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一种将JSON格式的数据转换为Excel文件的方法，并提供了一个具体的Java类实现示例。该示例展示了如何读取JSON数据并将其写入CSV文件中，包括玩家ID、OpenID等字段。

public class JsonToExcel {

    // 服务器文件路径
    public static String saveUrl ="D:\\hnqp\\GMManager\\excal\\";

    /**
     * 导出玩家基本信息
     * @param data
     * @param name
     */
    public static void  excelToLoad_player(JSONArray data,String name) {
        String textName =name+".csv";
        FileWriter fw = null;
        try {
            fw = new FileWriter(saveUrl+textName);
            fw.write("玩家id");
            fw.write(",");
            fw.write("openId");
            fw.write(",");
            fw.write("昵称");
            fw.write(",");
            fw.write("平台");
            fw.write(",");
            fw.write("注册时间");
            fw.write(",");
            fw.write("是否禁用");
            fw.write(",");
            fw.write("是否机器人");
            fw.write("\n");
            fw.flush();
            Iterator<Object> it = data.iterator();
            while (it.hasNext()) {
                JSONObject ob = (JSONObject) it.next();
                if (ob.getString("playerId")!=null && ob.getString("playerId")!="" && !"".equals(ob.getString("playerId"))) {
                    fw.write(ob.getString("playerId"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("openId")!=null && ob.getString("openId")!="" &&!"".equals(ob.getString("openId"))) {
                    fw.write(ob.getString("openId"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("name")!=null && ob.getString("name")!="" && !"".equals(ob.getString("name"))) {
                    fw.write(ob.getString("name"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("phoneOS")!=null && ob.getString("phoneOS")!="" && !"".equals(ob.getString("phoneOS"))) {
                    fw.write(ob.getString("phoneOS"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("createTime")!=null && ob.getString("createTime")!="" && !"".equals(ob.getString("createTime"))) {
                    fw.write(ob.getString("createTime"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("forbidden")!=null && ob.getString("forbidden")!="" && !"".equals(ob.getString("forbidden"))) {
                    fw.write(ob.getString("forbidden"));  
                }
                else {
                    fw.write("null");
                }                                  
                fw.write(",");
                if (ob.getString("iRobotFlag")!=null && ob.getString("iRobotFlag")!="" && !"".equals(ob.getString("iRobotFlag"))) {
                    fw.write(ob.getString("iRobotFlag"));  
                }
                else {
                    fw.write("null");
                }                                    
                fw.write(",");
                fw.write("\n");
                fw.flush();
                }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}