How to import an excel sheet into MATLAB

Question

Ramann Mantha 2013-3-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/66413-how-to-import-an-excel-sheet-into-matlab

Hi..I have an excel sheet consisting of say, 10 rows and 5 columns. Now, I need to read these values from the excel sheet, perform some mathematical operation on these values and then store the data in a new array. Please help me out with this.

Also, if there are 'n' such worksheets, I need to select few particular worksheets and then perform the operation on only these sheets and the remaining should remain intact.

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

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Ryan Livingston 2013-3-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/66413-how-to-import-an-excel-sheet-into-matlab#answer_77895

XLSREAD can do it programatically:

http://www.mathworks.com/help/matlab/ref/xlsread.html

and there are some GUI's which let you do it too:

http://www.mathworks.com/help/matlab/import_export/ways-to-import-spreadsheets.html

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

请先登录，再进行评论。

Answer 2

Ruben 2013-3-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/66413-how-to-import-an-excel-sheet-into-matlab#answer_77893

编辑：Ruben 2013-3-8

make sure the excel sheet you want to import from is in your current directory, then double click it (in the current folder section of your MATLAB window). You will receive options to import it.

Another way (which I prefer) is just copy paste. Right click in your workspace and select 'new'. You can then edit this variable in the variable editor and paste the required fields from your excel file.