How do I read a range of elements in a given excel column into a new matlab array?
7 次查看(过去 30 天)
显示 更早的评论
I have an excel file that tabulates data in the same worksheet for different versions of a test. A column called INDEX specifies the serial number of the data set. For e.g., readings taken for inputs 25-0 first are with index 1, and the next set of readings from 25-0 for second test are indexed with 2 and so on, in every row that belongs to that data set. Now, how can I use these whole columns that also include blank spaces between two data sets, and store the data set - 1 i.e., values under columns with index 1 into one vector, with index 2 in the next and so on?
I also attach the excel file here under.
0 个评论
回答(3 个)
Roberto
2014-6-21
This file is not a excel file
CSV FILES files are plain text files, and like any file.txt can be viewed with a simple text editor (like notepad++) and when reading this file you can't read 'ranges' like in excel.
Solution:
In excel, click on menu 'Save as' and export your test11.csv file to test11.xlsx and then use xlsread function to properly read the excel file!.
0 个评论
Apdullah YAYIK
2014-6-21
Read with xlsread and save as .mat file.
Then you can make all process you like easily.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!