An Example of Exporting to Excel 2013

< Previous section  |  Table of Contents  |  Index  |  Next section >

The previous section showed how to export to Microsoft Excel 2010. This section does the same with 2013 (and repeats some of the information so that it's all in one section).

The first step is to export the data:

mbutility ex /si:unit /out:mydata /on:mymb +excel

This exports data from a database with the organization name mymb. It creates two output files: the schema is saved in mydata.xsd and the data itself is saved in mydata.xml. Both files are written to the same directory.

Now you're ready to import the data into Excel. If you have Microsoft Office 2013, here's what you do:

1. Start Excel.
2. Click "File" in the upper left hand corner of the Excel window.
3. In the resulting window, click "Options" (at the bottom of the window).
4. In the resulting window, click "Customize Ribbon".
5. Under "Main Tabs", checkmark "Developer" if it isn't already checkmarked.
6. Click OK to close the options window.
7. In the main Excel window, click "Developer" in the ribbon.
8. In the XML section of the ribbon, click "Import".
9. In the resulting window, specify the name of the data file (in our example mydata.xml).

Excel gives you the option of reading the data file into the current spreadsheet or into a new one.

< Previous section  |  Table of Contents  |  Index  |  Next section >