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
talebi
Offline
Last seen: 1 week 6 days ago
Joined: 11/23/2021 - 14:15
Maybe save it as a CSV file then import it.
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 ?.
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!