具体代码如下:
import java.io.BufferedReader;
import java.io.DataInputStream;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class CsvToExcel {
public static void main(String[] args) {
CsvToExcel.makeExcel();
}
/**
* 将数据写入到excel中
*/
public static void makeExcel() {
//第一步,创建一个workbook对应一个excel文件
HSSFWorkbook workbook = new HSSFWorkbook();
try {
DataInputStream in=new DataInputStream(new FileInputStream("H:\\orderData_50.csv"));//换成你的文件名
BufferedReader reader=new BufferedReader(new InputStreamReader(in,"GBK"));
reader.readLine();//第一行信息,为标题信息,不用,如果需要,注释掉
String line = n