{"id":482,"date":"2015-10-30T12:24:34","date_gmt":"2015-10-30T03:24:34","guid":{"rendered":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/?p=482"},"modified":"2023-10-13T10:42:57","modified_gmt":"2023-10-13T01:42:57","slug":"matlabexcel%e3%82%92%e8%aa%ad%e3%81%bf%e8%be%bc%e3%82%93%e3%81%a7%e3%82%b0%e3%83%a9%e3%83%95%e3%83%97%e3%83%ad%e3%83%83%e3%83%88","status":"publish","type":"post","link":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/?p=482","title":{"rendered":"Matlab\u3067Excel\u3092\u8aad\u307f\u8fbc\u3093\u3067\u30b0\u30e9\u30d5\u30d7\u30ed\u30c3\u30c8"},"content":{"rendered":"<p>[:ja]<\/p>\n<p>m\u30d5\u30a1\u30a4\u30eb\u3068\u540c\u3058\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306bsample.xlsx\u304c\u3042\u308a\uff0c\u305d\u306eSheet1\u306e\u4e00\u90e8\u306b\u8aad\u307f\u8fbc\u307f\u305f\u3044\u30c7\u30fc\u30bf\u304c\u3042\u308b\u5834\u5408\uff0c\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u66f8\u3051\u3070\u3088\u3044\uff0e<\/p>\n<p><!--more--><\/p>\n<p>clear; %\u521d\u671f\u5316<br \/>\nrow_start=1; %\u8aad\u307f\u8fbc\u3080\u884c\u306e\u5148\u982d\u884c<br \/>\nrow_end=6; %\u8aad\u307f\u8fbc\u3080\u884c\u306e\u6700\u7d42\u884c<br \/>\ncolumn_start=1; %\u8aad\u307f\u8fbc\u3080\u5217\u306e\u5148\u982d\u5217<br \/>\ncolumn_end=2; %\u8aad\u307f\u8fbc\u3080\u5217\u306e\u6700\u7d42\u5217<br \/>\nA=zeros(row_end-row_start+1,column_end-column_start+1);%\u30e1\u30e2\u30ea\u4e8b\u524d\u5272\u5f53<br \/>\n[data]=xlsread(&#8216;sample.xlsx&#8217;,&#8217;Sheet1&#8242;); %data\u914d\u5217\u306b\u6307\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u6307\u5b9a\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3080<br \/>\nfor i=column_start:column_end<br \/>\nA(:,i)=data(row_start:row_end,i); %\u8aad\u307f\u8fbc\u307f\u30c7\u30fc\u30bf\u304b\u3089\u6240\u671b\u306e\u30bb\u30eb\u7bc4\u56f2\u3092\u5207\u308a\u51fa\u3059<br \/>\nend<br \/>\nplot(A(:,1),A(:,2),&#8217;k&#8217;); %\u9ed2\u306e\u5b9f\u7dda\u3067\u30e9\u30a4\u30f3\u30d7\u30ed\u30c3\u30c8<\/p>\n<p>[:en]m\u30d5\u30a1\u30a4\u30eb\u3068\u540c\u3058\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306bsample.xlsx\u304c\u3042\u308a\uff0c\u305d\u306eSheet1\u306e\u4e00\u90e8\u306b\u8aad\u307f\u8fbc\u307f\u305f\u3044\u30c7\u30fc\u30bf\u304c\u3042\u308b\u5834\u5408\uff0c\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u66f8\u3051\u3070\u3088\u3044\uff0e clear; %\u521d\u671f\u5316 row_start=1; %\u8aad\u307f\u8fbc\u3080\u884c\u306e\u5148\u982d\u884c row_end=6; %\u8aad\u307f\u8fbc\u3080\u884c\u306e\u6700\u7d42\u884c column_start=1; %\u8aad\u307f\u8fbc\u3080\u5217\u306e\u5148\u982d\u5217 column_end=2; %\u8aad\u307f\u8fbc\u3080\u5217\u306e\u6700\u7d42\u5217 A=zeros(row_end-row_start+1,column_end-column_start+1);%\u30e1\u30e2\u30ea\u4e8b\u524d\u5272\u5f53 [data]=xlsread(&#8216;sample.xlsx&#8217;,&#8217;Sheet1&#8242;); %data\u914d\u5217\u306b\u6307\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u6307\u5b9a\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3080 for i=column_start:column_end A(:,i)=data(row_start:row_end,i); %\u8aad\u307f\u8fbc\u307f\u30c7\u30fc\u30bf\u304b\u3089\u6240\u671b\u306e\u30bb\u30eb\u7bc4\u56f2\u3092\u5207\u308a\u51fa\u3059 end plot(A(:,1),A(:,2),&#8217;k&#8217;); %\u9ed2\u306e\u5b9f\u7dda\u3067\u30e9\u30a4\u30f3\u30d7\u30ed\u30c3\u30c8 [:]<\/p>\n","protected":false},"excerpt":{"rendered":"[:ja] m\u30d5\u30a1\u30a4\u30eb\u3068\u540c\u3058\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306bsample.xlsx\u304c\u3042\u308a\uff0c\u305d\u306eSheet1\u306e\u4e00\u90e8\u306b\u8aad\u307f\u8fbc\u307f\u305f\u3044\u30c7\u30fc\u30bf\u304c\u3042\u308b\u5834\u5408\uff0c\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u66f8\u3051\u3070\u3088\u3044\uff0e","protected":false},"author":1,"featured_media":1074,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32],"tags":[21],"_links":{"self":[{"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=\/wp\/v2\/posts\/482"}],"collection":[{"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=482"}],"version-history":[{"count":5,"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=\/wp\/v2\/posts\/482\/revisions"}],"predecessor-version":[{"id":3233,"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=\/wp\/v2\/posts\/482\/revisions\/3233"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=\/wp\/v2\/media\/1074"}],"wp:attachment":[{"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=482"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ams.eng.osaka-u.ac.jp\/user\/ishihara\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}