Export to Excel
Description
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.
Input
The input is MxN and is a dataset.
Attributes
| Attribute | Value |
|---|---|
| Name | ExportToExcel |
| File Name | ☐ ExportToExcel |
| Path | '$project' |
| Overwrite | True |
| Template | |
| Sheet | ☐ Sheet |
| Inputs | 1 |
Name
Name specifies the name of the block.
File Name
File name specifies the name of the Excel file that SAFE should export to. The file will be created if the file does not exist.
Path
Path specifies the path where the Excel file exported should be exported to.
Overwrite
Controls if the file will be overwritten if it exists.
Template
A specific Excel file can be specified as a template. If a template exists and the file name does not exist, SAFE will copy the template and export to that copy.
Sheet
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
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.
| IN1 | |
|---|---|
| Cell | A1 |
| Data | Y Data |
| Insertion Type | Overwrite Cells |
Cell
Cell specifies the cell that the input is outputted to. This can change dependent on insertion type.
Data
Data specifies the data that should be exported. Choose between X data and Y data.
Insertion Type
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.