Sample spreadsheet template with fields, table and formula reffering to table.
Sample Spreadsheet | ||
This document provides a sample spreadsheet template with fields, a named table, and formulas referring to the table. | ||
Regular Fields | ||
You can bind placeholders to regular fields like this, cell content will be replaced with passed value: | ||
Field 1: | {field1} | |
Field 2: | {field2} | |
Named Table | ||
You can create a named table with dynamic rows by binding each column cell with property name followed by # and name of table. | ||
Table Data | ||
Column 1 | Column 2 | Column 3 |
{#table.column1} | {#table.column2} | {#table.column3} |
Formulas Referencing Table | ||
Total Column 2 | =SUM(table[Column 2]) | |
Average Column 3 | =AVERAGE(table[Column 3]) | |
Count of Rows | =COUNTA(table[Column 1]) | |
Summary | ||
This spreadsheet demonstrates how to use fields, tables, and formulas effectively. | ||
Remember to set the correct data types for each field and table column (number, string) to ensure that formulas work correctly. | ||
You can add more rows to the table, and the formulas will automatically adjust to include the new data. |
This document template includes dynamic placeholders for automated document generation with Documentero.com. Excel Template - Free download
Download Excel Template (.XLSX)Download the Sample Spreadsheet template in .XLSX format. Customize it to suit your needs using your preferred editor (Excel, Google Sheets...).
Upload the template to Documentero - Document Generation Service, then map and configure template fields for your automated workflow.
Populate templates with your data and generate Excel (XLSX) documents using data collected from shareable web Forms, APIs, or Integrations.
DocumentDOCX
DocumentDOCX
DocumentDOCX
DocumentDOCX