This web site needs Java Script to operate correctly
 

I exported report data to Microsoft Excel, but I can't do anything with it. What's wrong?

MainBoss has two ways to export data to Excel:

To import data into Excel 2007, you must have the Developer tab shown in Excel's ribbon. If it isn't already there, follow these steps:

  1. Start Excel.
  2. Click the "Office" button (in the upper left hand corner of the Excel window).
  3. In the resulting window, click "Excel Options" (at the bottom of the window).
  4. In the resulting window, click "Popular" in the left part of the window, then checkmark "Show Developer Tab in the Ribbon" (if it isn't already checkmarked).
  5. Click OK to close the options window.

Once you have the Developer tab shown in the ribbon, you can import XML data into Excel as follows:

  1. In the main Excel window, click "Developer" in the ribbon.
  2. In the XML section of the ribbon, click "Import".
  3. In the resulting window, specify the name of the XML data file.
    • Excel may give you a message saying that it can't find a schema and therefore is creating its own schema. Just click OK.
    • Excel gives you the option of reading the data file into the current spreadsheet or into a new one. Choose one and click OK.

Row Height Too Small

With some reports (e.g. Unit Maintenance Plans), data exported to an Excel spreadsheet may have the Row Height set too small for some data fields. To solve the problem, select the entire spreadsheet then use Excel's AutoFit Row Height operation. This is typically found on the Home ribbon; use the drop-down arrow associated with the Format button in the Cells section, then select AutoFit Row Height from the menu.

Back to FAQ index

Copyright © 2018 Thinkage Ltd. All rights reserved
Maintenance Worker Maintenance Worker Maintenance Worker