public static void ProcessConvert()
{
FileStream stream = File.Open(Application.dataPath + PATH_EXCEL, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
ItemDataSet itemDataSet = ScriptableObject.CreateInstance<ItemDataSet>();
DataTable dataTable;
ExcelLoader loader;
if (excelReader.AsDataSet () != null)
{
dataTable = excelReader.AsDataSet ().Tables["Item"];
loader = new ExcelLoader(dataTable);
itemDataSet.itemDataSet = loader.CreateDataList<ItemData>();
dataTable = excelReader.AsDataSet ().Tables["Weapon"];
loader = new ExcelLoader(dataTable);
itemDataSet.weaponDataSet = loader.CreateDataList<WeaponData>();
dataTable = excelReader.AsDataSet ().Tables["Magic"];
loader = new ExcelLoader(dataTable);
itemDataSet.magicDataSet = loader.CreateDataList<MagicData>();
foreach(WeaponData weapon in itemDataSet.weaponDataSet)
{
weapon.type = ItemType.Weapon;
}
foreach(MagicData magic in itemDataSet.magicDataSet)
{
magic.type = ItemType.Magic;
}
AssetDatabase.CreateAsset(itemDataSet, PATH_ASSET);
}
excelReader.Dispose ();
}
public static void ProcessConvert()
{
FileStream stream = File.Open(Application.dataPath + PATH_EXCEL, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
SkillDataSet skillDataSet = ScriptableObject.CreateInstance<SkillDataSet>();
DataTable dataTable;
ExcelLoader loader;
if (excelReader.AsDataSet () != null)
{
dataTable = excelReader.AsDataSet().Tables["Skill"];
loader = new ExcelLoader(dataTable);
skillDataSet.skillDataSet = loader.CreateDataList<SkillData>();
dataTable = excelReader.AsDataSet().Tables["Buff"];
loader = new ExcelLoader(dataTable);
skillDataSet.buffDataSet = loader.CreateDataList<BuffData>();
dataTable = excelReader.AsDataSet().Tables["SkillEffect"];
loader = new ExcelLoader(dataTable);
skillDataSet.effectDataSet = loader.CreateDataList<SkillEffectData>();
AssetDatabase.CreateAsset(skillDataSet, PATH_ASSET);
}
excelReader.Dispose ();
}
