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