
Contributor III
2022-12-27
07:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Special character in excel sheet name
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.
738 Views
1 Solution
Accepted Solutions


MVP
2022-12-27
07:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]);
730 Views
2 Replies


MVP
2022-12-27
07:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]);
731 Views

MVP
2022-12-27
07:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can you share a sample
in qlikview or liksense it work without previous
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
727 Views
