NetExcel.java

package com.tanpu.fund.excel;

import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;
import com.tanpu.fund.BaseTest;
import org.junit.Test;

import java.util.List;

/**
 * @author: zhoupeng
 * @email: zhoupeng_08@163.com
 */
public class NetExcel extends BaseTest {

    public static final String URL = "https://mylolis-my.sharepoint.com/personal/f3101_365up_site/Documents/工作簿2.xlsx";

    @Test
    public void productNetAnalysis() {
        ExcelReader reader = ExcelUtil.getReader(URL);

        List<List<Object>> read = reader.read();

        System.out.println(read);


    }

}