When you do, you’ll be able to peruse the XML code that Excel 2002 generated. Then go to Insert | File and navigate to the. If you’re curious about what’s going on behind the scenes in that XML file, however, launch Microsoft Word. xml file, you’ll see pretty much the same thing as you see when you open the. So what’s in that XML file that Excel 2002 generates? In Excel 2002, if you go to File | Open, the XML file you created will show up because XML is listed under the default list of file types. You can go to File | Close to close that XML version of your spreadsheet. Onscreen, nothing much will probably change. When you select XML Spreadsheet (*.xml) and click OK, Excel 2002 saves the current records in XML format. The first row of text is a list of four field or column names, and the second row contains data.Įxcel 2002 gives you the option of saving your worksheet in XML format. This data format is called comma-delimited text. To contrast XML with traditional data formats, consider the two lines of text shown in Figure A. If you have a ton of data in Excel spreadsheets, but your customer or business partner requests that data in XML format, it’s easy to convert that data. So what is XML and why should Excel 2002 users care? At its core, an XML file is a text file that stores data, so XML provides a format for sharing data. To help you take advantage of XML, Microsoft has added new features in Excel 2002 that can save you time by allowing you to create and query XML data with just a few mouse clicks.
Why? It’s human-friendly onscreen, and it’s database-friendly when it comes to spreadsheet, database, and Web applications. In fact, it’s possible XML will replace fixed-length and delimited text as the “vanilla” data format of choice. XML is among the most popular standards for displaying data on the Web and sharing data between applications.
0 kommentar(er)
