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();
}
