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); }