Microsoft's Office2003 has been released for a long time. This version is most convenient for XML better support. This is very convenient for office users. Especially in the Excel's support of XML is more Like it. As a programmer, I want to talk about what it brings to us.
Simply talk about using an XML file in Excel as a data source. The operation is very simple, press the steps below in Excel: Add an XML mapping, data-> xml-> XML source, click the "XML Mapping" button in the open dialog box, select an XSD file (that is, XML Architecture file); then drag the fields displayed in the XML Source dialog to the worksheet; then, data -> XML-> import, add a data file that meets the loaded XML schema, you can see the data.
Through the above description, what we thought. Yes, we can apply this process to our program. So, what is the benefit of doing this?
In the development process, we may have encountered such problems: During the project development process, customers involve a lot of reports, and some of them may change in the future, what should I do? Especially those that require very strict formats. Under normal circumstances, we will first complete the current, and then change again. However, now we can solve this problem through Excel2003.
The above mentioned in Excel2003 is very simple as the operation of the data source, so we can handle it to our customers. Let customers make the Excel template for the report, and then we can provide data in the program.
Specific procedure can be referenced
http://www.microsoft.com/chna/msdn/library/office/office/odcxlexcel2003xmlintro.mspx.
