41 lines
769 B
Plaintext
41 lines
769 B
Plaintext
using OfficeOpenXml;
|
|
using MemoryPack;
|
|
|
|
|
|
namespace ExcelConfig
|
|
{
|
|
public partial class (ConfigName)Category
|
|
{
|
|
public override void Serialization(ExcelPackage p)
|
|
{
|
|
ExcelWorksheet worksheet = p.Workbook.Worksheets.First();
|
|
|
|
// 获取最大行数
|
|
int maxRow = worksheet.Dimension.End.Row;
|
|
|
|
// 从第6行开始遍历
|
|
for (int row = 6; row <= maxRow; row++)
|
|
{
|
|
var data = new (ConfigName)(worksheet.Cells, row);
|
|
Dict[data.Id] = data;
|
|
}
|
|
}
|
|
|
|
public override byte[] GetData()
|
|
{
|
|
return MemoryPackSerializer.Serialize(typeof(Dictionary<int, (ConfigName)>), Dict);
|
|
}
|
|
}
|
|
|
|
|
|
public partial class (ConfigName)
|
|
{
|
|
public (ConfigName)(ExcelRange cells, int row)
|
|
{
|
|
(ConstructorBody)
|
|
}
|
|
}
|
|
}
|
|
|
|
|