<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<!--
Copyright (c) 2006 UGS Corp.

All Rights Reserved.

This software and related documentation are proprietary to UGS Corp.
-->
<html>
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <title>Import requirements from a spreadsheet in a native file system</title>
      <script language="javaScript">
        abridged="false";
        displayConditions=new Array();
      </script>
      <link type="text/css" href="../css/main_styles.css" rel="stylesheet">
   </head>
   <body class="bodydocs" onload="top.pageLoader()" bgcolor="#FFFFFF">
      <div class="title_topic3" id="xps10_pagetitle">Import requirements from a spreadsheet in a native file system</div>
      <hr noshade="true">
      <table cellspacing="4" align="center">
         <tr valign="top">
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1">
               <p class="para_td"> <a class="links" href="javascript:void(0)" onclick="top.openFile('check_req/user_req_ov.html');return(false);">Overview</a></p>
            </td>
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1">
               <p class="para_td"> <a class="links" href="javascript:void(0)" onclick="top.openFile('check_req/reqts_list_ht.html');return(false);">How To</a></p>
            </td>
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1">
               <p class="para_td"> <a class="links" href="javascript:void(0)" onclick="top.openFile('check_req/validation_op.html');return(false);">Options</a></p>
            </td>
         </tr>
      </table><br><p class="para_topic">You can also import requirements into NX from a Microsoft Excel spreadsheet. The spreadsheet must contain at least 6 columns: <b class="uiTerm">Name</b>, <b class="uiTerm">Type Name</b>, <b class="uiTerm">Subtype</b>, <b class="uiTerm">Compare</b>, <b class="uiTerm">Max</b> and <b class="uiTerm">Min</b>. Each row of the spreadsheet represents one requirement. You can refer to the requirement_spreadsheet_example.xls file located in the examples subfolder under the UGCHECKMATE_DIR directory (UGII_BASE_DIR\ugcheckmate) as an example.
      </p>
      <p class="para_topic">To import requirements from a spreadsheet: </p>
      <ol type="1" start="1">
         <li>
            <p class="para_item">Choose <b class="uiTerm">Analysis</b>&rarr; <b class="uiTerm">Check Requirements</b>. 
            </p>
         </li>
         <li>
            <p class="para_item">Next to the the <b class="uiTerm">Project</b> menu, click the <b class="uiTerm">Browse for XML or Excel files</b> button. 
            </p>
         </li>
         <li>
            <p class="para_item">Locate and select the spreadsheet file and click <b class="uiTerm">Open</b>. The <b class="uiTerm">Project</b> menu becomes populated with spreadsheet tabs containing the requirements.
            </p>
         </li>
         <li>
            <p class="para_item"> If necessary, from the <b class="uiTerm">Project</b> menu, select the spreadsheet tab containing the requirements you want and click <b class="uiTerm">OK</b>.
            </p>
         </li>
      </ol>
   </body>
</html>