public void Test2()
{
var model = new ListValidationCase();
ExcelPackageSaveAndLoad.WorkbookTest(wb => { XlsWorkbookSerializerCore.SerializeWorkbook(model, wb, new XlsxSerializerSettings()); },
wb =>
{
},
"validation1.xlsx");
}
public void Test()
{
var wbModel = TwoSheetsWorkbook.Setup();
var deserialized = new TwoSheetsWorkbook();
ExcelPackageSaveAndLoad.WorkbookTest(wb => { XlsWorkbookSerializerCore.SerializeWorkbook(wbModel, wb, new XlsxSerializerSettings()); },
wb =>
{
XlsWorkbookDeserializerCore.DeserializeWorkbook(deserialized, wb, new XlsxSerializerSettings());
},
"workbook1.xlsx");
Assert.Equal(JsonConvert.SerializeObject(wbModel), JsonConvert.SerializeObject(deserialized));
}
public void Serialize(object model, ExcelPackage package)
{
if (model == null)
{
return;
}
if (ReflectionHelper.GetIsCollection(model.GetType(), out var itemType, true))
{
XlsCollectionSerializerCore.SerializeCollection(itemType, (IEnumerable)model, XlsSheetSerializerCore.GetDefaultWorksheet(package), 0, 0, m_settings);
return;
}
XlsWorkbookSerializerCore.SerializeWorkbook(model, package.Workbook, m_settings);
}
