3.2 Macro Sheet Part of a Workbook

  • Article

This example shows a usage of an Excel Macro Sheet part. See section 2.2.1.3 for more information. Consider the following XML, showing the complete contents of a Macro Sheet part of a workbook.

 <xm:macrosheet 
   xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
   xmlns:xm="http://schemas.microsoft.com/office/excel/2006/main"
   xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
   <dimension ref="A1"/>
   <sheetViews>
     <sheetView showFormulas="1" tabSelected="1" workbookViewId="0">
       <selection activeCell="A2" sqref="A2"/>
     </sheetView>
   </sheetViews>
   <sheetFormatPr defaultRowHeight="15"/>
   <sheetData>
     <row r="1" spans="1:1">
       <c r="A1" t="b">
         <f>ACTIVATE()</f>
         <v>0</v>
       </c>
     </row>
   </sheetData>
   <pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/>
 </xm:macrosheet>

The macrosheet element (section 2.2.2.1) specifies the macro sheet. A formula following the grammar specified in section 2.2.6 is specified by the f element ([ECMA-376] Part 4, Section 3.17).