I need to take the contents of an excel spreadsheet and populate and XML file. The program will need to support up to five columns of data and up to 5000 rows within excel. I have both the .dtd and .xsd files that specify the fields to be populated from the excel spreadsheet. There may be additional fields that are required by the XML file that are not contained in the excel file. If this is the case, it will be necessary to set default values in the code to populate these fields for each record. I also want this coded in VB so that I can maintain the code should some values need to be changed in the future.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).