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