Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What would the below statement do?
LOAD * FROM
[..\..\..\Test\*.xlsx](ooxml, embedded labels);
Would it load all the tabs present in the excel or would it just load the first sheet?
It won't load all sheets. If you need that see this document: Loading Multiple Excel Sheets Dynamically along with file name and sheet name
it wont load any thing!