![]() ![]() ![]() With the List feature turned on, we have autofilters on every column and an Access-like asterisk row for adding new data. They turn on the awesome new Excel 2003 List feature (usual shortcut: Ctrl+L). This is a fantastic message - because Microsoft is now going to create a schema for you on the fly. Next - we get the information box that the XML does not have a schema. For right now, choose to open as an XML list. Later, we will want to use the powerful XML Source task pane, but we can not do that until we have a valid schema. You are first presented with the Open XML dialog box. If the "Files of type:" box is set to All Microsoft Excel files, you will see test.xml. Copy this data from below and paste it into Notepad. Luckily, Excel will create a default schema for you, but it is NOT obvious how to use the schema. You can open an XML file in Excel but you can not do any transforms without a schema. XSL is an XML StyleSheet Language file - these allow you to repurpose the data from one format to another.īy far, the biggest hurdle is how to create the Schema file. While anyone can type XML into notepad, we need a schema in order to do anything cool. In order to actually do the Microsoft demo, you need an XML Schema file. Here are the three files we will encounter when working with XML. While HTML will allow this structure, click Cancel this is not valid in XML. If you nest tags, you must close the inner tag before closing the outer tag.You can have an empty tag - put the slash at the end of the tag instead of the beginning:.There can only be one root tag in a file. The XML file must begin and end with a root tag.and are NOT valid tags because the capitalization in the end tag is not the same as the capitalization in the begin tag. Every bit of data has to start and end with an identical tag: Data.Here is a screenshot of some XML data that I typed into notepad: You can make up any sort of a tag to describe your data. While HTML allows for certain tags, like TABLE, BODY, TR, TD, XML allows for any tags. If you've ever looked at the "View Source" view of a webpage in Notepad, you are familiar with the structure of XML. XML stands for Extensible markup language. What is XML? Is it like HTML? Sample XML Data Unless you work in a corporate environment, The only way to get InfoPath (the new tool that lets you create forms and XML Schemas) is to buy the retail box version. If you are unlucky enough to have one of the "lesser" versions of Office 2003, your cheapest upgrade path might be to buy the retail box version of Excel. ![]() Microsoft Excel 2003 (R)(The stand-alone Excel box is considered to be professional).Microsoft Office Professional Enterprise Edition 2003 (includes InfoPath)(V).Microsoft Office Professional Edition 2003 (R, P, V, A, S).Microsoft Office Student and Teacher Edition 2003 (R, S)įull XML support is available in these editions:.Microsoft Office Basic Edition 2003 (P).Microsoft Office Standard Edition 2003 (R, V, A, S).Microsoft Office Small Business Edition 2003 (R, P, V, A).Full XML support is not available in these editions: (Codes in italics stand for where you can buy each: R=Retail, P=Preinstalled with new Computer, V=Volume-Licensing, A=Academic Licensing, S=School Resellers). We are now faced with a class system in Office 2003. If you have QBasic or Rexx or anything, you can now create XML Excel (ExcelML?) files on the fly. We also have the fact that since Office 2003 considers XML to be a native file format, anyone with any programming language can write native XML files. Open the same data file and it looks one way in Excel, open the data file and it looks another way in Word. Microsoft says that you can now store data as XML and easily re-purpose the data. So, before Woody can ever get to the point, I am going to walk through a long tip explaining how to make full use of XML in Office 2003. For those of you who subscribe to Woody's newsletter, you now realize that Woody is going to serialize the explanation of XML, making us wait 4 weeks (or more) to get the whole story. But, unless you happen to be in a company with tons of XML schemas floating around, you probably haven't been able to figure out how to duplicate that cool demo you saw Microsoft do during the Office 2003 launch. Everyone is saying that XML is the most important new feature in Office 2003. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |