Importing from Excel dropping first column
13 次查看(过去 30 天)
显示 更早的评论
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.
0 个评论
采纳的回答
Image Analyst
2014-10-23
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);
2 个评论
Image Analyst
2014-10-23
Ah, you were just doing
numbers = xlsread(filename);
I almost never do that. Usually I want the raw cell array like you get by doing
[numbers, strings, raw] = xlsread(filename);
The usual reason I do this is that the rows and columns for numbers and strings is out of sync. A certain row, column specified for numbers and strings does not refer to the same cell in Excel, whereas it does with raw. But in your situation, you could get the dates in the non-numeric format (whatever that is) by using the third return argument of xlsread() and shouldn't have to worry about converting format in Excel prior to importation.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!