Uploading an excel sheet that contains some texts

1 view (last 30 days)
Dear there, I need a help with uploading an Excel sheet then converting everything to a matrix. My issue comes as there are some texts in the first column and each one contains space. So, when I uploaded the excel sheet, I struggled to call a text as a variable (e.g. Field_A) and its belonging numbers (e.g all the rows). For example, my table would look like the below. Please note my sheet is much more complex than the below. I need an easy way to do the following please.
% my excel sheet would look like this one. This is only an example, while mine is more compicated
Jan Feb Mar
Field A 10 90 80
Field B 20 10 70
Field C 50 10 30
Total Production 80 110 180
% after i uploaded the excel sheet, I want to create my variable as below
Field_A = [10, 90, 80]
Field_B = [20, 10, 70];
...
Total_Prouduction = [80, 110, 180]

Accepted Answer

Walter Roberson
Walter Roberson on 7 Feb 2021
t = readtable(filename) ;
field_yeilds = t{1:end-1, 2:end};
total_prod = t{end, 2:end};
crosscheck = sum(field_yeilds,1) - total_prod %(should be 0)
  5 Comments
Yaser Khojah
Yaser Khojah on 10 Feb 2021
Dear@Walter Roberson thank you so much for your help. I agree with you but wanted a way as I have many excel sheet to deal with. Dear @Siddharth Bhutiya thank you so much for sharing this. I will try it on my code and ask some questions. I'm sorry for my late response as I have the matlab installed in a different machine which I cant access all the time.
Walter Roberson
Walter Roberson on 10 Feb 2021
The more excel sheets you have to deal with, the more likely you are to accidentally clobber some variable you were using for something else.

Sign in to comment.

More Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!