i am not able to import excel sheet

3 views (last 30 days)
Reddy R
Reddy R on 10 Dec 2019
Answered: Star Strider on 10 Dec 2019
I am using matlab for past few months and i was able to import excel files. but all the sudden i am not able to import excel files, not able to figure why it is happening.
i am getting this error
error import.JPG
  4 Comments
Image Analyst
Image Analyst on 10 Dec 2019
They should have told you. When I call them they will setup a webex to work through the issue on my own computer. If they can't solve it right away (common with me since if I have to call them the problem is extraordinarily tricky), then they say they will work it offline and call me back. They usually call back the same day, or sometimes I'll get an email the next morning. What did the tech support person say to you?
Reddy R
Reddy R on 10 Dec 2019
i didnot get any response from the tech support yet.

Sign in to comment.

Answers (1)

Star Strider
Star Strider on 10 Dec 2019
One approach would be to open Excel, then save your spreadsheet as a .txt file (likely a comma-delimited text file). Then import it with readtable. This gets around actrrually having to to use Excel to read the file, since essentially everything can read a text file. Excel does not make this easy, so remember also to save it to your local drive, not OneDrive.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!