If I run this code :
Code: Select all
importtbl(name=folhas) cv1.xlsx range="graf!a1:z100"
I get this error:
'cv1.xlsx range=""graf!a1:z100' is not a legal file name in
"IMPORTTBL(NAME=FOLHAS) CV1.XLSX
RANGE="GRAF!A1:Z100"".
and I have been unable to set a range for my excel sheet.
If I run this code below, it runs fine:
Code: Select all
importtbl(name=fls) cv1.xlsx