I have downloaded trial version of FME 2015 and I try to read an Excel file which included multiple sheets with filtered columns and pivot tables. I want to read this file in FME and write the data into a Postgres database.
When I use the Excel Reader to preview the file in FME I see that the columns with the non-latin characters are replaced with question marks. How can I set the encode type in the reader? Should I do it before I load the file to FME? I have already tried to save the excel file with a different encode type but still the problem occurs. Any suggestions?