效果图:
代码(使用了插件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