Question marks appearing when I import Excel spreadsheet into IDEA

4 posts / 0 new
Last post
talebi
Offline
Joined: 11/23/2021 - 14:15
Question marks appearing when I import Excel spreadsheet into IDEA

Hello,
I converted a xls file to xlsx file to import itnto IDEA. It seems IDEA does not support xls, right?
Then, I tried to import xlsx (Excel 2016) but question marks appear at the beginning and end of each string (character) cell!
How can I import the data without having question marks?
Please see the images

Images: 
CFE4130
Offline
Joined: 08/05/2019 - 12:59

Maybe save it as a CSV file then import it.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

IDEA should support xls and it is hard to tell why the ? are being added without actually seeing the file. Could be unicode characters that are not showing up and being replaced by ?.

talebi
Offline
Joined: 11/23/2021 - 14:15

I tried different ways to fix the problem by replacing unicode characters but they did not work. SO, I asked to change the format to XML format and the problem did not show up! regarding the xls file, my IDEA does not import xls format so when I change it to xlsx format, it is working!