java csv修改 java csv转换为excel

csv的依赖包 ，剩余的就是poi的包 自己查一下
<dependency>
    <groupId>net.sourceforge.javacsv</groupId>
    <artifactId>javacsv</artifactId>
    <version>2.0</version>
</dependency>

代码如下：

   

public static void csvToXLSX(String outputFilePath, String sheetName) {
         try {
             String csvFileAddress = outputFilePath; //csv file address
             String xlsxFileAddress = outputFilePath.replace("csv","xlsx"); //xlsx file address
             XSSFWorkbook workBook = new XSSFWorkbook();
             XSSFSheet sheet = workBook.createSheet(sheetName);
             sheet.setColumnWidth(35, 10000);
             sheet.setColumnWidth(36, 10000);
             sheet.setColumnWidth(37, 10000);
             sheet.setColumnWidth(38, 10000);
             sheet.setColumnWidth(39, 10000);
             sheet.setColumnWidth(40, 10000);
             CellStyle style = workBook.createCellStyle() ;
             XSSFFont font = workBook.createFont();
             font.setFontName("Courier");
             style.setFont(font);
 //            style.setWrapText(true);
             int RowNum=-1;
             // 创建CSV读对象
             CsvReader csvReader = new CsvReader(csvFileAddress);
             while (csvReader.readRecord()){
                 RowNum++;
                 XSSFRow currentRow=sheet.createRow(RowNum);
                 for(int i=0;i<csvReader.getColumnCount();i++){                       //这里获取到的值自己想要的类型处理下
                     currentRow.createCell(i).setCellValue(csvReader.get(i).trim());
                     if (i >= 35){
                         currentRow.getCell(i).setCellStyle(style);
                     }
                 }
             }            FileOutputStream fileOutputStream =  new FileOutputStream(xlsxFileAddress);
             workBook.write(fileOutputStream);
             fileOutputStream.close();
             System.out.println("Done");
         } catch (Exception ex) {
             System.out.println(ex.getMessage()+"Exception in try");
         }
     }