Excel sheet contains Named Ranges, Each named ranges contains different number of rows and column.
Generate XML Data file based on the data from Excel and validate against XML Schema file.
Code needs to be reusable and testable.
References and constraints: .NET, C#, .NET Design Patterns, Open XML SDK 2.5 for Office, Excel 2010+
Additional sample files can be provided once dialog starts.