unity读取excel数据并绘制曲线

一、读取数据

1.导入EPPlus类库：EPPlus.dll

2.创建script脚本

3.创建空物体，挂载脚本

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using OfficeOpenXml;  //excel命名空间
using System.IO;

public class Test : MonoBehaviour
{
    // Start is called before the first frame update
    void Start()
    {
        string filePath = "F:/Unity Project/Curve_draw/Assets/scripts/data.xlsx";
        //获取excel文件信息
        FileInfo fileInfo = new FileInfo(filePath);
        //通过excel文件信息，打开excel表格
        using (ExcelPackage excelPackage = new ExcelPackage(fileInfo)) 
        {
            //Excel表格的操作，花括号结束完成一系列操作
            ExcelWorksheet worksheet= excelPackage.Workbook.Worksheets["Sheet1"]; //取Excel中的第一张表
            string s = worksheet.Cells[2, 1].Value.ToString();//第一行第一列信息

           // Debug.Log(s);
            for (int i = 1; i < 5; i++)