hi there can anyone help me, i have problem in reading the excel file using the csvread command

[Yusuf Suer Erdem]

could you try using 'readcell' instead of 'csvread'?

[Walter Roberson]

Please show the complete error message -- everything in red.

Also, we recommend that you use fullfile() instead of strcat() to construct filenames.

FilePath = fullfile(ProjectPath, 'Data_1.csv');

[dpb]

Also recommend using readtable or one of the other more recent input functions instead of csvread

If the file contains anything other than numeric values, csvread is guaranteed to fail -- at most you can skip a header line, but it isn't smart enough to do that on its own.

Also, much easier for folks here if you paste the actual text instead of images and attachments -- if you're going to attach anything it would be more useful to have the input file so we could see its content.

[Walter Roberson]

If you know ahead of time what the file format is like, then csvread() can be used to skip any fixed number of leading rows, and any fixed number of leading entries, even when those rows or entries contain text. However, csvread() cannot be used to skip trailing rows or trailing or intermediate text columns.

Answer 1

[Prateek Rai]

Hi,

Using "csvread" to read comma-separated value (CSV) file is not recommended.Use "readmatrix" instead.

You can refer to readmatrix MathWorks documentation page to find more on this.