Select * from sheets[0]

panchmp / sqlsheet

Automatically exported from code.google.com/p/sqlsheet

Other

27 stars 11 forks source link

Select * from sheets[0] #40

Closed hakimda closed 2 months ago

hakimda commented 3 years ago

Hi, Greag tool with scriptella. I'm unable to : select * from "sheet accessed by index".I have only one sheet in the workbook but don't know the name of the sheet. Thanks

manticore-projects commented 2 months ago

Greetings!

Sorry for being a bit late. Access by sheet index works now, e. g.

select * from "sheet[0]"

Please note:

you need to use quotes (either double quotes " or back-ticks)
index starts at 0 (not 1)