98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
Understanding XML Within Excel
Mon 22nd March 2010
If you already have a basic understanding of html, the way XML is written will be familiar to you. It uses 'tags' - pieces of information within angle parentheses. Within these parentheses, XML code gives a descriptive name to the data. In the above example, your data for each customer might start with Steven Jones inside the XML Name tags, followed by a new description for address, postcode, and any other information. This gives a whole new portability to your data. You could use the NAME XML data and import it into Word along with the address data, to create a mail merge advert to be sent to all existing customers.
The accountant and his or her own software is also likely to be able to import other XML data such as outstanding invoices or debts, so they can easily get a picture of how the books are looking. These are very simple examples of how XML data can be marked up and then moved, but its uses are far more varied. A caveat, though, the data must be well written - that is, if you omit something like a closing parenthesis or closing tag, the data within it won't work. Human error is responsible for most XML data not "working" in other programs, so check yours carefully for any glitches, typos or mistakes.
Schemas are a more complex way of validating your data. It has a set of inbuilt rules that 'know' how the XML data is supposed to look and will reject any incorrect entries. For example, you could write a schema that knows that a name field will usually be no more than three words (someone's first, middle and surnames). If a hasty secretary starts typing in the address instead, it will flag it up. Another example is that only numbers, and not words, should be entered in any monetary data such as the outstanding balance. If the schema keeps this rule, then your accountant will only receive correct numerical data and not a mixture of words and numbers, depending on who input it.
This is just a basic introduction to how XML can be used with your Excel data, and more training will be needed in order to learn the language fully and start integrating it into your everyday use of data. To get started, though - you need to activate it in Excel 2007 by clicking the Office button, then Excel options, then personalise. Then under 'developer', you'll see the tools for using XML. Why not have a play around, and see how far and flexible your data can go?
Author is a freelance copywriter. For more information on microsoft excel 2003 vba courses, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-793-understanding-xml-within-excel.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsRich's Products
David Hawkins Excel Introduction Very good training, thank you. I feel that I would do better with more training as I had no idea before today. I have a lot more knowledge than before I started a very good course. Real Estate Management (UK) Limited
Health, Safety And Quality Manager Samantha Conaghan Personal Effectiveness for Managers I found the course very interesting, covered lots of areas I hadn't before on similar courses and was delivered well allowing personal experience to be discussed. Hobbs Ltd
Senior HR Advisor Emily Fowler Introduction to Management Really enjoyed the course, content was great, level of interaction was perfect and Karen had really good energy. Felt pacing was just right and felt relaxed and at ease throughout. |
PUBLICATION GUIDELINES