1、导入依赖
e-iceblue spire.xls.free5.1.0
2、方法 (注意导的包)
package com.example.test.service;
import com.spire.xls.ExcelVersion;
import com.spire.xls.IgnoreErrorType;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
import java.util.EnumSet;
public class CanRun2 {
public static void main(String[] args) {
String inputFile = "C:\Users\peijiaqi\Desktop\dsdsad11.csv";
String outputFile = "C:\Users\peijiaqi\Desktop\dsdsad11.xlsx";
//Create a workbook and load a csv file
Workbook workbook = new Workbook();
workbook.loadFromFile(inputFile, ",", 1, 1);
//Get the first worksheet
Worksheet sheet = workbook.getWorksheets().get(0);
sheet.getCellRange("D2:E19").setIgnoreErrorOptions(EnumSet.of(IgnoreErrorType.NumberAsText));
sheet.getAllocatedRange().autoFitColumns();
//Save the Excel file
workbook.saveToFile(outputFile, ExcelVersion.Version2013);
}
}



