Using xlsread values from column P and forward

1 次查看（过去 30 天）
Ricardo G
Ricardo G 2018-6-14
编辑： Walter Roberson 2018-6-15
I am reading an excel file using xlsread() function.
xlRange = 'B2:AV2';
result = xlsread(filename, sheet, xlRange);
When I print the result matrix I noticed the xlsread() is not returning expected results. The first elements in the result matrix (from range B2 to O2) are equal to the values in the Excel file. However, and strangely, values from range P2 to AV2 does not coincide with the values in the Excel file.
So I proceeded to do the following test
result = xlsread(filename, sheet, 'P2');
And when I print the result matrix, its value its completely different from the value in the Excel file.
Digging a little bit more, I found out that the value returned for P2 was not a random number, but the same as for C2. And subsequently, value requested for Q2 returns the value in D2 and so on.
P2 = C2
Q2 = D2
R2 = E2
...
I have been scratching my head for hours, any help would be much appreciated

请先登录，再回答此问题。

采纳的回答

ES
ES 2018-6-14
编辑：Walter Roberson 2018-6-15
What kind of data do you have in your excel file? xlsread can have three outputs, numbers, text and raw. Which of it are you using?
Becuase when you simply use
result = xlsread(filename, sheet, xlRange);
only the numbers in the range are read.
Use to read all contents
[num,txt,raw] = xlsread(___)
https://in.mathworks.com/help/matlab/ref/xlsread.html
  1 个评论
Ricardo G
Ricardo G 2018-6-15
You were right, the some of the data was pasted/imported as text, had to convert the cell type to number and the problem was fixed! Thank you!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by