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

首先要注意的点： 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

4.2017.2版本demo工程（包含其他所需要的excel相关dll） 下载 https://pan.baidu.com/s/1equ8Mdzwu9ztsPJMUWp1Sw

读excel

智慧车行预约小程序

智慧车行小程序，是一个专门为洗车/4S/车辆维修行业打造的小程序，前后端完整代码包括车行动态，养车常识，保养预约，维修预约，洗车美容预约，汽车检测预约等功能。采用腾讯提供的小程序云开发解决方案，无须服务器和域名预约管理：开始/截止时间/人数均可灵活设置，可以自定义客户预约填写的数据项预约凭证：支持线下到场后校验签到/核销/二维码自助签到等多种方式详尽的预约数据：支持预约名单数据导出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 Load(string path)    {        List _data = new List();        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
写excel
代码语言：javascript代码运行次数：0运行复制
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 开始