Uploading an excel sheet that contains some texts

Question

Yaser Khojah 2021-2-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/738257-uploading-an-excel-sheet-that-contains-some-texts

评论： Walter Roberson 2021-2-10

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]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2021-2-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/738257-uploading-an-excel-sheet-that-contains-some-texts#answer_616797

在 MATLAB Online 中打开

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 个评论
显示 3更早的评论隐藏 3更早的评论

Siddharth Bhutiya 2021-2-8

编辑：Siddharth Bhutiya 2021-2-8

在 MATLAB Online 中打开

As Walter suggested dynamically naming your workspace variables is a bad idea. It would be a lot easier for you to work with the data if you keep it in a table. Looking at the file it seems like the data in your file is transposed, so you can read it into a table and then use rows2vars so that your desired variables become variables in your table and have your desired names.

>> t = readtable('Test_MATLAB.xlsx','NumHeaderLines',1,'ReadRowNames',true);
>> t = rows2vars(t,'VariableNamingRule','preserve')
t =
  5×5 table
    OriginalVariableNames    London Coffee    Imperial Library    Hyde Park (hrs)    London/G Airport
    _____________________    _____________    ________________    _______________    ________________
          {'Var1'}                34                 54                 95                  68       
          {'Var2'}                 9                 93                 62                  97       
          {'Var3'}                24                 72                 73                  74       
          {'Var4'}                62                 54                 79                   2       
          {'Var5'}                67                 53                 11                  73       
>> t.OriginalVariableNames = [] % Remove the original variable names, since you dont need those.
t =
  5×4 table
    London Coffee    Imperial Library    Hyde Park (hrs)    London/G Airport
    _____________    ________________    _______________    ________________
         34                 54                 95                  68       
          9                 93                 62                  97       
         24                 72                 73                  74       
         62                 54                 79                   2       
         67                 53                 11                  73  

You can then access your variables as follows

>> t.("London Coffee")
ans =
    34
     9
    24
    62
    67        

Yaser Khojah 2021-2-10

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.