static void OnPostprocessAllAssets(string[] importedAssets, string[] deletedAssets, string[] movedAssets, string[] movedFromAssetPaths)
{
foreach (string asset in importedAssets)
{
if (!filePath.Equals(asset))
continue;
using (FileStream stream = File.Open (filePath, FileMode.Open, FileAccess.Read))
{
var book = new HSSFWorkbook(stream);
foreach (string sheetName in sheetNames)
{
var exportPath = "Assets/Resources/Data/" + sheetName + ".asset";
// check scriptable object
var data = (Entity_saku_mst)AssetDatabase.LoadAssetAtPath(exportPath, typeof(Entity_saku_mst));
if (data == null)
{
data = ScriptableObject.CreateInstance<Entity_saku_mst>();
AssetDatabase.CreateAsset((ScriptableObject)data, exportPath);
data.hideFlags = HideFlags.NotEditable;
}
data.param.Clear();
// check sheet
var sheet = book.GetSheet(sheetName);
if (sheet == null)
{
Debug.LogError("[QuestData] sheet not found:" + sheetName);
continue;
}
// add infomation
for (int i=1; i<= sheet.LastRowNum; i++)
{
IRow row = sheet.GetRow(i);
ICell cell = null;
var p = new Entity_saku_mst.Param();
cell = row.GetCell(0); p.id = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(1); p.typ = (cell == null ? "" : cell.StringCellValue);
cell = row.GetCell(2); p.name = (cell == null ? "" : cell.StringCellValue);
cell = row.GetCell(3); p.effection = (cell == null ? "" : cell.StringCellValue);
cell = row.GetCell(4); p.lv1 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(5); p.lv2 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(6); p.lv3 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(7); p.lv4 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(8); p.lv5 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(9); p.lv6 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(10); p.lv7 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(11); p.lv8 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(12); p.lv9 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(13); p.lv10 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(14); p.lv11 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(15); p.lv12 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(16); p.lv13 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(17); p.lv14 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(18); p.lv15 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(19); p.lv16 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(20); p.lv17 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(21); p.lv18 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(22); p.lv19 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(23); p.lv20 = (int)(cell == null ? 0 : cell.NumericCellValue);
data.param.Add(p);
}
// save scriptable object
ScriptableObject obj = AssetDatabase.LoadAssetAtPath(exportPath, typeof(ScriptableObject)) as ScriptableObject;
EditorUtility.SetDirty(obj);
}
}
}
}
static void OnPostprocessAllAssets(string[] importedAssets, string[] deletedAssets, string[] movedAssets, string[] movedFromAssetPaths)
{
foreach (string asset in importedAssets)
{
if (!filePath.Equals(asset))
{
continue;
}
using (FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read))
{
var book = new HSSFWorkbook(stream);
foreach (string sheetName in sheetNames)
{
var exportPath = "Assets/Resources/Data/" + sheetName + ".asset";
// check scriptable object
var data = (Entity_saku_mst)AssetDatabase.LoadAssetAtPath(exportPath, typeof(Entity_saku_mst));
if (data == null)
{
data = ScriptableObject.CreateInstance <Entity_saku_mst>();
AssetDatabase.CreateAsset((ScriptableObject)data, exportPath);
data.hideFlags = HideFlags.NotEditable;
}
data.param.Clear();
// check sheet
var sheet = book.GetSheet(sheetName);
if (sheet == null)
{
Debug.LogError("[QuestData] sheet not found:" + sheetName);
continue;
}
// add infomation
for (int i = 1; i <= sheet.LastRowNum; i++)
{
IRow row = sheet.GetRow(i);
ICell cell = null;
var p = new Entity_saku_mst.Param();
cell = row.GetCell(0); p.id = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(1); p.typ = (cell == null ? "" : cell.StringCellValue);
cell = row.GetCell(2); p.name = (cell == null ? "" : cell.StringCellValue);
cell = row.GetCell(3); p.effection = (cell == null ? "" : cell.StringCellValue);
cell = row.GetCell(4); p.lv1 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(5); p.lv2 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(6); p.lv3 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(7); p.lv4 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(8); p.lv5 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(9); p.lv6 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(10); p.lv7 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(11); p.lv8 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(12); p.lv9 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(13); p.lv10 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(14); p.lv11 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(15); p.lv12 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(16); p.lv13 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(17); p.lv14 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(18); p.lv15 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(19); p.lv16 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(20); p.lv17 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(21); p.lv18 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(22); p.lv19 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(23); p.lv20 = (int)(cell == null ? 0 : cell.NumericCellValue);
cell = row.GetCell(24); p.shipFlg = (cell == null ? false : cell.BooleanCellValue);
cell = row.GetCell(25); p.nameEng = (cell == null ? "" : cell.StringCellValue);
cell = row.GetCell(26); p.effectionEng = (cell == null ? "" : cell.StringCellValue);
data.param.Add(p);
}
// save scriptable object
ScriptableObject obj = AssetDatabase.LoadAssetAtPath(exportPath, typeof(ScriptableObject)) as ScriptableObject;
EditorUtility.SetDirty(obj);
}
}
}
}