topic Re: Special character in excel sheet name in Data Movement & Streaming

Special character in excel sheet name

amaaiia — Wed, 19 Mar 2025 23:06:21 GMT

I'm trying to read some excel sheets by sheet name. One sheet name is 'a&b', but I get an error.

I try:

(ooxml, no labels, header is 12 lines, table is 'a&b');

But:

The following error occurred: Unexpected token: '&', expected one of: ',', ')', 'Where', 'While', 'Group' ....... (ooxml, no labels, header is 12 lines, table is ***>>>>>>&<<<<<<b)

How can I read filenames with special characters? I've also tried with chr(38) instead of &, but same error.

Re: Special character in excel sheet name

Or — Tue, 27 Dec 2022 12:18:05 GMT

Square brackets should work, I believe:

(ooxml, no labels, header is 12 lines, table is [a&b]);

The following loads correctly:

LOAD
A, B
FROM [lib://AttachedFiles/New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is [A&B]);

Re: Special character in excel sheet name

Taoufiq_Zarra — Tue, 27 Dec 2022 12:23:15 GMT

@amaaiia

can you share a sample

in qlikview or liksense it work without previous