For a local file system repository, the Repository Content Panel shows the folder/file structure, as shown in Figure 36. Right click on a folder and select Refresh to view changes in that folder since you connected (or last refreshed), such as addition/removal/renaming of contents.
...
Syndeia offers additional capabilities for Excel files managed in local file system repositories.The Excel file can be expanded in the Syndeia dashboard and users can see the following (Figure 37):
- Sheets – These are spreadsheets inside the workbook file (.xlsx or .xls).
- Named references – These are names defined in the Excel workbook using the Name Manager (Formulas > Name Manager). Alternatively, named references can be defined by selecting a single or group of cells, right clicking, and selecting Define Name from the menu (Figure 38). Named references can be defined in the context of the workbook or a specific sheet, as shown in Figure 37. If defined in the context of the workbook, named references show up directly under the workbook in the Excel tree in the Syndeia Dashboard (see the named reference Org). If defined in the context of a sheet, named references show up under that sheet in the Excel tree (see the table Car_Info_Table in the Cars sheet).
- Tables – These are named references that satisfy the following criteria:
- A table must have at least 2 rows.
- A table must have a contiguous area. A non-contiguous area of cells is shown in Figure 39 (not a table).
- The first row is treated as a header row which should have names of all columns. Only alpha-numeric characters may be used as column names.
- An empty table can be defined with only two rows where the first row has the column names and the second row is empty.
Table Rows – These are entries in the table, starting with the second row. A table row is shown in the Excel tree using the column name (value) format.
...