清空筛选条件
清空筛选条件

reading excel data, without knowing range

16 次查看（过去 30 天）
John
John 2011-12-16
评论： Walter Roberson 2020-5-4
Hi,
I have a line of code that reads in files from excel for a specific range. However, I don't know the last row of data in every file. Could somebody advise me on how to read in the data without knowing the number of the last row of data in advance.
May thanks
sch_cycle=xlsread('C:\Autonomie drive cycles\NEDC.xlsx','Sheet1','A2:B20');

请先登录，再回答此问题。

回答（2 个）

Ora Zyto
Ora Zyto 2011-12-16
John, Does reading from the entire worksheet satisfy your requirements?
B = xlsread('myExample.xls', 'MySheet')
Aldin
Aldin 2011-12-16
编辑：Walter Roberson 2020-5-4
[~,leng] = xlsread('NEDC.xls','Sheet1', 'A:A'); %column in array
l = length(leng); %length of column
length_string = num2str(l+1);
num = ['A',length_string]; % A1 or A2 or A3 it depends of length
xlswrite('NEDC.xls','Jhon','Sheet1',num);
That's my algorithm :)

类别

在 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