Skip to main content
Version: current

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.

MxN

Input#

The input is MxN and is a dataset.

Attributes#

AttributeValue
NameExportToExcel
File Nameโ˜ ExportToExcel
Path'$project/ExportToExcel.xlsx'
Template
Sheetโ˜ Sheet
Inputs1

Name#

Name specifies the name of the block.

File Name#

File name specifies the name of the Excel file that SAFE should export to or create if it does not exists.

Path#

Path specifies the path where the Excel file exported should be exported to.

Template#

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#

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
CellA1
DataY Data
Insertion TypeOverwrite 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.

Literature#