<< Click to Display Table of Contents >> Navigation:  Sources > Excel

Sheets may be referenced by name or index. Example:

 
Sample.Sheet1
Sample."Sheet Name with spaces"
Sample.Sheets(0)

 

File name without postfix means first sheet.

 

Column naming convention is A, B, C, etc. To get row number use _row field.

If first row is header row, columns can be referenced by its names from first row and firs row is skipped. To use this mode pass true as first parameter, f.e.

 

select * from sample(true)

 

All cell values are treated as strings, to convert it to other types use conversion functions or cast statement.