public static void CreateWorksheet(ExcelWorksheets wss)
{
ExcelWorksheet ws = wss.Add("每个所包含的具体资源");
// 标签颜色
ws.TabColor = ColorTranslator.FromHtml("#f9c40f");
AssetBundleReporter.CreateWorksheetBase(ws, "每个 AssetBundle 文件所包含的具体资源", 4);
// 列宽
ws.Column(1).Width = 50;
ws.Column(2).Width = 50;
ws.Column(3).Width = 50;
ws.Column(4).Width = 50;
}
public static void CreateWorksheet(ExcelWorksheets wss)
{
ExcelWorksheet ws = wss.Add("AB文件列表");
// 标签颜色
ws.TabColor = ColorTranslator.FromHtml("#32b1fa");
AssetBundleReporter.CreateWorksheetBase(ws, "AssetBundle 文件列表", 11);
// 列头
int colIndex = 1;
ws.Cells[2, colIndex++].Value = "AssetBundle 名称";
ws.Cells[2, colIndex++].Value = "文件大小";
ws.Cells[2, colIndex++].Value = "依赖AB数";
ws.Cells[2, colIndex++].Value = "冗余资源数";
ws.Cells[2, colIndex++].Value = AssetFileInfoType.mesh;
ws.Cells[2, colIndex++].Value = AssetFileInfoType.material;
ws.Cells[2, colIndex++].Value = AssetFileInfoType.texture2D;
ws.Cells[2, colIndex++].Value = AssetFileInfoType.sprite;
ws.Cells[2, colIndex++].Value = AssetFileInfoType.shader;
ws.Cells[2, colIndex++].Value = AssetFileInfoType.animationClip;
ws.Cells[2, colIndex].Value = AssetFileInfoType.audioClip;
using (var range = ws.Cells[2, 1, 2, colIndex])
{
// 字体样式
range.Style.Font.Bold = true;
// 背景颜色
range.Style.Fill.PatternType = ExcelFillStyle.Solid;
range.Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml("#DDEBF7"));
// 开启自动筛选
range.AutoFilter = true;
}
// 列宽
ws.Column(1).Width = 100;
for (int i = 2; i <= colIndex; i++)
{
ws.Column(i).Width = 15;
ws.Column(i).Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
}
ws.Column(10).Width = 16;
ws.Column(2).Style.Numberformat.Format = "#,##0";
// 冻结前两行
ws.View.FreezePanes(3, 1);
}
public static void CreateWorksheet(ExcelWorksheets wss)
{
ExcelWorksheet ws = wss.Add("资源列表");
// 标签颜色
ws.TabColor = ColorTranslator.FromHtml("#70ad47");
AssetBundleReporter.CreateWorksheetBase(ws, "全部资源列表", 4);
// 列头
ws.Cells[2, 1].Value = "资源名称";
ws.Cells[2, 2].Value = "资源类型";
ws.Cells[2, 3].Value = "AB文件数量";
ws.Cells[2, 4].Value = "相应的AB文件";
using (var range = ws.Cells[2, 1, 2, 4])
{
// 字体样式
range.Style.Font.Bold = true;
// 背景颜色
range.Style.Fill.PatternType = ExcelFillStyle.Solid;
range.Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml("#DDEBF7"));
// 开启自动筛选
range.AutoFilter = true;
}
// 列宽
ws.Column(1).Width = 50;
ws.Column(2).Width = 30;
ws.Column(3).Width = 15;
ws.Column(3).Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
// 冻结前两行
ws.View.FreezePanes(3, 1);
}
public static void CreateAndFillWorksheet(ExcelWorksheets wss, string typeName)
{
var dicts = AssetBundleFilesAnalyze.GetAllAssetFileInfo();
if (dicts == null)
{
return;
}
List <string> columnNames = new List <string>();
foreach (var info in dicts.Values)
{
if (info.type != typeName)
{
continue;
}
foreach (var pair in info.propertys)
{
columnNames.Add(pair.Key);
}
break;
}
if (columnNames.Count == 0)
{
return;
}
string titleName = typeName + " 列表";
ExcelWorksheet ws = wss.Add(titleName);
int abCountCol = columnNames.Count + 2;
int abDetailCol = columnNames.Count + 3;
// 标签颜色
ws.TabColor = ColorTranslator.FromHtml("#b490f5");
AssetBundleReporter.CreateWorksheetBase(ws, titleName, abDetailCol);
// 列头
ws.Cells[2, 1].Value = "资源名称";
for (int i = 0; i < columnNames.Count; i++)
{
ws.Cells[2, i + 2].Value = columnNames[i];
}
ws.Cells[2, abCountCol].Value = "AB文件数量";
ws.Cells[2, abDetailCol].Value = "相应的AB文件";
using (var range = ws.Cells[2, 1, 2, abDetailCol])
{
// 字体样式
range.Style.Font.Bold = true;
// 背景颜色
range.Style.Fill.PatternType = ExcelFillStyle.Solid;
range.Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml("#DDEBF7"));
// 开启自动筛选
range.AutoFilter = true;
}
// 列宽
ws.Column(1).Width = 50;
for (int i = 0; i < columnNames.Count; i++)
{
ws.Column(2 + i).Width = 15;
ws.Column(2 + i).Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
ws.Column(2 + i).Style.VerticalAlignment = ExcelVerticalAlignment.Top;
}
ws.Column(abCountCol).Width = 15;
ws.Column(abCountCol).Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
ws.Column(abCountCol).Style.VerticalAlignment = ExcelVerticalAlignment.Top;
// 冻结前两行
ws.View.FreezePanes(3, 1);
int startRow = 3;
int maxCol = abDetailCol;
foreach (var info in dicts.Values)
{
if (info.type != typeName)
{
continue;
}
ws.Cells[startRow, 1].Value = info.name;
info.detailHyperLink.ReferenceAddress = ws.Cells[startRow, 1].FullAddress;
int startCol = 2;
foreach (var property in info.propertys)
{
ws.Cells[startRow, startCol++].Value = property.Value;
}
ws.Cells[startRow, startCol++].Value = info.includedBundles.Count;
foreach (var bundleFileInfo in info.includedBundles)
{
ws.Cells[startRow, startCol].Value = bundleFileInfo.name;
ws.Cells[startRow, startCol++].Hyperlink = bundleFileInfo.detailHyperLink;
}
maxCol = System.Math.Max(--startCol, maxCol);
startRow++;
}
ws.Cells[1, 1].Value = ws.Cells[1, 1].Value + " (" + (startRow - 3) + ")";
// 具体所需要的列
using (var range = ws.Cells[2, abDetailCol, 2, maxCol])
{
range.Merge = true;
}
for (int i = abDetailCol; i <= maxCol; i++)
{
ws.Column(i).Width = 100;
}
// 不同类型不同处理
switch (typeName)
{
case "Texture2D":
ws.Column(7).Style.Numberformat.Format = "#,##0";
break;
case "Material":
ws.Column(2).Width = 40;
ws.Column(3).Width = 50;
break;
case "AnimationClip":
ws.Column(7).Style.Numberformat.Format = "#,##0";
break;
case "AudioClip":
ws.Column(2).Width = 23;
break;
}
}