使用excel创建XML文件 [英] Creating an XML file using excel

问题描述

大家好，我希望有人可以帮助我。首先，我根本不是编码器，只能阅读HTML& XML文件。



我希望通过单击Excel中的按钮创建XML文件，使我的团队在工作中更轻松。



XML代码需要如下所示，带有两个页眉和一个页脚。对我来说，关键是在DivisionTasks标记内可以有许多TaskCode及其下面的相关标签。



我尝试过创建一个架构，但Excel并不喜欢它，也不会让我保存它。

< 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：已删除> 0< / tsk：已删除> 
< / tsk：任务> 
< / tsk：DivisionTasks> 

有人可以协助吗？



我尝试了什么：



创建架构但Excel不会保存它

解决方案

引用：

我希望有人可以帮助我。

没有人可以帮助你解决这个问题，因为无法回答这个问题并从声明中提出代码。

原因：你忘了告诉excel工作表中的数据是怎么回事。



很难找到你问题的助手。

原因1：这个论坛是为了帮助程序员解决问题。你的问题不在话题。

原因2：你想要的就是我作为工作解决的问题，这就是我赚钱的方式。你会明白我不想免费这样做，即使这是可能的。



我的建议：聘请程序员，所描述的任务是关于几个小时，半天最多。喜欢本地程序员。

聘请自由职业者&在线查找自由职业者 - 自由职业者 [ ^ ]

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

解决方案

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

这篇关于使用excel创建XML文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！