Read Spreadsheet

Read information from a spreadsheet file created with Excel or LibreOffice. Select type of returned output structure in the context menu.

The component features a context menu, accessible by right-clicking.

Input

Name	Type	Structure	Description
File Path	Text	Tree	File path which points to a spreadsheet as absolute path or relative to current .gh file location
Sheet Name	Text	Tree	Name of sheet inside the spreadsheet to read information from. Default is first sheet
Cell Start	Text	Tree	Cell inside the sheet where reading of information should begin. Defalut is A1
Cell End	Text	Tree	Optional cell where reading should stop. If not specified the end of the block of information to read will be determined automatically
Header	Boolean	Tree	If true the first row/column in the block of information to read is interpreted as header information
Horizontal	Boolean	Tree	If true data will be read horizontally from left to right, otherwise vertically from top to bottom

Output

Name	Type	Structure	Description
Depends	Text / Number / Integer / Boolean	List / Tree	Output parameters which get adjusted automatically according to the information contained inside the spreadsheet

Context menu

Name	Description
Combine output with the same name	Merges data from multiple columns or rows with the same header into a single data tree output
Single output	Combines all imported data into a single tree structure, simplifying the output
Remove empty cells	Excludes empty cells from the output. Only meaningful data is included