static void OpenXLSX()
{
fileList.Clear();
string[] files = Directory.GetFiles(GameConst.GetExcelFilePath(""));
for (int i = 0; i < files.Length; i++)
{
string[] fileFolders = files[i].Split('/');
string[] filenames = fileFolders[fileFolders.Length - 1].Split('.');
if (filenames[filenames.Length - 1] == "xlsx")
{
string filename = fileFolders[fileFolders.Length - 1];
fileList.Add(filename);
}
}
Open();
}
/// <summary>
/// 载入一个excel文件 Loads the data.
/// </summary>
/// <param name="filename">Filename.</param>
public static string LoadData(string filename)
{
FileStream stream = File.Open(GameConst.GetExcelFilePath(filename), FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
DataSet result = excelReader.AsDataSet();
string ret = "";
//处理所有的子表
for (int i = 0; i < result.Tables.Count; i++)
{
Debug.Log(result.Tables[i].TableName);
bool issuccess = HandleATable(result.Tables[i]);
if (issuccess)
{
ret += result.Tables[i].TableName + "\n";
}
}
return(ret);
}
