Dealing with UTF-8 in BRAINscript

I tried with Unidode as well but still it's not working.

At first I thought it was just data in a field and not the field name itself. I don't think you're going to be able to read this without manipulating the fieldnames.

Here's an idea - you might be able to use headerRow="2" to skip the header and then have some logic to rename fields back using inputFields(1). Have a look at this reading a simple Excel and bypassing the header row.

Code:

---

node:Excel_File
bretype:core::Excel File
editor:sortkey=5d012dbf08020e2a
output:@48cf6cd2305e5f95/=
prop:File={{^FileName^}}
prop:UseSystemLocale=false
prop:WorkbookSpec=<<EOX
<workbook>
<sheet index="1" headerRow="2" dataStartRow="2" />
</workbook>
EOX
editor:XY=350,380
end:Excel_File

node:Filter_3
bretype:core::Filter
editor:sortkey=5d013ade07242fe9
input:@40fd2c74167f1ca2/=Excel_File.48cf6cd2305e5f95
output:@40fd2c7420761db6/=
prop:Script=<<EOX
_inputFields = inputFields(1)

emit _inputFields[0] as "Field1"

EOX
editor:XY=450,380
end:Filter_3

---