用输入流读写csv文件 csv用excel打开乱码问题

csv用excel打开乱码问题.

//linux

if (System.getProperty("os.name").toLowerCase().indexOf("linux") >= 0) {
                    OutputStreamWriter osw = new OutputStreamWriter(new FileOutputStream(writename), "UTF-8");
                    osw.write(new String(new byte[] { (byte) 0xEF, (byte) 0xBB,(byte) 0xBF }));

                    osw.write("\""+ CommonConsts.CONFERENCETITLE + "\""+ "," +"\""+ conferenceTitle +"\""+ "\r\n");
                    osw.write("\""+ CommonConsts.PLACE +"\"" + "," +"\""+ place + "\""+ "\r\n");
                    osw.write("\""+ CommonConsts.PARTICIPANTS + "\""+ "," +"\""+participants +"\""+ "\r\n");
                    osw.write("\""+ CommonConsts.SUBJECT + "\"" + "," +"\""+ subject +"\""+ "\r\n");
                    osw.write("\""+ CommonConsts.MEETSTARTTIME + "\"" + "," +"\""+ dateFormat2.format(dateFormat.parse(meetstartTime)) +"\""+ "\r\n");
                    osw.write("\""+ CommonConsts.MEETENDTIME + "\"" +"," +"\""+ dateFormat2.format(dateFormat.parse(meetendTime)) +"\""+ "\r\n");
                    osw.write("\""+ CommonConsts.SPEAKSTAETTIME+ "\""+ "," + "\""+ CommonConsts.SPEAKER +"\"" +"," + "\""+ CommonConsts.SPEAKEDITTEXT+"\"" +"\r\n");
                    for (TalkDataListDto talkDataListDto : talkDataList) {
                        osw.write("\""+dateFormat3.format(dateFormat.parse(talkDataListDto.getStartTime())) +"\""+ "," +"\""+ talkDataListDto.getTalker() +"\""+ "," +"\""+ talkDataListDto.getEditText() +"\""+ "\r\n");
                    }
                    osw.flush(); 
                    osw.close(); 
                    // windows
                } else {
                    out = new BufferedWriter(new FileWriter(writename));
                    out.write("\""+ CommonConsts.CONFERENCETITLE + "\""+ "," +"\""+ conferenceTitle +"\""+ "\r\n");
                    out.write("\""+ CommonConsts.PLACE +"\"" + "," +"\""+ place + "\""+ "\r\n");
                    out.write("\""+ CommonConsts.PARTICIPANTS + "\""+ "," +"\""+participants +"\""+ "\r\n");
                    out.write("\""+ CommonConsts.SUBJECT + "\"" + "," +"\""+ subject +"\""+ "\r\n");
                    out.write("\""+ CommonConsts.MEETSTARTTIME + "\"" + "," +"\""+ dateFormat2.format(dateFormat.parse(meetstartTime)) +"\""+ "\r\n");
                    out.write("\""+ CommonConsts.MEETENDTIME + "\"" +"," +"\""+ dateFormat2.format(dateFormat.parse(meetendTime)) +"\""+ "\r\n");
                    out.write("\""+ CommonConsts.SPEAKSTAETTIME+ "\""+ "," + "\""+ CommonConsts.SPEAKER +"\"" +"," + "\""+ CommonConsts.SPEAKEDITTEXT+"\"" +"\r\n");
                    for (TalkDataListDto talkDataListDto : talkDataList) {
                        out.write("\""+dateFormat3.format(dateFormat.parse(talkDataListDto.getStartTime())) +"\""+ "," +"\""+ talkDataListDto.getTalker() +"\""+ "," +"\""+ talkDataListDto.getEditText() +"\""+ "\r\n");
                    }
                    out.flush(); 
                    out.close(); 
                }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值