123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609 |
- using Excel4Unity;
- using JamesGame;
- using System.Collections;
- using System.Collections.Generic;
- using System.IO;
- using System.Text;
- using UnityEngine;
- public class DataWriter
- {
- private const int StartRow = 4;
- private static string dirPath = "{0}tables/{1}.xlsx";
- private static void AddTypeSheet(Excel xls, string xlsName)
- {
- xls.AddTable("@Types");
- xls.Tables[1].SetValue(1, 1, string.Format("TableName: \"{0}\" Package: \"JamesGame\"", xlsName));
- }
- public static string ExchangeListInt(List<int> list, string sep)
- {
- StringBuilder sb = new StringBuilder();
- for (int i = 0; i < list.Count; ++i)
- {
- sb.Append(list[i]);
- if (i != list.Count - 1)
- {
- sb.Append(sep);
- }
- }
- return sb.ToString();
- }
- public static string ExchangeListString(List<string> list, string sep)
- {
- StringBuilder sb = new StringBuilder();
- for (int i = 0; i < list.Count; ++i)
- {
- sb.Append(list[i]);
- if (i != list.Count - 1)
- {
- sb.Append(sep);
- }
- }
- return sb.ToString();
- }
- public static string ExchangeListFloat(List<float> list, string sep)
- {
- StringBuilder sb = new StringBuilder();
- for (int i = 0; i < list.Count; ++i)
- {
- sb.Append(list[i]);
- if (i != list.Count - 1)
- {
- sb.Append(sep);
- }
- }
- return sb.ToString();
- }
- public static void SaveChallengeData(string xlsPath, string xlsName, Dictionary<int, ChallengeDataDefine> challengeDataCfgs)
- {
- string outputPath = string.Format(dirPath, xlsPath, xlsName);
- Excel xls = new Excel();
- xls.AddTable(xlsName);
- xls.Tables[0].SetValue(1, 1, "ID");
- xls.Tables[0].SetValue(1, 2, "FieldID");
- xls.Tables[0].SetValue(1, 3, "DecStaminaCnt");
- xls.Tables[0].SetValue(1, 4, "ConstraintType");
- xls.Tables[0].SetValue(1, 5, "ConstraintValue");
- xls.Tables[0].SetValue(1, 6, "Condition");
- xls.Tables[0].SetValue(1, 7, "Reward_ID_1");
- xls.Tables[0].SetValue(2, 1, "int32");
- xls.Tables[0].SetValue(2, 2, "int32");
- xls.Tables[0].SetValue(2, 3, "int32");
- xls.Tables[0].SetValue(2, 4, "int32");
- xls.Tables[0].SetValue(2, 5, "int32");
- xls.Tables[0].SetValue(2, 6, "repeated int32");
- xls.Tables[0].SetValue(2, 7, "int32");
- xls.Tables[0].SetValue(3, 1, "RepeatCheck:true MakeIndex:true");
- xls.Tables[0].SetValue(3, 6, "ListSpliter:\"#\"");
- xls.Tables[0].SetValue(3, 7, "Default: 0");
- xls.Tables[0].SetValue(4, 1, "关卡ID");
- int i = StartRow;
- foreach (var data in challengeDataCfgs.Values)
- {
- ++i;
- xls.Tables[0].SetValue(i, 1, data.ID);
- xls.Tables[0].SetValue(i, 2, data.FieldID);
- xls.Tables[0].SetValue(i, 3, data.DecStaminaCnt);
- xls.Tables[0].SetValue(i, 4, data.ConstraintType);
- xls.Tables[0].SetValue(i, 5, data.ConstraintValue);
- xls.Tables[0].SetValue(i, 6, ExchangeListInt(data.Condition, "#"));
- xls.Tables[0].SetValue(i, 7, data.Reward_ID_1);
- }
- AddTypeSheet(xls, xlsName);
- ExcelHelper.SaveExcel(xls, outputPath);
- }
- public static void SaveFieldData(string xlsPath, string xlsName, Dictionary<int, FieldDataDefine> fieldDataCfgs)
- {
- string outputPath = string.Format(dirPath, xlsPath, xlsName);
- Excel xls = new Excel();
- xls.AddTable(xlsName);
- xls.Tables[0].SetValue(1, 1, "ID");
- xls.Tables[0].SetValue(1, 2, "RoundFactorGroupID");
- xls.Tables[0].SetValue(1, 3, "FieldShapeID");
- xls.Tables[0].SetValue(1, 4, "DefaultPlayerPos");
- xls.Tables[0].SetValue(1, 5, "Mark");
- xls.Tables[0].SetValue(2, 1, "int32");
- xls.Tables[0].SetValue(2, 2, "int32");
- xls.Tables[0].SetValue(2, 3, "int32");
- xls.Tables[0].SetValue(2, 4, "repeated int32");
- xls.Tables[0].SetValue(2, 5, "string");
- xls.Tables[0].SetValue(3, 1, "RepeatCheck:true MakeIndex:true");
- xls.Tables[0].SetValue(3, 4, "ListSpliter:\"|\"");
- xls.Tables[0].SetValue(4, 1, "关卡ID");
- int i = StartRow;
- foreach (var data in fieldDataCfgs.Values)
- {
- ++i;
- xls.Tables[0].SetValue(i, 1, data.ID);
- xls.Tables[0].SetValue(i, 2, data.RoundFactorGroupID);
- xls.Tables[0].SetValue(i, 3, data.FieldShapeID);
- xls.Tables[0].SetValue(i, 4, ExchangeListInt(data.DefaultPlayerPos, "|"));
- xls.Tables[0].SetValue(i, 5, data.Mark);
- }
- AddTypeSheet(xls, xlsName);
- ExcelHelper.SaveExcel(xls, outputPath);
- }
- public static void SaveTargetData(string xlsPath, string xlsName, Dictionary<int, TargetDataDefine> targetDataCfgs)
- {
- string outputPath = string.Format(dirPath, xlsPath, xlsName);
- Excel xls = new Excel();
- xls.AddTable(xlsName);
- xls.Tables[0].SetValue(1, 1, "ID");
- xls.Tables[0].SetValue(1, 2, "ResourceName");
- xls.Tables[0].SetValue(1, 3, "Life");
- xls.Tables[0].SetValue(1, 4, "CtrlAniFileName");
- xls.Tables[0].SetValue(1, 5, "Attrib");
- xls.Tables[0].SetValue(1, 6, "CtrlAniStartDelay");
- xls.Tables[0].SetValue(1, 7, "Child");
- xls.Tables[0].SetValue(1, 8, "cNode");
- xls.Tables[0].SetValue(1, 9, "Material");
- xls.Tables[0].SetValue(1, 10, "Hit");
- xls.Tables[0].SetValue(1, 11, "Death");
- xls.Tables[0].SetValue(1, 12, "CtrlAniSpeed");
- xls.Tables[0].SetValue(1, 13, "Scale");
- xls.Tables[0].SetValue(1, 14, "DieRule");
- xls.Tables[0].SetValue(1, 15, "ReID");
- xls.Tables[0].SetValue(1, 16, "TargetPos");
- xls.Tables[0].SetValue(1, 17, "TargetRot");
- xls.Tables[0].SetValue(2, 1, "int32");
- xls.Tables[0].SetValue(2, 2, "string");
- xls.Tables[0].SetValue(2, 3, "int32");
- xls.Tables[0].SetValue(2, 4, "string");
- xls.Tables[0].SetValue(2, 5, "int32");
- xls.Tables[0].SetValue(2, 6, "float");
- xls.Tables[0].SetValue(2, 7, "string");
- xls.Tables[0].SetValue(2, 8, "string");
- xls.Tables[0].SetValue(2, 9, "int32");
- xls.Tables[0].SetValue(2, 10, "string");
- xls.Tables[0].SetValue(2, 11, "string");
- xls.Tables[0].SetValue(2, 12, "float");
- xls.Tables[0].SetValue(2, 13, "float");
- xls.Tables[0].SetValue(2, 14, "int32");
- xls.Tables[0].SetValue(2, 15, "int32");
- xls.Tables[0].SetValue(2, 16, "repeated float");
- xls.Tables[0].SetValue(2, 17, "repeated float");
- xls.Tables[0].SetValue(3, 1, "RepeatCheck:true MakeIndex:true");
- xls.Tables[0].SetValue(3, 16, "ListSpliter:\"|\"");
- xls.Tables[0].SetValue(3, 17, "ListSpliter:\"|\"");
- xls.Tables[0].SetValue(4, 1, "关卡ID");
- int i = StartRow;
- foreach (var data in targetDataCfgs.Values)
- {
- ++i;
- xls.Tables[0].SetValue(i, 1, data.ID);
- xls.Tables[0].SetValue(i, 2, data.ResourceName);
- xls.Tables[0].SetValue(i, 3, data.Life);
- xls.Tables[0].SetValue(i, 4, data.CtrlAniFileName.Equals("none")?"": data.CtrlAniFileName);
- xls.Tables[0].SetValue(i, 5, data.Attrib);
- xls.Tables[0].SetValue(i, 6, data.CtrlAniStartDelay);
- xls.Tables[0].SetValue(i, 7, data.Child.Equals("none")?"": data.Child);
- xls.Tables[0].SetValue(i, 8, data.cNode.Equals("none")?"" : data.cNode);
- xls.Tables[0].SetValue(i, 9, data.Material);
- xls.Tables[0].SetValue(i, 10, data.Hit.Equals("none")?"": data.Hit);
- xls.Tables[0].SetValue(i, 11, data.Death.Equals("none")?"" : data.Death);
- xls.Tables[0].SetValue(i, 12, data.CtrlAniSpeed);
- xls.Tables[0].SetValue(i, 13, data.Scale);
- xls.Tables[0].SetValue(i, 14, data.DieRule);
- xls.Tables[0].SetValue(i, 15, data.ReID);
- xls.Tables[0].SetValue(i, 16, ExchangeListFloat(data.TargetPos, "|"));
- xls.Tables[0].SetValue(i, 17, ExchangeListFloat(data.TargetRot, "|"));
- }
- AddTypeSheet(xls, xlsName);
- ExcelHelper.SaveExcel(xls, outputPath);
- }
- public static void SaveTargetGroupData(string xlsPath, string xlsName, Dictionary<int, TargetGroupDefine> targetGroupCfgs)
- {
- string outputPath = string.Format(dirPath, xlsPath, xlsName);
- Excel xls = new Excel();
- xls.AddTable(xlsName);
- xls.Tables[0].SetValue(1, 1, "ID");
- xls.Tables[0].SetValue(1, 2, "GroupID");
- xls.Tables[0].SetValue(1, 3, "TargetID");
- xls.Tables[0].SetValue(2, 1, "int32");
- xls.Tables[0].SetValue(2, 2, "int32");
- xls.Tables[0].SetValue(2, 3, "int32");
- xls.Tables[0].SetValue(3, 1, "RepeatCheck:true MakeIndex:true");
- xls.Tables[0].SetValue(4, 1, "关卡ID");
- int i = StartRow;
- foreach (var data in targetGroupCfgs.Values)
- {
- ++i;
- xls.Tables[0].SetValue(i, 1, data.ID);
- xls.Tables[0].SetValue(i, 2, data.GroupID);
- xls.Tables[0].SetValue(i, 3, data.TargetID);
- }
- AddTypeSheet(xls, xlsName);
- ExcelHelper.SaveExcel(xls, outputPath);
- }
- public static void SaveFieldShapeData(string xlsPath, string xlsName, Dictionary<int, FieldShapeDataDefine> fieldShapeCfgs)
- {
- string outputPath = string.Format(dirPath, xlsPath, xlsName);
- Excel xls = new Excel();
- xls.AddTable(xlsName);
- xls.Tables[0].SetValue(1, 1, "ID");
- xls.Tables[0].SetValue(1, 2, "ResourceName");
- xls.Tables[0].SetValue(1, 3, "EnvSoundName");
- xls.Tables[0].SetValue(1, 4, "EnvParticleName");
- xls.Tables[0].SetValue(1, 5, "AttendAnim");
- xls.Tables[0].SetValue(1, 6, "LoadMethod");
- xls.Tables[0].SetValue(2, 1, "int32");
- xls.Tables[0].SetValue(2, 2, "string");
- xls.Tables[0].SetValue(2, 3, "string");
- xls.Tables[0].SetValue(2, 4, "string");
- xls.Tables[0].SetValue(2, 5, "repeated string");
- xls.Tables[0].SetValue(2, 6, "int32");
- xls.Tables[0].SetValue(3, 1, "RepeatCheck:true MakeIndex:true");
- xls.Tables[0].SetValue(3, 5, "ListSpliter:\"#\"");
- xls.Tables[0].SetValue(4, 1, "关卡ID");
- xls.Tables[0].SetValue(4, 5, "开场动画,多选一");
- int i = StartRow;
- foreach (var data in fieldShapeCfgs.Values)
- {
- ++i;
- xls.Tables[0].SetValue(i, 1, data.ID);
- xls.Tables[0].SetValue(i, 2, data.ResourceName);
- xls.Tables[0].SetValue(i, 3, data.EnvSoundName);
- xls.Tables[0].SetValue(i, 4, data.EnvParticleName);
- xls.Tables[0].SetValue(i, 5, ExchangeListString(data.AttendAnim, "#"));
- xls.Tables[0].SetValue(i, 6, data.LoadMethod);
- }
- AddTypeSheet(xls, xlsName);
- ExcelHelper.SaveExcel(xls, outputPath);
- }
- public static void SaveLevelData(string xlsPath, string xlsName, Dictionary<int, LevelDefine> levelCfgs)
- {
- string outputPath = string.Format(dirPath, xlsPath, xlsName);
- Excel xls = new Excel();
- xls.AddTable(xlsName);
- xls.Tables[0].SetValue(1, 1, "ID");
- xls.Tables[0].SetValue(1, 2, "coinsStar1");
- xls.Tables[0].SetValue(1, 3, "coinsStar2");
- xls.Tables[0].SetValue(1, 4, "coinsStar3");
- xls.Tables[0].SetValue(1, 5, "coinsBullet");
- xls.Tables[0].SetValue(1, 6, "coinsCombo");
- xls.Tables[0].SetValue(1, 7, "fittedWeapon");
- xls.Tables[0].SetValue(1, 8, "roundTargetIds");
- xls.Tables[0].SetValue(1, 9, "timeTargetPrice");
- xls.Tables[0].SetValue(1, 10, "rewardedItems");
- xls.Tables[0].SetValue(1, 11, "crownPower");
- xls.Tables[0].SetValue(1, 12, "posX");
- xls.Tables[0].SetValue(1, 13, "posY");
- xls.Tables[0].SetValue(1, 14, "posZ");
- xls.Tables[0].SetValue(1, 15, "rotX");
- xls.Tables[0].SetValue(1, 16, "rotY");
- xls.Tables[0].SetValue(1, 17, "rotZ");
- xls.Tables[0].SetValue(1, 18, "gameType");
- xls.Tables[0].SetValue(1, 19, "realID");
- xls.Tables[0].SetValue(1, 20, "offsetX");
- xls.Tables[0].SetValue(1, 21, "offsetY");
- xls.Tables[0].SetValue(1, 22, "offsetZ");
- xls.Tables[0].SetValue(1, 23, "attendAnims");
- xls.Tables[0].SetValue(1, 24, "fov");
- xls.Tables[0].SetValue(1, 25, "shadowPlane");
- xls.Tables[0].SetValue(1, 26, "windMin");
- xls.Tables[0].SetValue(1, 27, "windMax");
- xls.Tables[0].SetValue(1, 28, "windChange");
- xls.Tables[0].SetValue(1, 29, "dungonCondition");
- xls.Tables[0].SetValue(1, 30, "dungonBattleRewards");
- xls.Tables[0].SetValue(1, 31, "rankTargetScore");
- xls.Tables[0].SetValue(1, 32, "openRigiBody");
- xls.Tables[0].SetValue(1, 33, "moveRigiBody");
- xls.Tables[0].SetValue(1, 34, "AttributeTypeData");
- xls.Tables[0].SetValue(1, 35, "AttributeValueData");
- xls.Tables[0].SetValue(2, 1, "int32");
- xls.Tables[0].SetValue(2, 2, "int32");
- xls.Tables[0].SetValue(2, 3, "int32");
- xls.Tables[0].SetValue(2, 4, "int32");
- xls.Tables[0].SetValue(2, 5, "int32");
- xls.Tables[0].SetValue(2, 6, "int32");
- xls.Tables[0].SetValue(2, 7, "int32");
- xls.Tables[0].SetValue(2, 8, "string");
- xls.Tables[0].SetValue(2, 9, "string");
- xls.Tables[0].SetValue(2, 10, "string");
- xls.Tables[0].SetValue(2, 11, "int32");
- xls.Tables[0].SetValue(2, 12, "float");
- xls.Tables[0].SetValue(2, 13, "float");
- xls.Tables[0].SetValue(2, 14, "float");
- xls.Tables[0].SetValue(2, 15, "float");
- xls.Tables[0].SetValue(2, 16, "float");
- xls.Tables[0].SetValue(2, 17, "float");
- xls.Tables[0].SetValue(2, 18, "int32");
- xls.Tables[0].SetValue(2, 19, "int32");
- xls.Tables[0].SetValue(2, 20, "float");
- xls.Tables[0].SetValue(2, 21, "float");
- xls.Tables[0].SetValue(2, 22, "float");
- xls.Tables[0].SetValue(2, 23, "repeated string");
- xls.Tables[0].SetValue(2, 24, "int32");
- xls.Tables[0].SetValue(2, 25, "float");
- xls.Tables[0].SetValue(2, 26, "float");
- xls.Tables[0].SetValue(2, 27, "float");
- xls.Tables[0].SetValue(2, 28, "int32");
- xls.Tables[0].SetValue(2, 29, "int32");
- xls.Tables[0].SetValue(2, 30, "repeated string");
- xls.Tables[0].SetValue(2, 31, "int32");
- xls.Tables[0].SetValue(2, 32, "repeated string");
- xls.Tables[0].SetValue(2, 33, "repeated string");
- xls.Tables[0].SetValue(2, 34, "repeated int32");
- xls.Tables[0].SetValue(2, 35, "repeated int32");
- xls.Tables[0].SetValue(3, 1, "RepeatCheck:true MakeIndex:true");
- xls.Tables[0].SetValue(3, 5, "Default: 0");
- xls.Tables[0].SetValue(3, 23, "ListSpliter:\"#\"");
- xls.Tables[0].SetValue(3, 30, "ListSpliter:\"|\"");
- xls.Tables[0].SetValue(3, 32, "ListSpliter:\"|\"");
- xls.Tables[0].SetValue(3, 33, "ListSpliter:\"|\"");
- xls.Tables[0].SetValue(3, 34, "ListSpliter:\"#\"");
- xls.Tables[0].SetValue(3, 35, "ListSpliter:\"#\"");
- xls.Tables[0].SetValue(4, 1, "关卡ID");
- xls.Tables[0].SetValue(4, 30, "格式 ID:Type:Count,(Type: 0:金币1:女助手碎片2:武器碎片3:天赋点)");
- xls.Tables[0].SetValue(4, 32, "打开刚体,用|分隔每组,用&分隔破碎id和一系列刚体,刚体之间用;分隔");
- xls.Tables[0].SetValue(4, 33, "打开刚体,用|分隔每组,用&分隔破碎id和一系列刚体,刚体之间用;分隔");
- xls.Tables[0].SetValue(4, 34, "推荐的属性类别");
- xls.Tables[0].SetValue(4, 35, "推荐的属性值");
- int i = StartRow;
- foreach (var data in levelCfgs.Values)
- {
- ++i;
- xls.Tables[0].SetValue(i, 1, data.ID);
- xls.Tables[0].SetValue(i, 2, data.coinsStar1);
- xls.Tables[0].SetValue(i, 3, data.coinsStar2);
- xls.Tables[0].SetValue(i, 4, data.coinsStar3);
- xls.Tables[0].SetValue(i, 5, data.coinsBullet);
- xls.Tables[0].SetValue(i, 6, data.coinsCombo);
- xls.Tables[0].SetValue(i, 7, data.fittedWeapon);
- xls.Tables[0].SetValue(i, 8, data.roundTargetIds);
- xls.Tables[0].SetValue(i, 9, data.timeTargetPrice);
- xls.Tables[0].SetValue(i, 10, data.rewardedItems);
- xls.Tables[0].SetValue(i, 11, data.crownPower);
- xls.Tables[0].SetValue(i, 12, data.posX);
- xls.Tables[0].SetValue(i, 13, data.posY);
- xls.Tables[0].SetValue(i, 14, data.posZ);
- xls.Tables[0].SetValue(i, 15, data.rotX);
- xls.Tables[0].SetValue(i, 16, data.rotY);
- xls.Tables[0].SetValue(i, 17, data.rotZ);
- xls.Tables[0].SetValue(i, 18, data.gameType);
- xls.Tables[0].SetValue(i, 19, data.realID);
- xls.Tables[0].SetValue(i, 20, data.offsetX);
- xls.Tables[0].SetValue(i, 21, data.offsetY);
- xls.Tables[0].SetValue(i, 22, data.offsetZ);
- xls.Tables[0].SetValue(i, 23, ExchangeListString(data.attendAnims, "#"));
- xls.Tables[0].SetValue(i, 24, data.fov);
- xls.Tables[0].SetValue(i, 25, data.shadowPlane);
- xls.Tables[0].SetValue(i, 26, data.windMin);
- xls.Tables[0].SetValue(i, 27, data.windMax);
- xls.Tables[0].SetValue(i, 28, data.windChange);
- xls.Tables[0].SetValue(i, 29, data.dungonCondition);
- xls.Tables[0].SetValue(i, 30, ExchangeListString(data.dungonBattleRewards, "|"));
- xls.Tables[0].SetValue(i, 31, data.rankTargetScore);
- xls.Tables[0].SetValue(i, 32, ExchangeListString(data.openRigiBody, "|"));
- xls.Tables[0].SetValue(i, 33, ExchangeListString(data.moveRigiBody, "|"));
- xls.Tables[0].SetValue(i, 34, ExchangeListInt(data.AttributeTypeData, "#"));
- xls.Tables[0].SetValue(i, 35, ExchangeListInt(data.AttributeValueData, "#"));
- }
- AddTypeSheet(xls, xlsName);
- ExcelHelper.SaveExcel(xls, outputPath);
- }
- //public static void SaveDungonInfoData(string xlsPath, string xlsName, List<DungonInfoDefine> dungonInfoCfgs)
- //{
- // string outputPath = string.Format(dirPath, xlsPath, xlsName);
- // Excel xls = new Excel();
- // xls.AddTable(xlsName);
- // xls.Tables[0].SetValue(1, 1, "ID");
- // xls.Tables[0].SetValue(1, 2, "openNumber");
- // xls.Tables[0].SetValue(1, 3, "brokenNumber");
- // xls.Tables[0].SetValue(1, 4, "seeNumber");
- // xls.Tables[0].SetValue(1, 5, "posX");
- // xls.Tables[0].SetValue(1, 6, "posY");
- // xls.Tables[0].SetValue(1, 7, "posZ");
- // xls.Tables[0].SetValue(1, 8, "rowNum");
- // xls.Tables[0].SetValue(2, 1, "int32");
- // xls.Tables[0].SetValue(2, 2, "repeated int32");
- // xls.Tables[0].SetValue(2, 3, "repeated int32");
- // xls.Tables[0].SetValue(2, 4, "repeated int32");
- // xls.Tables[0].SetValue(2, 5, "float");
- // xls.Tables[0].SetValue(2, 6, "float");
- // xls.Tables[0].SetValue(2, 7, "float");
- // xls.Tables[0].SetValue(2, 8, "int32");
- // xls.Tables[0].SetValue(3, 1, "RepeatCheck:true MakeIndex:true");
- // xls.Tables[0].SetValue(3, 2, "ListSpliter:\"|\"");
- // xls.Tables[0].SetValue(3, 3, "ListSpliter:\"|\"");
- // xls.Tables[0].SetValue(3, 4, "ListSpliter:\"|\"");
- // xls.Tables[0].SetValue(3, 8, "Default: 0");
- // xls.Tables[0].SetValue(4, 1, "编号");
- // xls.Tables[0].SetValue(4, 2, "可打开的编号");
- // xls.Tables[0].SetValue(4, 3, "可破碎的编号");
- // xls.Tables[0].SetValue(4, 4, "可看到的编号");
- // xls.Tables[0].SetValue(4, 8, "所属行号");
- // int i = StartRow;
- // foreach (var data in dungonInfoCfgs)
- // {
- // ++i;
- // xls.Tables[0].SetValue(i, 1, data.ID);
- // xls.Tables[0].SetValue(i, 2, ExchangeListInt(data.openNumber, "|"));
- // xls.Tables[0].SetValue(i, 3, ExchangeListInt(data.brokenNumber, "|"));
- // xls.Tables[0].SetValue(i, 4, ExchangeListInt(data.seeNumber, "|"));
- // xls.Tables[0].SetValue(i, 5, data.posX);
- // xls.Tables[0].SetValue(i, 6, data.posY);
- // xls.Tables[0].SetValue(i, 7, data.posZ);
- // xls.Tables[0].SetValue(i, 8, 0);
- // }
- // AddTypeSheet(xls, xlsName);
- // ExcelHelper.SaveExcel(xls, outputPath);
- //}
- //public static void SaveDungonMapData(string xlsPath, string xlsName, Dictionary<int, DungonMapEditor.DungonMapParam> dungonMapCfgs)
- //{
- // string outputPath = string.Format(dirPath, xlsPath, xlsName);
- // Excel xls = new Excel();
- // xls.AddTable(xlsName);
- // xls.Tables[0].SetValue(1, 1, "ID");
- // xls.Tables[0].SetValue(1, 2, "mapContent");
- // xls.Tables[0].SetValue(1, 3, "backgroundHeight");
- // xls.Tables[0].SetValue(2, 1, "int32");
- // xls.Tables[0].SetValue(2, 2, "repeated int32");
- // xls.Tables[0].SetValue(2, 3, "int32");
- // xls.Tables[0].SetValue(3, 1, "RepeatCheck:true MakeIndex:true");
- // xls.Tables[0].SetValue(3, 2, "ListSpliter:\"|\"");
- // xls.Tables[0].SetValue(4, 1, "阵型id");
- // xls.Tables[0].SetValue(4, 2, "阵型的内容用|分隔");
- // xls.Tables[0].SetValue(4, 3, "背景的高度");
- // int i = StartRow;
- // foreach (var data in dungonMapCfgs)
- // {
- // ++i;
- // xls.Tables[0].SetValue(i, 1, data.Key);
- // xls.Tables[0].SetValue(i, 2, data.Value.content);
- // xls.Tables[0].SetValue(i, 3, data.Value.height);
- // }
- // AddTypeSheet(xls, xlsName);
- // ExcelHelper.SaveExcel(xls, outputPath);
- //}
- //public static void SaveRankRobotData(string xlsPath, string xlsName, Dictionary<int, RankingDataEditor.RankRobotData> rankRobotDatas)
- //{
- // string outputPath = string.Format(dirPath, xlsPath, xlsName);
- // Excel xls = new Excel();
- // xls.AddTable(xlsName);
- // xls.Tables[0].SetValue(1, 1, "id");
- // xls.Tables[0].SetValue(1, 2, "robotName");
- // xls.Tables[0].SetValue(1, 3, "robotSerNum");
- // xls.Tables[0].SetValue(1, 4, "robotCountry");
- // xls.Tables[0].SetValue(1, 5, "robotstep");
- // xls.Tables[0].SetValue(1, 6, "stepCount");
- // xls.Tables[0].SetValue(1, 7, "periodNum");
- // xls.Tables[0].SetValue(1, 8, "baseTime");
- // xls.Tables[0].SetValue(2, 1, "int32");
- // xls.Tables[0].SetValue(2, 2, "string");
- // xls.Tables[0].SetValue(2, 3, "string");
- // xls.Tables[0].SetValue(2, 4, "string");
- // xls.Tables[0].SetValue(2, 5, "int32");
- // xls.Tables[0].SetValue(2, 6, "int32");
- // xls.Tables[0].SetValue(2, 7, "int32");
- // xls.Tables[0].SetValue(2, 8, "int32");
- // xls.Tables[0].SetValue(3, 1, "RepeatCheck:true MakeIndex:true");
- // xls.Tables[0].SetValue(4, 1, "ID");
- // xls.Tables[0].SetValue(4, 2, "机器人名称");
- // xls.Tables[0].SetValue(4, 3, "机器人的序列号");
- // xls.Tables[0].SetValue(4, 4, "机器人国家");
- // xls.Tables[0].SetValue(4, 5, "机器人步长");
- // xls.Tables[0].SetValue(4, 6, "步长次数");
- // xls.Tables[0].SetValue(4, 7, "所属号段");
- // xls.Tables[0].SetValue(4, 8, "基础时间");
- // int i = StartRow;
- // foreach (var data in rankRobotDatas)
- // {
- // ++i;
- // xls.Tables[0].SetValue(i, 1, data.Key);
- // xls.Tables[0].SetValue(i, 3, data.Value.robotSerNum);
- // xls.Tables[0].SetValue(i, 4, data.Value.robotCountry);
- // xls.Tables[0].SetValue(i, 7, data.Value.periodNum);
- // xls.Tables[0].SetValue(i, 8, data.Value.baseTime);
- // }
- // AddTypeSheet(xls, xlsName);
- // ExcelHelper.SaveExcel(xls, outputPath);
- //}
- public static void SaveTestPracticleData(string xlsPath, string xlsName, List<EffectReport> reports)
- {
- string outputPath = string.Format(dirPath, xlsPath, xlsName);
- Excel xls = new Excel();
- xls.AddTable(xlsName);
- xls.Tables[0].SetValue(1, 1, "effectName");
- xls.Tables[0].SetValue(1, 2, "fpsNum");
- xls.Tables[0].SetValue(1, 3, "loadTime");
- xls.Tables[0].SetValue(1, 4, "createTime");
- xls.Tables[0].SetValue(1, 5, "minRenderTime");
- xls.Tables[0].SetValue(1, 6, "maxRenderTime");
- xls.Tables[0].SetValue(1, 7, "topFramesAvgRenderTime");
- xls.Tables[0].SetValue(1, 8, "maxRenderOccurTime");
- xls.Tables[0].SetValue(1, 9, "activeRenderCount");
- xls.Tables[0].SetValue(1, 10, "totalPsCount");
- xls.Tables[0].SetValue(1, 11, "materialCount");
- xls.Tables[0].SetValue(1, 12, "maxParticleCount");
- xls.Tables[0].SetValue(1, 13, "texMemBytes");
- xls.Tables[0].SetValue(1, 14, "texMemCount");
- xls.Tables[0].SetValue(2, 1, "特效名称");
- xls.Tables[0].SetValue(2, 2, "帧数");
- xls.Tables[0].SetValue(2, 3, "加载时间(毫秒)");
- xls.Tables[0].SetValue(2, 4, "实例化时间(毫秒)");
- xls.Tables[0].SetValue(2, 5, "最小渲染时间");
- xls.Tables[0].SetValue(2, 6, "最大渲染时间");
- xls.Tables[0].SetValue(2, 7, "duration内N帧的平均时间");
- xls.Tables[0].SetValue(2, 8, "最耗时的一帧发生在第几秒");
- xls.Tables[0].SetValue(2, 9, "激活的渲染器数量");
- xls.Tables[0].SetValue(2, 10, "粒子系统数量(只统计激活的)");
- xls.Tables[0].SetValue(2, 11, "材质数量");
- xls.Tables[0].SetValue(2, 12, "最大粒子数量");
- xls.Tables[0].SetValue(2, 13, "贴图大小(KB)");
- xls.Tables[0].SetValue(2, 14, "贴图数量");
- int i = StartRow;
- foreach (var data in reports)
- {
- ++i;
- xls.Tables[0].SetValue(i, 1, data.effectName);
- xls.Tables[0].SetValue(i, 2, data.fpsNum);
- xls.Tables[0].SetValue(i, 3, data.loadTime);
- xls.Tables[0].SetValue(i, 4, data.createTime);
- xls.Tables[0].SetValue(i, 5, data.minRenderTime);
- xls.Tables[0].SetValue(i, 6, data.maxRenderTime);
- xls.Tables[0].SetValue(i, 7, data.topFramesAvgRenderTime);
- xls.Tables[0].SetValue(i, 8, data.maxRenderOccurTime);
- xls.Tables[0].SetValue(i, 9, data.activeRenderCount);
- xls.Tables[0].SetValue(i, 10, data.totalPsCount);
- xls.Tables[0].SetValue(i, 11, data.materialCount);
- xls.Tables[0].SetValue(i, 12, data.maxParticleCount);
- xls.Tables[0].SetValue(i, 13, data.texMemBytes);
- xls.Tables[0].SetValue(i, 14, data.texMemCount);
- }
- ExcelHelper.SaveExcel(xls, outputPath);
- }
- }
|