Import multiple excel sheets with multiple columns each into variables
显示 更早的评论
Hey, I would like to import data from excel with multiple sheets. Every sheets has 2 columns and I would like to create a variable of every column in every sheet. How can I do this in Matlab?
采纳的回答
Rishabh Rathore
2018-5-31
1 个投票
You can use xlsread(xls_file,sheet_no) to read from particular sheet, refer documentation. It will return data in matrix form. Once you have that, use array indexing to extract individual columns ,Matrix(:,col) gives column 'col' of 'Matrix'.
Using xlsread, loop through all the sheets to get data from individual sheets.
2 个评论
Shana VdS
2018-5-31
"how can I create this loop and give every variable a name combined with the name of the sheet?"
Don't do that, unless you want to force yourself into writing slow, complex, buggy code that is hard to debug. Read this to know why dynamically accessing variable names is a bad way to write code:
Use indexing. Indexing is simple, neat, and very efficient. Indexing is what you should use. Store the sheet names and sheet data in cell arrays, and access them trivially using indexing.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
