Excel sheet contains Named Ranges, Each named ranges contains different number cols and rows.
Generate XML Data file based on the data from Excel and validate against XML Schema file.
References and constraints: .NET, C#, .NET Design Patterns, Open XML SDK 2.5 for Office, Excel 2010+
Additional files can be provided once dialog starts.
Final Outcome: c# source files with relevant comments and associated Tests. Source needs to be compiled into a .NET class library which will be further plugged into Thick or thin clients or even SharePoint.
Code need to be using the references and complied as mentioned in the original description and also should be reusable and testable.
The XSD schema should reasonably match all the records in the 'data' sheet. also attached is the sample data file
- Input Excel File -> UI <- developed code to parse Named Ranges and generate XML based on the XSD -> XML file
- XML file + XSD file => validation
34 freelancer đang chào giá trung bình $169 cho công việc này
Understood the requirements. Can deliver with perfect quality. Please check PM for my work samples (web application) to have an idea about my quality.
Dear sir, I was work some task like what you required, So I think i can solve your problem in 3 [url removed, login to view] me do it for you. regards!