Importing Excel Database Into MATLAB

1 回表示 (過去 30 日間)
Selim Elbadri
Selim Elbadri 2022 年 12 月 9 日
コメント済み: Voss 2022 年 12 月 11 日
Hi,
I have an excel dataset 'dataset2' which I want to import into MATLAB. I will then perform some matrix manipulations. I am running the code below but it does not seem to be doing exactly what I want:
clc
clear all
cd 'C:\XXXX'
test = readtable('./dataset2.xlsx','Sheet','Sheet1','Range','A2:CA26','TreatAsEmpty',{'.'},'Format','auto');
For some reason, the second row was taken as variable names and not the first. I don't know what happened to the first row. How can I fix this such that only the first row is considered the variable name/header?
Thank you!

サインインしてこの質問に回答する。

採用された回答

Voss
Voss 2022 年 12 月 9 日
Ran in:
The problem is that you're specifying the Range to start on row 2. Remove the Range arguments:
test = readtable('./dataset2.xlsx', ...
'Sheet','Sheet1', ...
...'Range','A2:CA26', ...
'TreatAsEmpty',{'.'}, ...
'Format','auto');
disp(test)
RNr a_vAUS28 a_vAUS29 a_vAUS30 a_vAUS31 a_vAUS32 a_vAUS33 a_vAUS34 a_vAUS35 a_vAUS36 a_vAUS37 a_vAUS38 a_vAUS39 a_vAUS40 a_vAUS41 a_vAUS42 a_vAUS43 a_vAUS44 a_vAUS45 a_vAUS46 a_vAUS47 a_vAUS48 a_vAUS49 a_vAUS50 a_vAUS51 a_vAUS52 id ind_1_i ind_2_i ind_3_i ind_4_i ind_5_i ind_6_i ind_7_i ind_8_i ind_9_i ind_10_i ind_11_i ind_12_i ind_13_i ind_14_i ind_15_i ind_16_i ind_17_i ind_18_i ind_19_i ind_20_i ind_21_i ind_22_i ind_23_i ind_24_i ind_25_i e_vector ec_vector ind_1 ind_2 ind_3 ind_4 ind_5 ind_6 ind_7 ind_8 ind_9 ind_10 ind_11 ind_12 ind_13 ind_14 ind_15 ind_16 ind_17 ind_18 ind_19 ind_20 ind_21 ind_22 ind_23 ind_24 ind_25 ___ __________ _________ __________ __________ __________ __________ __________ __________ __________ _________ __________ __________ _________ __________ __________ __________ __________ _________ ________ ________ ________ ________ _________ _________ __________ __ _______ _______ _______ _______ _______ _______ _______ _______ _______ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ _________ _______ _______ ______ _______ ______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ ______ ______ ______ ______ _______ _______ _______ 28 0.0010661 0.0086166 0.011514 0.046485 0.011402 0.0019305 0.016032 0.01445 0.0016091 0.0051013 0.0030389 0.014035 0.0036651 0.00046417 0.00023188 0.00030533 0.0014186 0.0032941 0 0 0 0 0.0075036 0.0028969 0.00086978 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2669.9 2668.6 0.32944 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29 0.083806 0.021775 0.016656 0.040204 0.017705 0.032528 0.012003 0.034374 0.037409 0.010128 0.019797 0.02894 0.014489 0.0017971 0.00064889 0.00077506 0.004389 0.012087 0 0 0 0 0.013605 0.01235 0.016888 2 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18271 13428 0 0.44808 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 0.014286 0.010422 0.01109 0.01706 0.0055564 0.0082788 0.0074796 0.011411 0.014948 0.0046424 0.0078812 0.0096212 0.0042177 0.0012371 0.00036031 0.00047073 0.0018144 0.0038626 0 0 0 0 0.0063861 0.0040625 0.0051933 3 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25340 24296 0 0 0.5629 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 31 0.0045378 0.0099685 0.0049521 0.027317 0.0061963 0.0065567 0.010462 0.0098918 0.011058 0.0051275 0.0038813 0.0086592 0.0030523 0.00055429 0.00028034 0.00053917 0.0011443 0.0032298 0 0 0 0 0.0046817 0.0064894 0.0043905 4 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4320.6 3894.6 0 0 0 0.43962 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 32 0.00039033 0.001749 0.00079191 0.0003452 0.14269 0.0011335 0.00042608 0.0029603 0.0011987 0.0010061 0.00011557 0.0028754 0.0025942 0.00019692 6.4793e-05 4.8131e-05 0.00048564 0.003111 0 0 0 0 0.0022937 0.001948 0.00081663 5 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3.1324 2.8636 0 0 0 0 0.3835 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33 0.00221 0.016895 0.007648 0.0026093 0.0078314 0.023875 0.010656 0.016845 0.0040437 0.009051 0.0097498 0.016216 0.013498 0.0027181 0.0017121 0.002863 0.0013234 0.023685 0 0 0 0 0.018315 0.016345 0.0080661 6 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 248.01 128.89 0 0 0 0 0 0.31221 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34 0.0068609 0.075441 0.0075602 0.012076 0.13654 0.064763 0.050445 0.0058028 0.0021253 0.022636 0.0022 0.0056182 0.00557 0.0011356 0.00036095 0.00011293 0.0024564 0.0094773 0 0 0 0 0.018825 0.011702 0.0031764 7 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 937.03 875.94 0 0 0 0 0 0 0.46845 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35 0.0071531 0.007782 0.0081536 0.0073833 0.0008902 0.0016808 0.006163 0.030357 0.0054666 0.0082686 0.0049191 0.012297 0.0066874 0.002009 0.0018096 0.0038792 0.00081929 0.010963 0 0 0 0 0.0072771 0.0058083 0.0046366 8 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.8202 0.30362 0 0 0 0 0 0 0 0.46041 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36 0.0019121 0.0085154 0.004225 0.003308 0.0021618 0.0052064 0.0069055 0.0075769 0.0016881 0.0096628 0.0062111 0.0072593 0.0052885 0.0022137 0.00097316 0.001292 0.00092078 0.011731 0 0 0 0 0.010012 0.0064175 0.0029907 9 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18756 18732 0 0 0 0 0 0 0 0 0.40473 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 37 0.0037325 0.0069648 0.011032 0.0013403 0.00077373 0.0014753 0.0025023 0.0092767 0.0032375 0.0093556 0.0052118 0.0092315 0.012274 0.00076858 6.0584e-05 0.00019749 0.0031075 0.011911 0 0 0 0 0.0089415 0.0050869 0.018469 10 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2224.6 1837.5 0 0 0 0 0 0 0 0 0 0.53816 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 38 0.0012865 0.0022148 0.0062094 0.00068735 0.00099376 0.0016926 0.0013236 0.0013609 0.025182 0.068951 0.19933 0.0021938 0.012839 0.0022783 0.00030057 0.00031131 0.0030657 0.012988 0 0 0 0 0.012977 0.0023286 0.0014258 11 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1014.6 610.1 0 0 0 0 0 0 0 0 0 0 0.42883 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39 0.018829 0.023771 0.023678 0.0093996 0.0044733 0.0065403 0.030715 0.017003 0.011807 0.0064045 0.018963 0.017289 0.017297 0.004785 0.0014971 0.007749 0.0052158 0.024141 0 0 0 0 0.016192 0.020345 0.01241 12 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 6265.5 5426.9 0 0 0 0 0 0 0 0 0 0 0 0.46383 0 0 0 0 0 0 0 0 0 0 0 0 0 40 0.0028302 0.018322 0.0087614 0.0036136 0.0044319 0.004537 0.0080713 0.012516 0.0050527 0.0061306 0.0057787 0.041923 0.07848 0.0079341 0.012579 0.0093529 0.0025976 0.032046 0 0 0 0 0.023702 0.055041 0.014254 13 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4677.1 1055.6 0 0 0 0 0 0 0 0 0 0 0 0 0.53483 0 0 0 0 0 0 0 0 0 0 0 0 41 0.01217 0.023112 0.014422 0.010783 0.020457 0.010794 0.026403 0.010609 0.0092554 0.0090157 0.01425 0.012892 0.0078582 0.022229 0.066994 0.0045956 0.10962 0.02161 0 0 0 0 0.023804 0.010605 0.0093373 14 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 10373 10337 0 0 0 0 0 0 0 0 0 0 0 0 0 0.68638 0 0 0 0 0 0 0 0 0 0 0 42 0.015373 0.0053588 0.0051739 0.0021801 0.00038545 0.000344 0.0016119 0.0017888 0.0065113 0.0086108 0.006397 0.0017108 0.0026838 0.0019425 0.00043492 0.00144 0.0041193 0.0034229 0 0 0 0 0.0045935 0.001528 0.00056212 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 12147 12103 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.63999 0 0 0 0 0 0 0 0 0 0 43 0.005349 0.00417 0.0023993 0.001057 0.00040086 0.0007485 0.0011666 0.0060436 0.0016542 0.0011495 0.0017602 0.0063062 0.0012227 0.19646 0.21311 0.16523 0.00094442 0.0058771 0 0 0 0 0.0024313 0.032573 0.0016632 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1031.4 1014.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.73492 0 0 0 0 0 0 0 0 0 44 0.002011 0.060014 0.025535 0.0215 0.0043954 0.022116 0.0379 0.042299 0.020868 0.0031982 0.020329 0.040879 0.012241 0.014277 0.018003 0.0047754 0.055811 0.019538 0 0 0 0 0.074187 0.0041811 0.0032416 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 36148 34057 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.65156 0 0 0 0 0 0 0 0 45 0.04819 0.046089 0.053854 0.028723 0.020489 0.027539 0.046399 0.01387 0.022321 0.026971 0.031585 0.020528 0.089917 0.0038935 0.0036455 0.022877 0.034845 0.14111 0 0 0 0 0.052487 0.030747 0.0091054 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 5916.4 973.35 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.43663 0 0 0 0 0 0 0 46 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 47 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 48 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 49 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50 0.027279 0.023988 0.036413 0.010269 0.010147 0.096109 0.08032 0.023419 0.052592 0.085338 0.021994 0.021545 0.029713 0.010197 0.0064994 0.018262 0.026497 0.043945 0 0 0 0 0.064736 0.02332 0.018333 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1209.2 1198.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.47537 0 0 51 0.008486 0.0046323 0.0045147 0.011564 0.0014474 0.0010147 0.019616 0.010228 0.0022712 0.014199 0.0070896 0.010658 0.014347 0.00069585 0.00040194 0.001119 0.002749 0.017078 0 0 0 0 0.010685 0.027264 0.0067314 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 817.05 614.34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.56358 0 52 0.0035653 0.0010284 0.0010699 0.0010424 0.00059326 0.00093215 0.0030838 0.00072262 0.00098229 0.0009026 0.0012414 0.00080937 0.0043978 0.0025197 0.00060875 0.0018078 0.00095667 0.0065512 0 0 0 0 0.0046596 0.0026175 0.0071311 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 8486.9 8418.2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.73377
In fact, for this particular file, you get the same result without specifying any Name,Value argument pairs (i.e., using all defaults):
test2 = readtable('./dataset2.xlsx');
isequal(test,test2) % same as above
ans = logical
1
  2 件のコメント
