自用Unity工具:读取excel题库的答题模块

效果图:

代码(使用了插件EPPlus)

using System;
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using OfficeOpenXml;
using System.IO;
using UnityEngine.Networking;
using UnityEngine.UI;
using Random = UnityEngine.Random;

public class EXCELReader : MonoBehaviour
{

    public static List<QuesionClass> QuesionsList=new List<QuesionClass>();
    public class QuesionClass
    {
        public string question, image, answer, analysis,BIJI;
    }
    public GameObject ButtonPrefab,ButtonParent;
    public InputField BIJI;
    public static string ReadingExcel;//正在读取的表格

    #region 按钮初始化

    public Button Full,Save,Delete,Answer,Next;
    public GameObject InputFiledOBJ,ShowAnswer,ShowTip;
    private bool IsFull;
    private List<int> SavingQuestions = new List<int>();//存储看过的题目
    private void ButtonUpdate()
    {
        Full.onClick.AddListener(() =>
        {
            InputFiledOBJ.transform.position =
                IsFull ? new Vector3(683.0f, -126.0f, 0.0f) : new Vector3(683.0f, 284.0f, 0.0f);
            IsFull = !IsFull;
        });
        Save.onClick.AddListener(() =>
        {

            FileInfo fileInfo = new FileInfo(Application.streamingAssetsPath+"\\Questions\\题库我的收藏.xlsx");
            Debug.Log(fileInfo);
            using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))
            {

                ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets[1];
                int Row = worksheet.Dimension.End.Row+1;
                worksheet.Cells[Row, 1].Va