필터 지우기
필터 지우기

How do I read a range of elements in a given excel column into a new matlab array?

조회 수: 4 (최근 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.

답변 (3개)

Roberto
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!.

Image Analyst
Image Analyst 2014년 6월 21일
Use readtable():
t=readtable('C:\Users\Susarla\Documents\test11.csv')

Apdullah YAYIK
Apdullah YAYIK 2014년 6월 21일
Read with xlsread and save as .mat file.
Then you can make all process you like easily.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by