public static void FillWorksheet(ExcelWorksheet ws)
{
int startRow = 3;
int maxCol = 4;
var dicts = AssetBundleFilesAnalyze.GetAllAssetFileInfo();
if (dicts == null)
{
ws.Cells[1, 1].Value = ws.Cells[1, 1].Value + " (0)";
}
else
{
foreach (var info in dicts.Values)
{
ws.Cells[startRow, 1].Value = info.name;
ws.Cells[startRow, 2].Value = info.type;
ws.Cells[startRow, 3].Value = info.includedBundles.Count;
info.detailHyperLink.ReferenceAddress = ws.Cells[startRow, 1].FullAddress;
int startCol = 4;
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 + " (" + dicts.Values.Count + ")";
}
// 具体所需要的列
using (var range = ws.Cells[2, 4, 2, maxCol])
{
range.Merge = true;
}
for (int i = 4; i <= maxCol; i++)
{
ws.Column(i).Width = 100;
}
}
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;
}
}
