Read Spreadsheet

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

Input

Name	Type	Structure	Description
Path	Text	Tree	File path which points to a spreadsheet as absolute path or relative to current .gh file location
Name of sheet	Text	Tree	Name of sheet inside the spreadsheet to read information from. Default is first sheet
CellStart	Text	Tree	Cell inside the sheet where reading of information should begin. Defalut is A1
CellEnd	Text	Tree	Optional cell where reading should stop. If not specified the end of the block of information to read will be determined automatically
Has Header	Boolean	Tree	If true the first row/column in the block of information to read is interpreted as header information
Read horizontally	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