How do I read a range of elements in a given excel column into a new matlab array?
7 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (3)
Roberto
el 21 de Jun. de 2014
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 comentarios
Image Analyst
el 21 de Jun. de 2014
Use readtable():
t=readtable('C:\Users\Susarla\Documents\test11.csv')
0 comentarios
Apdullah YAYIK
el 21 de Jun. de 2014
Read with xlsread and save as .mat file.
Then you can make all process you like easily.
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!