public static List <TabelData> GetTableList(string ExcelName)
{
ExcelName = PATH + ExcelName + ".xlsx";
if (!File.Exists(ExcelName))
{
throw new UnityException("File is Not:" + ExcelName);
}
FileStream stream = File.Open(ExcelName, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
DataSet result = excelReader.AsDataSet();
var table_list = new List <TabelData>();
foreach (DataTable table in result.Tables)
{
var tabel_data = new TabelData();
tabel_data.Name = table.TableName;
Debug.Log(ExcelName + " - " + tabel_data.Name);
tabel_data.ColumnInfos = GetColunmInfos(table.Rows[COLUNM_NAME_ROW], table.Rows[COLUNM_TYPE_ROW]);
tabel_data.RowDic = GetRowDataList(tabel_data.ColumnInfos, table.Rows);
table_list.Add(tabel_data);
}
stream.Close();
return(table_list);
}
private static string CreateLoadTabelMethoe(TabelData tabel)
{
var cs = LOAD_TABLE_METHOE;
cs = cs.Replace(MACRO_TABLE_NAME, tabel.Name);
cs = cs.Replace(MACRO_GET_PROP_LIST, CreateGetPropList(tabel.ColumnInfos));
return(cs);
}
/// <param name="path">Resources文件下</param>
public static void WriteTabelToJsonFile(TabelData data)
{
FileContorl.WriteStringToFile(PATH + data.Name + ".json", JsonConvert.SerializeObject(data));
}
public static void CreateDataStruct(TabelData data)
{
CreateDataStruct(data.Name, data.ColumnInfos);
}
