12-1 Excel ���������������

¦b¥»³¹¤¤¡A§Ú­Ì±N¸g±`¨Ï¥Î test01.xls ¨Ó¶i¦æ½d¨Ò»¡©ú¡A¦¹Àɮצì©ó¥»®Ñªº½d¨Ò¥úºÐ¡AÂùÀ»¦¹Àɮ׹ϥܫá¡A¥i¶}±Ò¦¹ Excel ÀɮסAµe­±¦p¤U¡G

­º¥ý¡A§Ú­Ì¥i¥H¨Ï¥Î xlsfinfo «ü¥O¨ÓŪ¥X¤@­Ó Excel Àɮתº¬ÛÃö¸ê°T¤Î¸Ì­±ªº¤u§@ªí¡]Sheets¡^¦WºÙ¡A«ü¥O®æ¦¡¦p¤U¡G

[fileType, sheets] = xlsfinfo(xlsFile)

¨ä¤¤ xlsFile ¬O Excel ÀɮצWºÙ¡A©Ò¶Ç¦^ªºÅܼƦ³¨â­Ó¡A¨ä¤¤ fileType ¬OÀÉ®×Ãþ«¬¡A¦Ó sheets «h¥]§tªí³æ¦WºÙ¡A½d¨Ò¦p¤U¡G

Example 1: 12-»PExcel¸Õºâªíªº¾ã¦X/xlsfInfo01.mxlsFile='test01.xls'; [fileType, sheets] = xlsfinfo(xlsFile)fileType = Microsoft Excel Spreadsheet sheets = 'Sheet1' 'Sheet2' 'Sheet3' 'Position'

­Y­nŪ¥X¤u§@ªí¤º®e¡A¥i¥H¨Ï¥Î xlsread «ü¥O¡A½d¨Ò¦p¤U¡G

Example 2: 12-»PExcel¸Õºâªíªº¾ã¦X/xlsread01.mxlsFile = 'test01.xls'; [number, text, rawData] = xlsread(xlsFile)number = 1.0000 6.3000 2.3000 2.3000 7.0000 NaN 3.0000 8.3000 4.7000 4.7000 9.0000 NaN 5.0000 NaN 3.8000 text = '' 'C2' '' '' '' 'pi' 'yes' '' rawData = [ 1] [6.3000] [2.3000] [2.3000] [ 7] 'C2' [ 3] [8.3000] [4.7000] [4.7000] [ 9] 'pi' [ 5] 'yes' [3.8000]

¦b¤W­z½d¨Ò¤¤¡A¥Ñ©ó¨Ã¥¼«ü©w¤u§@ªí¦WºÙ¡A©Ò¥H xlsread ·|¥D°ÊŪ¤J²Ä¤@­Ó¤u§@ªíªº¸ê®Æ¡C¦¹¥~¡A¥Ñ©ó¤u§@ªí¤¤ªº¸ê®Æ¥i¥H¬O¼Æ­È©Î¦r¦ê¡A©Ò¥H xlsread ©Ò¶Ç¦^ªº¤T­ÓÅÜ¼Æ number, text, rawData¡A¤À§O¥Nªí¤u§@ªí¤¤ªº¼Æ­È¸ê®Æ¡B¦r¦ê¸ê®Æ¡B¥H¤Î©Ò¦³ªº¸ê®Æ¡C

¨Æ¹ê¤W xlsread ªº¥\¯à«Ü§¹¾ã¡A§Ú­Ì¤]¥i¥H¨Ï¥Î xlsread ¨ÓŪ¥X¬Y¤@­Ó¤u§@ªí¤¤ªº¤@³¡¥÷©Î¥þ³¡ªº¸ê®Æ¡A½d¨Ò¦p¤U¡G

Example 3: 12-»PExcel¸Õºâªíªº¾ã¦X/xlsread02.mxlsFile = 'test01.xls'; B = xlsread(xlsFile, 'Sheet2') % Ū¥X 'Sheet2' ªº¥þ³¡¸ê®Æ C = xlsread(xlsFile, 2, 'A2:B4') % Ū¥X²Ä¤G­Ó¸Õºâªí¦ì©ó A2:B4 ªº¸ê®ÆB = 26 22 42 41 87 32 24 53 C = 42 41 87 32 24 53

¦b¤W­z½d¨Ò¤¤¡A§Ú­Ì¥ý¨Ï¥Î xlsread ¨ÓŪ¥X ¡¥Sheet2¡¦ ¤u§@ªíªº¸ê®Æ¡AµM«á¦A«ü©w¥uŪ¥X¦ì©ó¬Y¤@­Ó¯S©w°Ï°ìªº¸ê®Æ¡A¦¹«ü©w°Ï°ì¬° A2:B4¡A¨ä¤¤ A:B ¥Nªí²Ä¤@©M¨ì¤Gª½¦æ¡A¦Ó 2:4 ¥Nªí²Ä¤G¨ì²Ä¥|¾î¦C¡C

¦b¤u§@ªí¤¤¡A§Ú­Ì¸g±`¨Ï¥Î²Ä¤@¦C¨ÓÀx¦sÄæ¦ì¸ê°T¡A¨ä¥L¦C¨Ó¦s©ñ¼Æ­È¸ê°T¡A¹ï©ó³o¤@Ãþ¯S©w®æ¦¡ªº¤u§@ªí¡Axlsread «ü¥O¯à°÷¦Û¦æ§PÂ_®æ¦¡¨Ãª½±µ§ì¥X¼Æ­È¸ê®Æ¤ÎÄæ¦ì¦r¦ê¡A½d¨Ò¦p¤U¡G

Example 4: 12-»PExcel¸Õºâªíªº¾ã¦X/xlsread03.mxlsFile = 'test01.xls'; [numericData, headerText] = xlsread(xlsFile, 'Position')numericData = 11 11 12 14 13 19 14 26 15 35 headerText = 'Time (sec)' 'Position (m)'

¦b¤W­z½d¨Ò¤¤¡AnumericData ¥]§t²Ä¤G¦C¥H«áªº¼Æ­È¸ê®Æ¡A¦Ó headerText «h¥]§t²Ä¤@¦CªºÄæ¦ì¦r¦ê¡C

Hint
xlsread ¤]¥i¥H¨Ï¥Î·Æ¹«¨Ó¿ï¨ú­nŪ¨úªº¤u§@ªí°Ï°ì¡A¹wª¾¸Ô±¡¡A¥i¿é¤J¡uhelp xlsread¡v¡C


MATLABµ{¦¡³]­p¡G¶i¶¥½g