⑴ matlab鎬庝箞璇誨彇xls鏂囦歡涓涓嶅悓鑼冨洿鐨勬暟鎹鍜屾枃浠訛紵
鍦∕ATLAB涓錛屽彲浠ヤ嬌鐢╜xlsread`鍑芥暟鏉ヨ誨彇Excel鏂囦歡涓鐨勬暟鎹銆傝ュ嚱鏁板彲浠ヨ誨彇鎸囧畾鑼冨洿鍐呯殑鏁版嵁錛屼篃鍙浠ヨ誨彇鏁翠釜Excel鏂囦歡銆備互涓嬫槸浣跨敤`xlsread`鍑芥暟璇誨彇Excel鏂囦歡涓涓嶅悓鑼冨洿鐨勬暟鎹鍜屾枃浠剁殑鏂規硶錛
1. 璇誨彇鏁翠釜Excel鏂囦歡
[num,txt,raw] = xlsread('filename.xlsx');
璇ヨ鍙ュ彲浠ヨ誨彇Excel鏂囦歡涓鐨勬墍鏈夋暟鎹錛屽苟灝嗘暟鎹瀛樺偍鍦╜num`鐭╅樀涓錛屽皢鏂囨湰鏁版嵁瀛樺偍鍦╜txt`鐭╅樀涓錛屽皢鍘熷嬫暟鎹瀛樺偍鍦╜raw`鐭╅樀涓銆
2. 璇誨彇鎸囧畾鑼冨洿鍐呯殑鏁版嵁
[num,txt,raw] = xlsread('filename.xlsx','Sheet1','A1:C10');
璇ヨ鍙ュ彲浠ヨ誨彇Excel鏂囦歡涓絎涓涓宸ヤ綔琛ㄤ腑錛孉1鍒癈10鍗曞厓鏍艱寖鍥村唴鐨勬暟鎹錛屽苟灝嗘暟鎹瀛樺偍鍦╜num`鐭╅樀涓錛屽皢鏂囨湰鏁版嵁瀛樺偍鍦╜txt`鐭╅樀涓錛屽皢鍘熷嬫暟鎹瀛樺偍鍦╜raw`鐭╅樀涓銆
3. 璇誨彇鎸囧畾宸ヤ綔琛ㄤ腑鐨勬暟鎹
[num,txt,raw] = xlsread('filename.xlsx','Sheet2');
璇ヨ鍙ュ彲浠ヨ誨彇Excel鏂囦歡涓絎浜屼釜宸ヤ綔琛ㄤ腑鐨勬墍鏈夋暟鎹錛屽苟灝嗘暟鎹瀛樺偍鍦╜num`鐭╅樀涓錛屽皢鏂囨湰鏁版嵁瀛樺偍鍦╜txt`鐭╅樀涓錛屽皢鍘熷嬫暟鎹瀛樺偍鍦╜raw`鐭╅樀涓銆
闇瑕佹敞鎰忕殑鏄錛宍xlsread`鍑芥暟鍙鑳借誨彇Excel鏂囦歡涓鐨勬暟鎹錛屼笉鑳借誨彇Excel鏂囦歡涓鐨勫浘琛ㄣ佸畯絳夊叾浠栧厓緔犮傚彟澶栵紝濡傛灉Excel鏂囦歡涓鐨勬暟鎹鏍煎紡涓嶄竴鑷達紝鍒欒誨彇鏁版嵁鏃跺彲鑳戒細鍑虹幇闂棰橈紝闇瑕佸仛濂芥暟鎹鏍煎紡鐨勭粺涓銆
⑵ matlab璇誨彇excel鏁版嵁騫跺勭悊
婕旂ず鏈哄瀷錛氬崕涓篗ateBook X緋葷粺鐗堟湰錛歸in7APP鐗堟湰錛歮atlab2020b&&excel2019 1銆佹壘鍒伴渶瑕佸勭悊鐨別xcel鏂囦歡錛屽弻鍑繪墦寮鐢佃剳涓婄殑鈥滆＄畻鏈衡濓紙鎴栬呮墦寮璧勬簮綆＄悊鍣╳indows e錛屾壘鍒拌佷嬌鐢ㄧ殑excel鏂囦歡錛夈
2銆佸皢鏂囦歡鐨勪綅緗澶嶅埗錛屽厛鎶婃枃浠跺悕澶嶅埗鍒頒綅緗鎼滅儲妗嗕腑錛岀劧鍚庡啀鎶婃暣涓浣嶇疆璺寰勫嶅埗濂姐
3銆佺幇鍦ㄦ垜浠鍙浠ユ墦寮matlab錛屽湪鎵撳紑matlab杞浠跺悗鐣岄潰錛屽彲浠ョ洿鎺ュ湪鍛戒護琛屾搷浣滐紝涔熷彲浠ユ柊寤轟竴涓鑴氭湰錛屾湰嬈′嬌鐢ㄥ懡浠よ屽嵆鍙銆
4銆佸湪澶勭悊鏁版嵁琛ㄦ牸鏃訛紝鎴戜滑涓鑸鏄鐢▁lsread鍑芥暟錛屽畠鐨勫叿浣撲嬌鐢ㄨ娉曟槸[num,txt,raw]=xlsread錛堜綅緗璺寰勶級銆
5銆佹渶鍚庨潰鎴戜滑鍙浠ュ疄鐜拌誨彇excel琛ㄦ牸鏁版嵁鐨勫姛鑳姐