Inquiry

Please clarify the question. Imported from Excel to what format?

thank you Serge for your interest in my problem. i meant importing a .xlsx file into IDE 

I understand that you want to import XLS file, but what do you want to get as a result? A text file, a database, a CSV? What problem are you trying to solve? How is that specific to the IDE?

i want to know if data can be handled in Intellij IDE as it is in R and Matlab?

IDE is just an editor for your code, it doesn't do magic to handle your data automatically.

What language are you writing your code in? IntelliJ IDEA supports many languages, so your question is not clear.

I code with Java 

So you should be looking for Java libraries that support loading .xlsx files, not for IDE features.