{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"maxLevel":{"value":"6"},"minLevel":{"value":"1"},"include":{"value":""},"outline":{"value":"false"},"indent":{"value":""},"exclude":{"value":""},"style":{"value":"default"},"type":{"value":"list"},"printable":{"value":"false"},"class":{"value":""}},"macroMetadata":{"macroId":{"value":"d0f9895c-3480-4a87-bae6-5a678222df6e"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"e3c2a3aa-0ddc-415b-b40c-1376fc2230ae"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Principles of Operation","type":"text"}]},{"type":"paragraph","content":[{"text":"The Excel Channel renders supported nodes from the abstract report by copying ","type":"text"},{"text":"cell patterns","type":"text","marks":[{"type":"strong"}]},{"text":" from the Excel template(s) and “stamping” them on the Excel report:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The cell style is taken from the template.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The cell value is taken from data in the report.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Unsupported nodes are silently ignored, thus a report intended for Word or online should always (at least partially) be convertible to an Excel document.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Cell Patterns","type":"text"}]},{"type":"paragraph","content":[{"text":"A cell pattern is a single, rectangular ","type":"text"},{"text":"range of cells","type":"text","marks":[{"type":"strong"}]},{"text":" in a template with a ","type":"text"},{"text":"name","type":"text","marks":[{"type":"strong"}]},{"text":" assigned to it. Names are assigned in Excel either by selecting a cell or cell range, then defining a name for it, or in the Name Manager.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":994,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":994,"alt":"image-20240326-145513.png","id":"918e5adf-77c0-4209-8467-03db7f38bf6b","collection":"contentId-3252125697","type":"file","height":760}}]},{"type":"paragraph","content":[{"text":"See ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://bmpi.atlassian.net/wiki/spaces/CRDOC/pages/3252125697/Working+with+Excel+Templates#Supported-Node-Types"}},{"text":" for the names to be assigned.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Style and Language Specific Cell Patterns","type":"text"}]},{"type":"paragraph","content":[{"text":"Whenever a pattern is searched for a node with a specific style, the following names are checked in order:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"

Browser not supported