For a local file system repository, the Repository Content Panel shows the folder/file structure, as shown in Figure 35. 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.
Excel
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:
- 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. Named references can be defined in the context of the workbook or a specific sheet. 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 (as shown in figure below). A non-contiguous area of cells is also shown (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.
To view the latest contents of an Excel workbook in the Syndeia Dashboard—it may have changed since you last connected or expanded it—right click on the parent folder of that workbook and select Refresh. Do not invoke refresh on the workbook itself.