public static async UniTask OverrideWeaponModuleData()
{
var sheet = await SpreadSheetLoader.LoadSheet(DefinedData.ApiKey, DefinedData.SheetID, "WeaponModuleDataOverride");
for (int i = 1; i < sheet.Values.Count; i++)
{
var row = sheet.Values[i];
var data = _weaponModuleDataArray.FirstOrDefault(item => item.name == row[0]);
if (!data)
{
continue;
}
if (row[1] == "")
{
continue;
}
while (row.Count < 9)
{
row.Add("");
}
SetData(row[2], ref data.ModuleName);
SetData(row[3], ref data.GuardPower);
SetData(row[4], ref data.Power);
SetData(row[5], ref data.Speed);
SetData(row[6], ref data.Size);
SetData(row[7], ref data.UseWaitSec);
SetData(row[8], ref data.IsAutoUse);
}
}
public static async UniTask OverrideWeaponData()
{
var sheet = await SpreadSheetLoader.LoadSheet(DefinedData.ApiKey, DefinedData.SheetID, "WeaponDataOverride");
for (int i = 1; i < sheet.Values.Count; i++)
{
var row = sheet.Values[i];
var data = _weaponDataArray.FirstOrDefault(item => item.name == row[0]);
if (!data)
{
continue;
}
if (row[1] == "")
{
continue;
}
while (row.Count < 4)
{
row.Add("");
}
SetData(row[2], ref data.DisplayName);
SetData(row[3], ref data.GuardPower);
}
}
IEnumerator Start()
{
while (SpreadSheetLoader.IsLoading)
{
yield return(null);
}
line1.text = _line1;
line2.text = _line2;
line3.text = _line3;
line4.text = _line4;
line5.text = _line5;
line6.text = _line6;
line7.text = _line7;
line8.text = _line8;
line9.text = _line9;
line10.text = _line10;
line11.text = _line11;
line12.text = _line12;
line13.text = _line13;
line14.text = _line14;
line15.text = _line15;
line16.text = _line16;
line17.text = _line17;
line18.text = _line18;
line19.text = _line19;
line20.text = _line20;
line21.text = _line21;
line22.text = _line22;
Debug.Log(" ArrayCount : " + SpreadSheetLoader.GetArrayCount().ToString());
Debug.LogFormat("_line1 = {0}", _line1);
Debug.LogFormat("_line2 = {0}", _line2);
Debug.LogFormat("_line3 = {0}", _line3);
Debug.LogFormat("_line4 = {0}", _line4);
Debug.LogFormat("_line5 = {0}", _line5);
Debug.LogFormat("_line6 = {0}", _line6);
Debug.LogFormat("_line7 = {0}", _line7);
Debug.LogFormat("_line8 = {0}", _line8);
Debug.LogFormat("_line9 = {0}", _line9);
Debug.LogFormat("_line10 = {0}", _line10);
Debug.LogFormat("_line11 = {0}", _line11);
Debug.LogFormat("_line12 = {0}", _line12);
Debug.LogFormat("_line13 = {0}", _line13);
Debug.LogFormat("_line14 = {0}", _line14);
Debug.LogFormat("_line15 = {0}", _line15);
Debug.LogFormat("_line16 = {0}", _line16);
Debug.LogFormat("_line17 = {0}", _line17);
Debug.LogFormat("_line18 = {0}", _line18);
Debug.LogFormat("_line19 = {0}", _line19);
Debug.LogFormat("_line20 = {0}", _line20);
Debug.LogFormat("_line21 = {0}", _line21);
Debug.LogFormat("_line22 = {0}", _line22);
}
public static bool ResourceLoadSpreadSheet(string _AssetPath
, ref List <string []> _Result
, bool _WithFirstLow
, ref string [] _FirstRow)
{
TextAsset ta = Resources.Load(_AssetPath) as TextAsset;
if (null == ta)
{
Debug.LogError("ResourceLoadSpreadSheet() null == ta _AssetPath=" + _AssetPath);
return(false);
}
return(SpreadSheetLoader.ParseSpreadSheet(ta.text
, ref _Result
, _WithFirstLow
, ref _FirstRow));
}
