Matlab - Reading CSV data

Question

I need to import data from a CSV file containing text and numbers, as shown below. csvread and other methods dont seem to be working, is there a way around this?

How much of the information do you need? Only the numbers? There is no way to store all that information in a single matrix in MATLAB. The closest you can get is table. You can for instance not include A1:A4 in such a table. — Stewie Griffin
– Stewie Griffin, Commented May 3, 2016 at 6:28

Community · Accepted Answer · 2017-03-20 10:18:16Z

1

I suggest you try readtable:

T = readtable('csv_file.csv',...
    'Range','CA4:F11',...
    'ReadVariableNames',true)

I'm not sure if it will be able to handle % TYPE in A4, but you might have to delete that cell for this to work.

Note: You have to save this as a .xls, .xlsx, .xlsm, .xltx, or .xltm-file for this to work. It's easy to import a csv file into excel and save it as an xlsx-file, so that shouldn't be a problem if you have MS Office.

It's of course possible to do this using the csv-file directly, but that's a bit more messy.

edited Mar 20, 2017 at 10:18

CommunityBot

11 silver badge

answered May 3, 2016 at 6:34

Stewie Griffin

14.9k11 gold badges41 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Matlab - Reading CSV data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related