importing excel sheet in matlab
5 views (last 30 days)
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.
stefan on 9 Feb 2022
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.