代码
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>