CSV转XLSX e-blue版本（亲测有效）

晴转多云_

已于 2022-06-17 11:09:37 修改

阅读量191

点赞数

分类专栏： java 文章标签： java 开发语言

于 2022-06-17 11:09:02 首次发布

本文链接：https://blog.csdn.net/qq_42457857/article/details/125329955

版权

java 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

1、导入依赖

       <dependency>
            <groupId>e-iceblue</groupId>
            <artifactId>spire.xls.free</artifactId>
            <version>5.1.0</version>
        </dependency>

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;

/**
 * @ProjectName: IntelliJ IDEA
 * @ClassName: CanRun2
 * @Author: ZPJ
 * @Description: TODO
 * @Date: 2022/6/17 10:49
 * @Version: 1.0
 */
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);
    }
}