can anybody help me with matlab coding+excel??

I have got many files lets say 30 files ,in each file there are 3 columns of data but the no: of rows varies for each file .for eg 1 file has got 6 rows and 3 columns then next file has 3 rows and 3 columns etc .i was not able to append it since its size varies.i need 2 write all these data in an excel sheet also . pls help me??

Answer 1

[David Sanchez]

N_files = 30;
for k = 1:N_files
  file_name = strcat('name',num2str(k));
  file_name = strcat(file_name,'.xls');
  data{k} = readxls(file_name);
end

You will end up with a cell array, whose cells content may be of different size. Later, you can handle this data as you please, even write it all to a single xls file

[Sony]

sorry i dint understand wat u said

Answer 2

[Image Analyst]

Can you use csvread() or dlmread() plus the FAQ to read each file into a matrix? Append all the individual matrices together into one big matrix. You can append them vertically as long as they all have 3 columns.

allData = [];
for k = 1 : number of files
  % Make sure you change filename at each iteration.
  fullFilename = fullfile(folder, files{k}.name);
  dataFromOneFile = csvread(fullFilename ); 
  allData = [allData; dataFromOneFile];
end

Then send that matrix out to Excel using xlswrite().