how can I make a matrix from each row of an excel sheet data and save each matrix in to a folder

Iam working with a spreadsheet data that is being imported to matlab using xlsread function. Is there any way to access each row from that excelsheet and make each row a seperate matrix and store them in a seperate structure or an array to use it later? And after storing each matrix in to that structure ,how can I access some of the matrices later

Answer 1

[Jan]

data = xlsread(FileName);

Now data contains the numerical values of all columns. Now you want to save them as matrices in different folders. It is not clear, what this exactly means, but perhaps this helps:

for k = 1:size(data, 2)
  folder = fullfile('D:\Data\', sprintf('Folder%03d', k));
  Column = data(:, k);
  save(fullfile(folder, 'column.mat'), 'Column');
end

Now each folder contains the file Column.mat, in which one column of the Excel file is saved. This does not sound efficient, because it duplicates the data. But maybe there is a good reason to do so.

[sruthy shankar]

sir, actually i have to extract each row from that excel sheet and make it into a square matrix by padding zeros,then i wish to store those rows in an array.Because iam working on neural nets,these excel sheets are my feature data set,so I have to split them in two,one for training and the other one for testing. So the array will contain those features.This is what i wish to do

[Jan]

@sruthy: Okay. How can we help you? Do you know how to pad the vectors to be square matrices? In which format do you want to save these matrices? Which rows do you want to store in which kind of array?

[sruthy shankar]

sir,I have used the following code to make each row a square matrix. data_M = xlsread('Book1' ); M_matrix=[]; for k = 1:size(data_M, 1 ) row_M = data_M(k, : ); padding = zeros(1,6); vec_M=[row_M,padding]; rowMatrix_M = vec2mat(vec_M,6); M_matrix=[M_matrix rowMatrix_M]; end here M_matrix is that array,but I have to split that array in to two,each containing equal number of matrices so that i can give it for training as well as testing, how can it be done ? or instead of this array is there exist some other method to store that matrices and later access them