Tables are groups of cells storing data within your Narrative1 Excel file. When a table is imported into an N1 report document, it will appear as an image. For example, the Real Estate Assessment and Taxes table on the Assessments worksheet in an N1 Excel file is an example of a table.
N1 tables are created via the Name Box in Excel; when you select a group of cells, the Name Box in the top-left hand corner of the screen will display the name associated with your selection. All N1 tables must have N1 as the Name's prefix. All default N1 tables have their range name displayed in blue text below the table.
For example, the Name for the Real Estate Assessment and Taxes table is N1AssessmentTable. The N1 prefix tells the software that the table should be accessible within the report document.
With this in mind, it is possible to create a custom table as long as it follows the above guidelines.
- Create a table of information in Excel.
- Select all of the cells that comprise the table.
- In the Name Box, name the table N1TableName. Ensure that the name contains the N1 prefix. It is recommended that your table name does not contain any spaces.
- Hit enter on your keyboard.
Once you have created your table, you can have it imported into your N1 report document using the Fields and Tables function. Remember to always prep fields and tables when making any workbook changes.