Creating an XML file using excel

Question

3.00/5 (2 votes)

See more:

Hi all, i am hoping someone can help me out here. First of all, i am not a coder at all and can just about read HTML & XML files.

I would like to make mines and my teams life easier at work by being able to create an XML file from the click of a button in Excel.

The XML code would need to look like below with two headers and one footer. The sticking point for me is that there can be many TaskCode and the associated tags below it within the DivisionTasks tag.

I've had a try at creating a schema but Excel doesnt like it and will not let me save it.

<tsk:DivisionTasks code="AA123A01">
    <tsk:Task TaskCode="CUSTOMER SERVICE">
      <tsk:TaskName>CUSTOMER SERVICE</tsk:TaskName>
      <tsk:TaskType>CUSTOMER SERVICE</tsk:TaskType>
      <tsk:MinCover>0</tsk:MinCover>
      <tsk:MaxCover>0</tsk:MaxCover>
      <tsk:PayGroupCode/>
      <tsk:Deleted>0</tsk:Deleted>
    </tsk:Task>
  </tsk:DivisionTasks>

Can anyone assist?

What I have tried:

Creating a schema but Excel will not save it

Posted 14-Apr-17 10:33am

Member 13127594

Updated 14-Apr-17 11:58am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Answer 1 · 2017-04-14T11:58:00

Quote:
i am hoping someone can help me out here.

Nobody can help you with this question, because it is impossible to answer the question and to make code from the statement.
Reason : You forgot to tell how is the data in the excel worksheet.

It will be difficult to find a helper for your question.
Reason 1 : This forum is to help programmer when they are stuck on a problem. Your question is off topic.
Reason 2 : What you want is exactly the kind of problem I solve as my job, this is how I make money. You will understand that I don't want to do it for free, even id it was possible.

My advice: Hire a programmer, the task as described is about a couple of hours, half a day would be maximum. Prefer local programmer.
Hire Freelancers & Find Freelance Jobs Online - Freelancer[^]

Creating an XML file using excel

1 solution

Solution 1

Add your solution here

Preview 0

Creating an XML file using excel

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us