Import multiple excel sheets with multiple columns each into variables
5 次查看(过去 30 天)
显示 更早的评论
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?
0 个评论
采纳的回答
Rishabh Rathore
2018-5-31
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 个评论
Stephen23
2018-5-31
编辑:Stephen23
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 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!