字符串导入到excel,用“,“分隔

代码 


import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class test_split2excel {
    public static void main(String args[]){
        String s = "330055,330102,330103,330104,330105,330106,330108,330109,330110,330112,330113,330116,330117,330118,330122,330127,330182,330183,330185,330196,330197,330198,330199,330203,330204,330205,330206,330211,330212,330225,330226,330281,330282,330283,330293,330294,330295,330296,330297,330298,330299,330302,330303,330304,330316,330317,330318,330319,330322,330324,330326,330327,330328,330329,330381,330382,330398,330399,330402,330411,330418,330419,330420,330421,330424,330481,330482,330483,330498,330499,330502,330503,330518,330521,330522,330523,330598,330599,330602,330603,330618,330624,330681,330682,330683,330699,330702,330703,330716,330717,330723,330726,330727,330781,330782,330783,330784,330798,330799,330802,330803,330822,330824,330825,330881,330882,330899,330902,330903,330921,330922,330950,330951,330952,330999,330909,331002,331003,331004,331021,331022,331023,331024,331081,331082,331099,331102,331103,331121,331122,331123,331124,331125,331126,331127,331181,331199,339900";
        String[] arr  =s.split(",");
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet("xxx");
        for(int i=0;i<arr.length;i++) {
            System.out.println(arr[i]);
            //创建HSSFRow对象 (行)
            HSSFRow row = sheet.createRow(i);
            //创建HSSFCell对象  (单元格)
            HSSFCell cell = row.createCell(0);
            //设置单元格的值
            cell.setCellValue(arr[i]);

        }
        try {
            FileOutputStream output = new FileOutputStream("/Users/zcy/Documents/排行榜.csv");
            //保存文件
            workbook.write(output);
            output.flush();
        } catch (IOException e) {
            e.printStackTrace();
        }



    }
}

maven依赖

<dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.15</version>
            <scope>compile</scope>
        </dependency>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值