<!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>&lt;@UGSPREADSHEET ... &gt;</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_topic5" id="xps10_pagetitle">&lt;@UGSPREADSHEET ... &gt;</div>
      <hr noshade="true">
      <div class="title_division">Description</div>
      <p class="para_division"> Fetch cells from the spreadsheet</p>
      <div class="title_division">Keywords</div>
      <p class="para_division"> NAME=&quot;MODELING_SHEET&quot; PART=&quot;WORK&quot; FORMAT=&quot;AUTO&quot; HEADER=&quot;&lt;table&gt;&quot; FOOTER=&quot;&lt;/table&gt;&quot; EMPTY=&quot; &quot; LABELS=&quot;YES</p>
      <div class="title_division">Parameters</div>
      <table border="0" cellpadding="2" cellspacing="3" width="100%" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> Parameter</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> Description</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> $NAME</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> SPREADSHEET NAME</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> $PART</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> PART</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> $ROW</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> Current row</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> $MAXCOLUMN</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> Maximum number of columns with non-empty cells</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> $A</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> Cell in column A ( or 1 )</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> ...</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top"></td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> $CR</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> Cell in column CR ( or 95 )</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top"></td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top"></td>
         </tr>
      </table><br><p class="para_division"></p>
      <div class="title_division">Notes</div>
      <ul>
         <li>
            <p class="para_item"> The command determines the active range of rows in the spreadsheet and traverses those rows. If the spreadsheet contains information beyond column 95, it cannot be retrieved.</p>
         </li>
         <li>
            <p class="para_item"> The formatted value of spreadsheet cell contents are returned as strings.</p>
         </li>
         <li>
            <p class="para_item"> There are some generic spreadsheet names that may appear in a part.</p>
            <p class="para_item"> - MODELING_SHEET = the spreadsheet for Modeling</p>
            <p class="para_item"> - DEFAULT_SHEET = the spreadsheet for Gateway</p>
         </li>
         <li>
            <p class="para_item"> The EMPTY keyword is used to specify a string that is used for those cells that are empty in the spreadsheet. If an HTML table item is empty then the &quot;cell&quot; will not display with any background colors. By using &quot; &quot; (a non break space), as the contents of an empty cell, the output HTML table will have the correct appearance. If you are formatting for a different appearance, you may want to change the EMPTY string. For example, to return the first 3 columns of the Gateway spreadsheet in a table, you could use the following embedded command:</p>
            <p class="para_item">   &lt;@UGSPREADSHEET NAME=&quot;DEFAULT_SHEET&quot; PART=&quot;WORK&quot;   HEADER=&quot;&lt;table BORDER=1&gt;   &lt;tr&gt;&lt;th COLSPAN=$MAXCOLUMN&gt;Gateway Spreadsheet Data&lt;/th&gt;   &lt;tr&gt;&lt;th&gt; &lt;/th&gt;   &lt;th&gt;A&lt;/th&gt;   &lt;th&gt;B&lt;/th&gt;   &lt;th&gt;C&lt;/th&gt;&lt;/tr&gt;&quot;   FORMAT=&quot; &lt;tr&gt;&lt;td&gt;$ROW&lt;/td&gt;   &lt;td&gt;$A&lt;/td&gt;   &lt;td&gt;$B&lt;/td&gt; &lt;td&gt;$C&lt;/td&gt;&lt;/tr&gt;&quot;   FOOTER=&quot;&lt;/table&gt;&quot;&gt; </p>
         </li>
         <li>
            <p class="para_item"> The FORMAT field can also take on one special value, where FORMAT=&quot;AUTO&quot;. The automatic format mode will generate table information for an active range of rows and columns in the table. To achieve the same results as the previous example you could use the AUTO formatting as shown below.</p>
            <p class="para_item">   &lt;@UGSPREADSHEET NAME=&quot;DEFAULT_SHEET&quot; PART=&quot;WORK&quot;   HEADER=&quot;&lt;table BORDER=1&gt;   &lt;tr&gt;&lt;th COLSPAN=$MAXCOLUMN&gt;Gateway Spreadsheet Data&lt;/th&gt;&quot;   FORMAT=&quot;AUTO&quot;   FOOTER=&quot;&lt;/table&gt;&quot;&gt; </p>
            <p class="para_item"> The automatic formatter will output a table row containing column headers (i.e., A B C ...), and then additional rows containing the row number and cell contents. If you include the HEADER keyword you will need to start the table, and optionally add a title header row to the table as shown in the example above.</p>
            <p class="para_item"> In the simplest case you can use defaults and get a table of the spreadsheet, since the default for HEADER is &lt;table&gt; and the default for FOOTER is &lt;/table&gt;.</p>
         </li>
         <li>
            <p class="para_item"> The LABELS keyword turns off the generation of column and row labels when used with the AUTO formatting capability.</p>
         </li>
      </ul>
   </body>
</html>