public void Import_ImportsAFullComplexObjectUsingBothImporters() { #region Arrange _workbook = new Workbook("Order.xlsx"); var listImporter = new WorksheetListImporter(); var worksheet = _workbook.Worksheets[0]; #endregion #region Act // get the order part var result = _worksheetImporter.Import <Order>(worksheet); var order = result.Result; // now get the line items var listResult = listImporter.Import <OrderItem>(worksheet); order.OrderItems = listResult.Results; #endregion #region Assert Assert.IsNotNull(order); Assert.AreEqual(2, order.OrderItems.Count); // check some values of the line items Assert.AreEqual(ItemNo, order.OrderItems[0].ItemNo); Assert.AreEqual(LineTotal, order.OrderItems[0].LineTotal); #endregion }
public ImportListResult <ServiceDecomposition> ImportSpreadsheet(string filename) { if (filename == null) { throw new ArgumentNullException(nameof(filename)); } if (!File.Exists(filename)) { throw new FileNotFoundException(filename); } // Set the license for Aspose var license = new License(); license.SetLicense("Aspose.Total.lic"); var workbook = new Workbook(filename); var worksheet = workbook.Worksheets.GetSheetByCodeName("Decomposition"); if (worksheet == null) { throw new ArgumentNullException(nameof(worksheet)); } var importer = new WorksheetListImporter(); var sheet = importer.Import <ServiceDecomposition>(worksheet); var result = new ImportListResult <ServiceDecomposition> { ValidationResults = sheet.ValidationResults }; var lineNumber = 2; foreach (var line in sheet.Results) { if (!string.IsNullOrWhiteSpace(line.ServiceDomain)) { line.WorksheetName = worksheet.Name; line.LineNumber = lineNumber; result.Results.Add(line); } lineNumber++; } return(result); }
public void Initialize() { _worksheetListImporter = new WorksheetListImporter(); }