Em Andamento

Create tool to populate excel spreadsheet with data from XML files

I have >100 xml files with the following tags: <id>, <title>, <questionType>, <questionContents>, <answers>, <answerA>, <answerB>, <answerC>, <answerD>, <answerE>, <hint>, and <explanation>.

I want these to be parsed and populated into an excel spreadsheet with each column corresponding to a tag and each row corresponding to a unique file.

One of the tags answerA-E has a property 'correct="correct" ' which I want put in an additional column "correctAnswer" populated with the tag name.

I'm asking for someone to write a script to parse these files and populate the spreadsheet. I've attached a sample file.

Habilidades: Processamento de Dados, Excel

Ver mais: spreadsheet script, xml data entry, row spreadsheet, populate, populate excel spreadsheet spreadsheet, excel create xml, excel unique, answers explanation, excel property, write data excel spreadsheet, xml file excel, answers excel, parse data file, populate excel spreadsheet, excel sample file, excel create xml file, populate spreadsheet data, populate entry, xml parse excel, write script data entry, populate xml, populate excel excel file, property excel, xml files, xml excel script

Acerca do Empregador:
( 10 comentários ) Murphy, United States

ID do Projeto: #6793647

Premiar a:

Attractionnet

Hello. I have created various kinds of scripts for all kinds of files, including xml handling. I will create a small vb.net application which will open the files and assign tags to correct columns in a excel. Few lines Mais

$25 USD em 0 dias
(17 Avaliações)
3.9

13 freelancers are bidding on average $25 for this job

pandey2008

Hello sir,I have 8 member team and good experience and we can start the work right now and also all communication and work will be high quality. all work will be on my office without any [url removed, login to view]

$28 USD em 1 dia
(224 Comentários)
6.5
thanhhungqb

Dear sir, Please have a look a demo about XML parse: [url removed, login to view] You only need spreadsheet file? Then I can use any script language? I can finish your pro Mais

$23 USD em 1 dia
(15 Comentários)
3.6
MKL7

Dear, I am an expert in Excel / VBA and I have completed already several similar projects through [url removed, login to view], i.e. importing data to Excel (and the other way around). Contact me now and let's start immediatel Mais

$18 USD em 1 dia
(17 Comentários)
3.2
pankajpandey575

A proposal has not yet been provided

$18 USD em 1 dia
(1 Comentário)
2.5
Samiulalimlesam

Firstly,please don't ignore my proposal because of my low completion rate which was not my fault at [url removed, login to view] a new freelancer,i have much to achieve here . Currently,i am a student of Computer Science at undergraduate le Mais

$20 USD em 1 dia
(4 Comentários)
2.0
milroy17

A proposal has not yet been provided

$35 USD em 1 dia
(0 Comentários)
0.0
faizasiddiqui790

A proposal has not yet been provided

$25 USD em 1 dia
(0 Comentários)
0.0
mr58785

Your task is easy and will be done efficiently. my name is muneeb and i have 3 year experience in this field

$25 USD em 1 dia
(0 Comentários)
0.0
Egladys1

You should hire me, because am very good and fast in typing, copy and paste, excel and Ms word processing, PowerPoint presentation, publisher and handling emails every day and also these are my duties at work everyday Mais

$25 USD em 1 dia
(0 Comentários)
0.0
parunpandi

A proposal has not yet been provided

$30 USD in 3 dias
(0 Comentários)
0.0
juwel100

well, this is very much simple easy task. i think i can do the work clearly and i can submit a fair excel sheet.

$25 USD em 1 dia
(0 Comentários)
0.0
prisminfosys

A proposal has not yet been provided

$25 USD em 1 dia
(0 Comentários)
0.0