With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
The project is to use Excel VBA to convert an XML file (browse to find it) into an Excel sheet, and to do the reverse, i.e. convert the Excel sheet back into a corresponding XML file (prompt for network path/filename). Essentially, the Excel file is a ‘flattened-out’ version of the XML. The XML is used to load data into another application and this utility will allow me to unload the application data, manipulate it in Excel, and load it back into the application.
Both the XML and the Excel files are of a standard format. There are only about 12 tag types in the XML, with some repeating groups and some single items. This is quite a simple structure. The corresponding Excel file will have up to 100 or so columns to accommodate the term attributes and repeating groups.
I would like the utility to be configurable, with the XML tags/attributes and the column structures, and how they map together, defined in a configuration sheet. I will provide the initial configuratio...
Sign in or Register to see more