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
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