Selim Elbadri
Selim Elbadri 2022 年 12 月 11 日
Thank you very much!
Voss
Voss 2022 年 12 月 11 日
You're welcome!

サインインしてコメントする。

その他の回答 (2 件)

Jon
Jon 2022 年 12 月 9 日
I just ran
T = readtable('dataset2.xlsx')
and it seems to import without any problems
  1 件のコメント
Selim Elbadri
Selim Elbadri 2022 年 12 月 11 日
Thank you very much!

サインインしてコメントする。

Jeremy Hughes
Jeremy Hughes 2022 年 12 月 9 日
This issue is in the call to readtabkle
test = readtable('./dataset2.xlsx','Sheet','Sheet1','Range','A2:CA26','TreatAsEmpty',{'.'},'Format','auto');
In this call Range has a starting cell of A2, which means it starts on the second row. From there, it assumes the first row is variable name, Also, format=auto is probably not needed, if it works without it, that would be best.
test = readtable('./dataset2.xlsx','Sheet','Sheet1','Range','A1:CA26','TreatAsEmpty',{'.'});
  1 件のコメント
Selim Elbadri
Selim Elbadri 2022 年 12 月 11 日
Thank you very much!

サインインしてコメントする。

カテゴリ

Help Center および File Exchange で Spreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by