MATLAB: Importing from Excel dropping first column

Question

Hi everyone,

I have some code that imports time series data from Excel into MATLAB on my Mac laptop using xlsread. When I send the code to my advisor and he runs it on his PC, he runs into significant problems because his MATLAB seems to skip the date column, so the first column of the imported document is the second column of the Excel file. It occurs to me that this must be a compatibility issue, but I cannot find a quick fix anywhere. Thoughts?

Thanks in advance.

Answer 1

You forgot to attach the file. Change the numbers and text if you need to anonymize it, but it's the only way we can try it. Does he see all columns if he opens it in Excel rather than MATLAB? Is the data in a table format (columns of data with a row for column headers)? Can you use readtable() instead of xlsread()?

t = readtable(excelFullFileName);