importing excel sheet in matlab
4 次查看(过去 30 天)
显示 更早的评论
i just imported an excel sheet in matlab. Then i selected a vector column and loaded it from excel sheet. but data was disorganised as you can see that first entry is different. and why the values are displayed with 2.23e+03 but not like 22300.![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/889205/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/889205/image.png)
0 个评论
采纳的回答
stefan
2022-2-9
Hi,
You're not looking at the top of your column in the command window. As far as I know, the scroll buffer is per default limited to 5000 lines and your table has 100832 rows... hence, your about 95832 lines short with your scroll buffer.
Long story short: It is there but it is just not visualised in the command window. Btw: A good indicator is that the command you've entered to show the first column is also not shown anymore.
As for the display of your values (3.2e+03). This is just the engineering number format. You could change that (see: https://ch.mathworks.com/help/matlab/ref/format.html) but it doesn't change your data or how Matlab calculates with it.
Best,
Stefan
0 个评论
更多回答(2 个)
ali hassan
2022-2-10
2 个评论
stefan
2022-2-10
It is hard to tell from your picture, but still I believe that you're not looking at the top line in the Command Window. Try e.g:
t(1,11)
This gives you the first row and 11th column of the table (there are other ways to access the table, e.g. by the var-name). If you then compare what you see in the table (upper portion of your screen) and in the command window (lower portion of your screen) you should see that they match.
If you still think it is wrong, then you should provide the code and the table you're using.
Best,
stefan
ali hassan
2022-2-10
2 个评论
stefan
2022-2-10
Yes they are absolutely identical...
The following picture is from when I import the table in Matlab and access the same cell as you mentioned before (HYD1psi, first entry). As you can see, I can set the format to whatever I want and like. The value of the cell, however, is absolutly identical in every case.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/890695/image.png)
When you access a full column with command window, as shown in the next picture, matlab will print out all the values of this column (try it with t.HYD1psi). You will see that matlab prints it out sequentially and your window starts to move down. When 5000lines are written (default value) the first line that has been written will no longer be in the command window (it has not infinit memory either) and drops out. That doesn't mean that the value has been deleted or changed, it is just not shown anymore. Since your table is quite large it can't be shown all at once in the command window.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/890700/image.png)
As you can see at (1), I'm at the top of the command window, and at (2) I can't even see the command I've used to open the column. The top value you see there is just one of the last (5000) values that have been printed.
Best,
Stefan
另请参阅
类别
在 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!