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

6 次查看（过去 30 天）
SRIHARSHA SUSARLA
SRIHARSHA SUSARLA 2014-6-20
回答： Apdullah YAYIK 2014-6-21
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 Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by