public void ReadXml(string fileName)
{
string sheetName = "Sheet1";
Workbook workbook = Workbook.CreatWorkbook(fileName, sheetName);
Sheet sheet = workbook._sheet;
if (sheet == null)
{
Debug.LogError("Can't find " + sheetName + " in " + fileName);
return;
}
Dictionary <string, List <LanguageTextEntry> > languages = new Dictionary <string, List <LanguageTextEntry> >();
List <string> langKeys = sheet._rows[0]._cells;
for (int i = 1; i < langKeys.Count; i++)
{
string lang = langKeys[i];
languages.Add(lang, new List <LanguageTextEntry>());
}
for (int i = 1; i < sheet._rows.Count; i++)
{
Row row = sheet._rows[i];
string IDS = row._cells[0];
for (int j = 1; j < row._cells.Count; j++)
{
LanguageTextEntry textEntry = new LanguageTextEntry();
textEntry.key = IDS;
textEntry.text = row._cells[j];
string lang = row._key[j];
List <LanguageTextEntry> textEntryList = languages[lang];
textEntryList.Add(textEntry);
}
}
for (int i = 1; i < langKeys.Count; i++)
{
string lang = langKeys[i];
List <LanguageTextEntry> textEntryList = languages[lang];
string path = MultiLanguageAssetPostProcessor.MULTILANGUAGE_ASSETS_FOLDER;
LocalizationEditorUtils.CreateDirectoryIfNotExist(path, "Fonts", lang);
// Create config file that contain key-value strings.
CreateLanguageDataBase(lang, textEntryList);
// Create config file that contain uv and size information.
CreateLanguageDictionary(lang, textEntryList);
}
}
public static void ReadMonthCard()
{
Workbook workbook = Workbook.CreatWorkbook(fileName, sheetName1);
Sheet sheet = workbook._sheet;
if (sheet == null)
{
Debug.LogError("Can't find " + sheetName1 + " in " + fileName);
return;
}
bool newFile = false;
MonthCardIAP dataList = null;
UnityEngine.Object oldFile = AssetDatabase.LoadAssetAtPath(outFileName1, typeof(MonthCardIAP));
if (oldFile == null)
{
newFile = true;
dataList = ScriptableObject.CreateInstance(typeof(MonthCardIAP)) as MonthCardIAP;
}
else
{
dataList = oldFile as MonthCardIAP;
}
Row data = sheet._rows[1];
dataList.iap_id = data["iap_id"];
dataList.count = GetInt(data["count"]);
if (newFile)
{
AssetDatabase.CreateAsset(dataList, outFileName1);
}
else
{
EditorUtility.SetDirty(dataList);
}
}
public static void ReadWeight(string sheetName, string outFileFolder, string outFileName)
{
Workbook workbook = Workbook.CreatWorkbook(fileName, sheetName);
Sheet sheet = workbook._sheet;
if (sheet == null)
{
Debug.LogError("Can't find " + sheetName + " in " + fileName);
return;
}
bool newFile = false;
HeroEquipmentWeight dataList = null;
UnityEngine.Object oldFile = AssetDatabase.LoadAssetAtPath(outFileName, typeof(HeroEquipmentWeight));
if (oldFile == null)
{
newFile = true;
dataList = ScriptableObject.CreateInstance(typeof(HeroEquipmentWeight)) as HeroEquipmentWeight;
}
else
{
dataList = oldFile as HeroEquipmentWeight;
}
dataList._weaponWeight = ScriptableObject.CreateInstance <PropertyWeightDataList>();
dataList._helmWeight = ScriptableObject.CreateInstance <PropertyWeightDataList>();
dataList._shoulderWeight = ScriptableObject.CreateInstance <PropertyWeightDataList>();
dataList._beltWeight = ScriptableObject.CreateInstance <PropertyWeightDataList>();
dataList._armpieceWeight = ScriptableObject.CreateInstance <PropertyWeightDataList>();
dataList._leggingsWeight = ScriptableObject.CreateInstance <PropertyWeightDataList>();
dataList._necklaceWeight = ScriptableObject.CreateInstance <PropertyWeightDataList>();
dataList._ringWeight = ScriptableObject.CreateInstance <PropertyWeightDataList>();
for (int i = 1; i < sheet._rows.Count; i++)
{
Row data = sheet._rows[i];
PropertyWeightData newData = new PropertyWeightData();
newData._type = GetHitParam(data["WeaponType"]);
newData._weight = GetInt(data["WeaponWeight"]);
if (newData._type != AIHitParams.None && newData._weight > 0)
{
dataList._weaponWeight._dataList.Add(newData);
}
PropertyWeightData newData1 = new PropertyWeightData();
newData1._type = GetHitParam(data["HelmType"]);
newData1._weight = GetInt(data["HelmWeight"]);
if (newData1._type != AIHitParams.None && newData1._weight > 0)
{
dataList._helmWeight._dataList.Add(newData1);
}
PropertyWeightData newData2 = new PropertyWeightData();
newData2._type = GetHitParam(data["ShoulderType"]);
newData2._weight = GetInt(data["ShoulderWeight"]);
if (newData2._type != AIHitParams.None && newData2._weight > 0)
{
dataList._shoulderWeight._dataList.Add(newData2);
}
PropertyWeightData newData3 = new PropertyWeightData();
newData3._type = GetHitParam(data["BeltType"]);
newData3._weight = GetInt(data["BeltWeight"]);
if (newData3._type != AIHitParams.None && newData3._weight > 0)
{
dataList._beltWeight._dataList.Add(newData3);
}
PropertyWeightData newData4 = new PropertyWeightData();
newData4._type = GetHitParam(data["ArmpieceType"]);
newData4._weight = GetInt(data["ArmpieceWeight"]);
if (newData4._type != AIHitParams.None && newData4._weight > 0)
{
dataList._armpieceWeight._dataList.Add(newData4);
}
PropertyWeightData newData5 = new PropertyWeightData();
newData5._type = GetHitParam(data["LeggingsType"]);
newData5._weight = GetInt(data["LeggingsWeight"]);
if (newData5._type != AIHitParams.None && newData5._weight > 0)
{
dataList._leggingsWeight._dataList.Add(newData5);
}
PropertyWeightData newData6 = new PropertyWeightData();
newData6._type = GetHitParam(data["NecklaceType"]);
newData6._weight = GetInt(data["NecklaceWeight"]);
if (newData6._type != AIHitParams.None && newData6._weight > 0)
{
dataList._necklaceWeight._dataList.Add(newData6);
}
PropertyWeightData newData7 = new PropertyWeightData();
newData7._type = GetHitParam(data["RingType"]);
newData7._weight = GetInt(data["RingWeight"]);
if (newData7._type != AIHitParams.None && newData7._weight > 0)
{
dataList._ringWeight._dataList.Add(newData7);
}
}
CreateWeightScriptObject(dataList._weaponWeight, outFileFolder, "weaponWeight");
CreateWeightScriptObject(dataList._helmWeight, outFileFolder, "helmWeight");
CreateWeightScriptObject(dataList._shoulderWeight, outFileFolder, "shoulderWeight");
CreateWeightScriptObject(dataList._armpieceWeight, outFileFolder, "armpieceWeight");
CreateWeightScriptObject(dataList._beltWeight, outFileFolder, "beltWeight");
CreateWeightScriptObject(dataList._leggingsWeight, outFileFolder, "leggingsWeight");
CreateWeightScriptObject(dataList._necklaceWeight, outFileFolder, "necklaceWeight");
CreateWeightScriptObject(dataList._ringWeight, outFileFolder, "ringWeight");
if (newFile)
{
AssetDatabase.CreateAsset(dataList, outFileName);
}
else
{
EditorUtility.SetDirty(dataList);
}
}
public static void Read()
{
Workbook workbook = Workbook.CreatWorkbook(fileName, sheetName);
Sheet sheet = workbook._sheet;
if (sheet == null)
{
Debug.LogError("Can't find " + sheetName + " in " + fileName);
return;
}
bool newFile = false;
StoreDataList dataList = null;
UnityEngine.Object oldFile = AssetDatabase.LoadAssetAtPath(outFileName, typeof(StoreDataList));
if (oldFile == null)
{
newFile = true;
dataList = ScriptableObject.CreateInstance(typeof(StoreDataList)) as StoreDataList;
}
else
{
dataList = oldFile as StoreDataList;
}
dataList._dataList.Clear();
for (int i = 1; i < sheet._rows.Count; i++)
{
Row data = sheet._rows[i];
StoreData newData = new StoreData();
newData._id = data["id"];
newData._displayNameIds = data["displayNameIds"];
newData._order = GetInt(data["order"]);
newData._isVisibleOnStore = GetBool(data["isVisibleOnStore"]);
newData._visibleLevelMin = GetInt(data["visibleLevelMin"]);
newData._visibleLevelMax = GetInt(data["visibleLevelMax"]);
newData._order = GetInt(data["order"]);
newData._visibleStartTime = data["visibleStartTime"];
newData._visibleEndTime = data["visibleEndTime"];
newData._isRecommend = GetBool(data["isRecommend"]);
newData._isNew = GetBool(data["isNew"]);
newData._discount = GetFloat(data["discount"]);
newData._discountStartTime = data["discountStartTime"];
newData._discountEndTime = data["discountEndTime"];
newData._storeType = GetStoreItemType(data["storeType"]);
newData._storeIconName = data["storeIconName"];
newData._normalInfo._itemID = data["itemID"];
newData._normalInfo._count = GetInt(data["count"]);
newData._normalInfo._hardCurrency = GetInt(data["hardCurrency"]);
newData._normalInfo._softCurrency = GetInt(data["softCurrency"]);
newData._normalInfo._dissountHardCurrency = GetInt(data["dissountHardCurrency"]);
newData._normalInfo._discountSoftCurrency = GetInt(data["discountSoftCurrency"]);
newData._iapInfo._iapId = data["iapId"];
newData._iapInfo._iapIdAndroid = data["iapIdAndroid"];
newData._iapInfo._hcCount = GetInt(data["hcCount"]);
newData._iapInfo._scCount = GetInt(data["scCount"]);
newData._iapInfo._bonusCount = GetInt(data["bonusCount"]);
newData._iapInfo._discountHcCount = GetInt(data["discountHcCount"]);
newData._iapInfo._discountScCount = GetInt(data["discountScCount"]);
newData._iapInfo._discountBonusCount = GetInt(data["discountBonusCount"]);
newData._iapInfo._USD_price = GetInt(data["USD_price"]);
dataList._dataList.Add(newData);
}
if (newFile)
{
AssetDatabase.CreateAsset(dataList, outFileName);
}
else
{
EditorUtility.SetDirty(dataList);
}
}
public static void Read()
{
Workbook workbook = Workbook.CreatWorkbook(fileName, sheetName);
Sheet sheet = workbook._sheet;
if (sheet == null)
{
Debug.LogError("Can't find " + sheetName + " in " + fileName);
return;
}
bool newFile = false;
SocketDataList dataList = null;
UnityEngine.Object oldFile = AssetDatabase.LoadAssetAtPath(outFileName, typeof(SocketDataList));
if (oldFile == null)
{
newFile = true;
dataList = ScriptableObject.CreateInstance(typeof(SocketDataList)) as SocketDataList;
}
else
{
dataList = oldFile as SocketDataList;
}
dataList._dataList.Clear();
for (int i = 1; i < sheet._rows.Count; i++)
{
Row data = sheet._rows[i];
SocketData newData = new SocketData();
newData._level = GetInt(data["level"]);
newData._rareLevel = GetInt(data["rareLevel"]);
for (int k = 1; k <= 2; k++)
{
int sc = GetInt(data["socketSc" + k]);
int hc = GetInt(data["socketHc" + k]);
string itemId = data["socketItemId" + k];
if (itemId.Length > 1)
{
SocketNeed need = new SocketNeed();
need._itemId = itemId;
need._sc = sc;
need._hc = hc;
newData._need.Add(need);
}
}
dataList._dataList.Add(newData);
}
if (newFile)
{
AssetDatabase.CreateAsset(dataList, outFileName);
}
else
{
EditorUtility.SetDirty(dataList);
}
}