unity3d：windows读写excel，打包exe可用

我会带着你远行 2022-05-20 04:15 190阅读 0赞

首先要注意的点：  
1.你的unity版本是多少，去对应的安装目录中取dll  
2.System.Data.dll 在D:\\Program Files\\Unity2017.2\\Editor\\Data\\Mono\\lib\\mono\\2.0  
3.I18N开头的dll 在 D:\\Program Files\\Unity2017.2\\Editor\\Data\\Mono\\lib\\mono\\unity  
![这里写图片描述][70]  
4.2017.2版本demo工程（包含其他所需要的excel相关dll） 下载  
[https://pan.baidu.com/s/1equ8Mdzwu9ztsPJMUWp1Sw][https_pan.baidu.com_s_1equ8Mdzwu9ztsPJMUWp1Sw]

读excel

using System.Collections;
    using System.Collections.Generic;
    using UnityEngine;
    using System.Data;
    using System.IO;
    using Excel;
    
    public class DoExcel {
        public static DataSet ReadExcel(string path)
        {
            FileStream stream = File.Open(path, FileMode.Open, FileAccess.Read, FileShare.Read);
            IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
            DataSet result = excelReader.AsDataSet();
            excelReader.Close();
            return result;
    
        }
    
        public static List<DepenceTableData> Load(string path)
        {
            List<DepenceTableData> _data = new List<DepenceTableData>();
            DataSet resultds = ReadExcel(path);
            int column = resultds.Tables[0].Columns.Count;
            int row = resultds.Tables[0].Rows.Count;
            Debug.LogWarning(column + " " + row);
            for(int i=1;i<row;i++)
            {
                DepenceTableData temp_data;
                temp_data.instruct = resultds.Tables[0].Rows[i][0].ToString();
                temp_data.word = resultds.Tables[0].Rows[i][1].ToString();
                Debug.Log(temp_data.instruct + " " + temp_data.word);
                _data.Add(temp_data);
            }
            return _data;
        }
    
    }
    
    public struct DepenceTableData
    {
        public string word;
        public string instruct;
    }

写excel

public static void WriteExcel(string outputDir)
        {
            //string outputDir = EditorUtility.SaveFilePanel("Save Excel", "", "New Resource", "xlsx");
            FileInfo newFile = new FileInfo(outputDir);
            if (newFile.Exists)
            {
                newFile.Delete(); // ensures we create a new workbook
                newFile = new FileInfo(outputDir);
            }
            using (ExcelPackage package = new ExcelPackage(newFile))
            {
                // add a new worksheet to the empty workbook
                ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1");
                //Add the headers
                worksheet.Cells[1, 1].Value = "ID";
                worksheet.Cells[1, 2].Value = "Product";
                worksheet.Cells[1, 3].Value = "Quantity";
                worksheet.Cells[1, 4].Value = "Price";
                worksheet.Cells[1, 5].Value = "Value";
    
                //Add some items...
                worksheet.Cells["A2"].Value = 12001;
                worksheet.Cells["B2"].Value = "Nails";
                worksheet.Cells["C2"].Value = 37;
                worksheet.Cells["D2"].Value = 3.99;
    
                worksheet.Cells["A3"].Value = 12002;
                worksheet.Cells["B3"].Value = "Hammer";
                worksheet.Cells["C3"].Value = 5;
                worksheet.Cells["D3"].Value = 12.10;
    
                worksheet.Cells["A4"].Value = 12003;
                worksheet.Cells["B4"].Value = "Saw";
                worksheet.Cells["C4"].Value = 12;
                worksheet.Cells["D4"].Value = 15.37;
    
                //save our new workbook and we are done!
                package.Save();
            }
        }

excel写入的表格 row，rol都是 从1 开始

[70]: /images/20220520/3f79e9e9df114cb6ac07cf20984e1a8f.png
[https_pan.baidu.com_s_1equ8Mdzwu9ztsPJMUWp1Sw]: https://pan.baidu.com/s/1equ8Mdzwu9ztsPJMUWp1Sw