In SAFE you can export datasets to Excel known as
xls files, to make it convenient to process data further. You can either use
existing Excel files and export to specific cells or create new excel files based on a new file name.
The input is
MxN and is a dataset.
|File Name||☐ ExportToExcel|
Name specifies the name of the block.
File name specifies the name of the Excel file that SAFE should export to or create if it does not exists.
Path specifies the path where the Excel file exported should be exported to.
A specfic Excel file can be specified as a template. If a template exists and the file name does not exists, SAFE will copy the template and export to that copy.
Sheet is the specific sheet in the excel file that should be exported to. This is useful if you have multiple sheets in the Excel file.
Inputs specifies the number of inputs(s) the block will have. Each input can be configured to export to a specific cell as seen below.
|Insertion Type||Overwrite Cells|
Cell specifies the cell that the input is outputted to. This can change dependent on insertion type.
Data specifies the data that should be exported. Choose between X data and Y data.
Insertion type is the way SAFE should export to cells. Choose between:
Overwrite Cells, which overwrites the value in the cell.
Append Colummns and
Append Rows which if a value already exists
the checks the next column or row until a cell which does not have value becomes available. The last type is
Insert Columns and
Insert Rows which inserts a new columns or row in the excel sheet. Notice should be taken to this option as multiple rows and colums could be created if you have multiple of this type of export.