【unity】使用EPPlus读取Excel制作简单题库

插件：EPPlus

下载地址：
链接：https://pan.baidu.com/s/1c86bHrOXLKFq1IpAxRdpdw
提取码：rptl
B站详细教程： https://www.bilibili.com/video/BV1Yt411F7CB，内容包括Excel的创建和读写。
参考博客：
https://blog.csdn.net/wks310/article/details/86005115
https://www.jianshu.com/p/e1ec7c64f1ac

制作简单答题系统

B站视频链接：https://www.bilibili.com/video/BV16K4y1s72M/

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using OfficeOpenXml;
using System.IO;
using UnityEngine.UI;

public class TestExcel : MonoBehaviour
{
    public GameObject[] buttons;
    public GameObject Content;
    private int count_next = 1;
    private string filepath;

    private void Awake()
    {
        filepath = Application.dataPath + "\\" + "tiku.xlsx"; ;//Excel路径
    }
    private void CreateExcel() {
        //原文链接：https://blog.csdn.net/wks310/article/details/86005115
        //放在Assets文件目录下，创建文件名为MyExcel.xlsx
        string outPutDir = Application.dataPath + "\\" + "MyExcel.xlsx";
        //获取新创建的Excel后者已经存在的Excel信息
        FileInfo newFile = new FileInfo(outPutDir);
        if (newFile.Exists)
        {
            newFile.Delete();  // ensures we create a new workbook   
            Debug.Log("删除表");
            newFile = new FileInfo(outPutDir);
        }
        using (ExcelPackage package = new ExcelPackage(newFile))
        {
            ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("我的Excel");//加入表单
            //package.Workbook.Worksheets.Add("sheet2");//添加第二张表
            //package.Workbook.Worksheets.Delete("sheet2");//删除第二张表
            worksheet.Cells[1, 1].Value = "序号";
            worksheet.Cells[1, 2].Value = "姓名";
            worksheet.Cells[1, 3].Value = "电话";
            package.Save();
            Debug.Log("导出Excel成功");
        }
    }

    private void ReadExcel() {
        //string filepath = Application.dataPath + "\\" + "tiku.xlsx"; ;//Excel路径
        int[] random_list = GetRandomSequence2(4, 4);
        //获取Excel的信息
        FileInfo fileInfo = new FileInfo(filepath);
        //通过Excel表格的文件信息，打开Excel表格
        using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))//打开Excel表格
        {
            //取得Excel中的第一张表
            ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets[1];//注意索引从1开始

            if (count_next > worksheet.Dimension.End.Row)
            {
                Content.GetComponent<Text>().text = "答题结束";
                return;
            }
            //取得表中第一行第一列中的数据
            //string s = worksheet.Cells[1, 1].Value.ToString();
            //Debug.Log(s);
            for (int i = count_next; i <= count_next + 4; i++)
            {
                //for (int j = worksheet.Dimension.Start.Column; j <= worksheet.Dimension.End.Column; j++)
                //{
                if (i % 5 == 1)
                {
                    Content.GetComponent<Text>().text = worksheet.Cells[i, 1].Value.ToString();
                }//取题目
                else
                {
                    int k = (i - 2) % 5;//k只取0，1，2，3，表示4个button的索引
                    buttons[random_list[k]].transform.Find("Text").GetComponent<Text>().text = worksheet.Cells[i, 1].Value.ToString();
                }

                //}

            }
        }//关闭Excel表格
    }

    private void WriteExcel()
    {
        
        //获取Excel的信息
        FileInfo fileInfo = new FileInfo(filepath);
        //通过Excel表格的文件信息，打开Excel表格
        using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))//打开Excel表格
        {
            //获取Excel中需要操作的表
            ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets[1];
            //在第7行第1列中写入数据
            worksheet.Cells[7, 1].Value = "11";
            worksheet.Cells[7, 2].Value = "Irving";
            worksheet.Cells[7, 3].Value = "小王爷";
            //保存
            excelPackage.Save();
            Debug.Log("已写入Excel");
        }//关闭Excel表格
    }

    public void Next()
    {
        for (int i = 0; i < 4; i++)
        {
            buttons[i].transform.Find("Text").GetComponent<Text>().color = Color.white;
        }
        count_next += 5;
        ReadExcel();
    }
    public void Previous()
    {
        /*for (int i = 0; i < 4; i++)
        {
            buttons[i].transform.Find("Text").GetComponent<Text>().color = Color.white;
        }*/
        if (count_next > 5)
        {
            count_next -= 5;
            ReadExcel();
        }
    }

    public void SelectCorrect(int num)
    {
        FileInfo fileInfo = new FileInfo(filepath);
        using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))
        {
            ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets[1];
            if (buttons[num].transform.Find("Text").GetComponent<Text>().text.ToString() == worksheet.Cells[count_next + 1, 1].Value.ToString())
            {
                buttons[num].transform.Find("Text").GetComponent<Text>().color = Color.green;
            }
            else
            {
                buttons[num].transform.Find("Text").GetComponent<Text>().color = Color.red;

            }
        }
    }

    public int[] GetRandomSequence2(int total, int n)
    {
        //https://blog.csdn.net/poda_/article/details/49793995
        //随机总数组,在哪个区间内进行随机的选择，比如[1,10)
        int[] sequence = new int[total];
        //取到的不重复数字的数组长度,在上述区间内随机选择几个数
        int[] output = new int[n];
        for (int i = 0; i < total; i++)
        {
            sequence[i] = i;
        }
        int end = total - 1;
        for (int i = 0; i < n; i++)
        {
            //随机一个数，每随机一次，随机区间-1
            int num = Random.Range(0, end + 1);
            output[i] = sequence[num];
            //将区间最后一个数赋值到取到数上
            sequence[num] = sequence[end];
            end--;
            //执行一次效果如：1，2，3，4，5 取到2
            //则下次随机区间变为1,5,3,4;
        }
        return output;
    }
    // Start is called before the first frame update
    void Start()
    {
        ReadExcel();
        //CreateExcel();
        //WriteExcel();
    }
    // Update is called once per frame
    void Update()
    {
        
    }
}