An Example of Exporting to Excel 2010

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.2.
For the latest version of this help file can be found here.

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

The previous section showed how to export to Microsoft Excel 2007. This section does the same with Excel 2010 (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 2010, 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 >