importing excel sheet in matlab

5 views (last 30 days)
ali hassan
ali hassan on 9 Feb 2022
Commented: ali hassan on 11 Feb 2022
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.

Accepted Answer

stefan
stefan on 9 Feb 2022
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

More Answers (2)

ali hassan
ali hassan on 10 Feb 2022
the values in table and command window are totally different though i changed the style.
  2 Comments
ali hassan
ali hassan on 11 Feb 2022
thanks i tried and its working perfectly fine

Sign in to comment.


ali hassan
ali hassan on 10 Feb 2022
my excel file is as atttached. when i view it in table, it shows in e form but when i load (HYD1_psi_ ) column in command window, it gives value in decimal which is not equal to table.
  2 Comments
ali hassan
ali hassan on 11 Feb 2022
what if i want that when i load the excel file, it also loads all the vector columns instead of loading each column one by one?can it be done?

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!