在unity中对Excel进行存取编辑(UniExcel插件)_D大调的..._CSDN博客

来自 : CSDN技术社区 发布时间：2021-03-24

MyAddress File .Open ( F:\\MYPath\\myExcle.xls ,FileMode.OpenOrCreate ,FileAccess.ReadWrite ,FileShare.ReadWrite ); Init(); ShowMessage( 如您有所操作 请记得保存! , 5f); private void ShowMessage(string msg,float min) tipMessage.transform.GetChild(0).GetComponent Text ().text msg; tipMessage.transform.localScale Vector3.zero; tipMessage.transform.localPosition tipMessageroot; tipMessage.SetActive(true); tipMessage.transform.DOScale(Vector3.one, 0.5f); Invoke( Disappear , min); private void Disappear() tipMessage.transform.DOScaleY(-100, 0.5f); private void Init() IExcelDataReader excelReader ExcelReaderFactory.CreateBinaryReader(MyAddress); DataSet Result excelReader.AsDataSet(); excelReader.IsFirstRowAsColumnNames true; int NumberOfRows Result.Tables[0].Rows.Count; int NumberOfCols Result.Tables[0].Columns .Count; for (int i i NumberOfRows; i ) for (int j j NumberOfCols; j ) TableItem item GameObject.Instantiate(tableItemPrefab, Content.transform).GetComponent TableItem item.text.text Result.Tables[0].Rows[i][j].ToString(); tableItemList.Add(item); Mystring.Add(Result.Tables[0].Rows[i][j].ToString()); for (int i i tableItemList.Count ; i ) if (i%5 0) tableItemList[i].isCanChange false; Debug.Log(tableItemList.Count); public void Save() int index HSSFWorkbook MyWorkbook new HSSFWorkbook(); HSSFSheet Sheet01 (HSSFSheet)MyWorkbook.CreateSheet(MySheetName); for (int i i tableItemList .Count /5; i )//5列 HSSFRow row (HSSFRow)Sheet01.CreateRow((short)i); for (int j j j ) HSSFCell cell (HSSFCell)row.CreateCell((short)j); cell.SetCellValue(tableItemList[index].text.text); index MyWorkbook.Write(File.Open( F:\\MYPath\\myExcle.xls , FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite)); MyWorkbook.Close(); for (int i i tableItemList.Count; i ) if (i%5 0) tableItemList[i].DelButton.gameObject.SetActive(false); transform.Find( DeleteButton ).GetComponent Button ().transform.GetChild(0).GetComponent Text ().text 删除 ShowMessage( 保存成功 , 1.5f); public void Add() for (int i i i ) TableItem item GameObject.Instantiate(tableItemPrefab, Content.transform).GetComponent TableItem if (i 0) if (isChange true) item.DelButton.gameObject.SetActive(true); item.text.text (int.Parse(tableItemList[tableItemList.Count - 5].text.text) 1).ToString(); else item.text.text tableItemList.Add(item); scrollbar.value -0.1f;