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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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[^]