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.

Walter Roberson 2021-2-10

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.

请先登录，再进行评论。

Uploading an excel sheet that contains some texts

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

采纳的回答

5 个评论
显示 3更早的评论隐藏 3更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

Uploading an excel sheet that contains some texts

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

采纳的回答

5 个评论 显示 3更早的评论隐藏 3更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

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

5 个评论
显示 3更早的评论隐藏 3更早的评论