How to solve xlsread reading problem ?

1 次查看（过去 30 天）
Anurag Pujari
Anurag Pujari 2016-4-9
编辑： Walter Roberson 2016-4-9
I have some dataset in excel and it looks like below:
18597.7 18948 20638.4 21640 10756.9 11650.5 10169.2 10561.4 23345.7 23849.3
9626.39 8904.5 11493.8 10379.2 9502.79 9820.17 10263.6 11049.2 14270.6 12595.5
291.195 219.856 325.569 283.287 334.142 620.478 408.943 367.155 179.294 249.224
1367.97 1529.94 1615.2 1551.5 3998.73 4331 3953.89 3870.35 1155.08 1297.32
Now, whenever I read the file using xlsread, the values turn to this:
[a b]=xlsread('filename')
a =
1.0e+04 *
1.8598 1.8948 2.0638 2.1640 1.0757 1.1650 1.0169 1.0561 2.3346 2.3849 2.2064 2.5963
0.9626 0.8904 1.1494 1.0379 0.9503 0.9820 1.0264 1.1049 1.4271 1.2595 1.3032 1.4103
0.0291 0.0220 0.0326 0.0283 0.0334 0.0620 0.0409 0.0367 0.0179 0.0249 0.0068 0.0157
0.1368 0.1530 0.1615 0.1552 0.3999 0.4331 0.3954 0.3870 0.1155 0.1297 0.1512 0.1825
What should I do so that I get my values as it is. Why this exponential ?

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

回答（1 个）

Walter Roberson
Walter Roberson 2016-4-9
Give the command
format long g
and display your data again.
  1 个评论
Anurag Pujari
Anurag Pujari 2016-4-9
Thanks for the answer. But what have this command done? This command must have been mentioned along with the xlsread function description.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by