static void BuildOneTable() { string dir = Application.dataPath.Substring(0, Application.dataPath.LastIndexOf('/') + 1); dir = dir + "www/Excel"; OpenFileName openFileName = new OpenFileName(); openFileName.structSize = Marshal.SizeOf(openFileName); openFileName.filter = "Excel文件(*.xlsx)\0*.xlsx"; openFileName.file = new string(new char[256]); openFileName.maxFile = openFileName.file.Length; openFileName.fileTitle = new string(new char[64]); openFileName.maxFileTitle = openFileName.fileTitle.Length; openFileName.initialDir = dir;//默认路径 openFileName.title = "窗口标题"; openFileName.flags = 0x00080000 | 0x00001000 | 0x00000800 | 0x00000008; if (GetOpenFileName(openFileName)) { FileNames = openFileName.file; if (!FileNames.Replace('\\', '/').Contains(dir)) { Debug.Log("请将数据文件放在:" + dir); return; } BuildGameData m_BuildGameData = new BuildGameData(); m_BuildGameData.ReadData(FileNames); Debug.Log(string.Format("生成{0}数据表与构建代码,完毕!", openFileName.fileTitle)); } }
static void BuildALLTable() { string dir = Application.dataPath.Substring(0, Application.dataPath.LastIndexOf('/') + 1); dir = dir + "www/Excel"; if (!Directory.Exists(dir)) { Directory.CreateDirectory(dir); } OpenFileName openFileName = new OpenFileName(); openFileName.structSize = Marshal.SizeOf(openFileName); openFileName.filter = "Excel文件(*.xlsx)\0*.xlsx"; openFileName.file = new string(new char[256]); openFileName.maxFile = openFileName.file.Length; openFileName.fileTitle = new string(new char[64]); openFileName.maxFileTitle = openFileName.fileTitle.Length; openFileName.initialDir = dir;//默认路径 openFileName.title = "窗口标题"; openFileName.flags = 0x00080000 | 0x00001000 | 0x00000800 | 0x00000008; if (GetOpenFileName(openFileName)) { FileNames = openFileName.file; if (!FileNames.Replace('\\', '/').Contains(dir)) { Debug.Log("请将数据文件放在:" + dir); return; } string filePath = FileNames.Substring(0, FileNames.LastIndexOf('\\') + 1); if (Directory.Exists(filePath)) { DirectoryInfo direction = new DirectoryInfo(filePath); FileInfo[] files = direction.GetFiles("*.xlsx", SearchOption.AllDirectories); //Debug.Log(files.Length); if (files.Length > 0) { string[] arr = new string[files.Length]; BuildGameData m_BuildGameData = new BuildGameData(); for (int i = 0; i < files.Length; i++) { arr[i] = files[i].FullName; //Debug.Log("Name:" + files[i].FullName); //打印出来这个文件夹下的所有文件 ; } m_BuildGameData.Read_ALLData(arr); Debug.Log(string.Format("生成{0}张数据表与构建代码,完毕!", files.Length)); } } } }
static void DeleteALLTable() { BuildGameData m_BuildGameData = new BuildGameData(); m_BuildGameData.DeleteALLTable(); }