Java对excel列数据逗号分隔

从表格复制整列到Java代码中，然后replace \r\n为','，就可以将列数据逗号分隔 

public class transform_test {
    public transform_test() {
    }

    public static void main(String[] args) {
        String str = "1200451\n1200456\n1200555\n1200599\n1200603\n1200715\n1200787\n1200791\n1200795\n1201047\n1201052\n1201055\n1201342\n1201347\n1201351\n1201444\n1201446\n1201499\n1201523\n1201623\n1201627\n1201707\n1201712\n1201841\n1201893\n1201933\n1202249\n1202255\n1202261\n1202266\n1202299\n1202304\n1202499\n1202503\n1202531\n1202634\n1202690\n1202798\n1202805\n1202930\n1203199\n1203335\n1203412\n1203531\n1203609\n1203637\n1203647\n1203677\n1203769\n1204074\n1206661\n1206662\n1206668\n1206669\n1206671\n1206677\n1206678\n1206680\n1206682\n1206686\n1206688\n1206690\n1206697\n1206703\n1206707\n1206711\n1206716\n1206718\n1206722\n1206736\n1206743\n1206745\n1206749\n1206752\n1206768\n1206772\n1206778\n1206780\n1206791\n1206795\n1206803\n1206809\n1206813\n1206826\n1206831\n1206833\n1206838\n1206842\n1206846\n1206859\n1206866\n1206870\n1206879\n1206888\n1206898\n1206906\n1208308\n1208312\n1208317\n1208321\n";
        str = str.replaceAll("(\r\n|\n)", ",");
        System.out.println(str);
    }

}

 可将逗号分隔的数据用于SQL查询

select ... task_id in (1200451,1200456,1200555,1200599,1200603,1200715,1200787,1200791,1200795,1201047,1201052,1201055,1201342,1201347,1201351,...)