Build application for transferring xml values to corresponding Excel cells based on unique ID
Budget: €36 – €0 EUR
We need a simple stand alone windows application that does the following:
Populate column A+B in a new Excel doc with values from 1-Swedish.xml:
1. Place ID value in column A and text value in column B.
Populate column C in the Excel document above with corresponding values from 2-English.xml:
2. Place the corresponding (= they have the same id number as in Swedish but different order) text value in column C
3. Save Excel doc as Results.xls
Done!
Note: The program must be able to run xml files containing many lines, maybe over 100 K rows.
Note 2: It must be UTF-8 and special characters must be preserved.
Attached:
1-Swedish.xml: this example file contains unique ID values and Swedish text values. The should be placed in col A and B in the Excel doc.
2-English.xml: this file contains unique IDs and English text values and should be placed in column C by the corresponding ID.
Program-function-overview.jpg: Visual overview showing how to transfer the values to Excel.
We need this simple program very soon. Please let us know if you have the programming skills needed, if you can start right away and when you expect to be able to Finish.
Many thanks!
Populate column A+B in a new Excel doc with values from 1-Swedish.xml:
1. Place ID value in column A and text value in column B.
Populate column C in the Excel document above with corresponding values from 2-English.xml:
2. Place the corresponding (= they have the same id number as in Swedish but different order) text value in column C
3. Save Excel doc as Results.xls
Done!
Note: The program must be able to run xml files containing many lines, maybe over 100 K rows.
Note 2: It must be UTF-8 and special characters must be preserved.
Attached:
1-Swedish.xml: this example file contains unique ID values and Swedish text values. The should be placed in col A and B in the Excel doc.
2-English.xml: this file contains unique IDs and English text values and should be placed in column C by the corresponding ID.
Program-function-overview.jpg: Visual overview showing how to transfer the values to Excel.
We need this simple program very soon. Please let us know if you have the programming skills needed, if you can start right away and when you expect to be able to Finish.
Many thanks!