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)
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)

Community Treasure Hunt

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

Start Hunting!

Translated by