# Problem in reading data from Excel sheet and copying it in 2d array

4 visualizaciones (últimos 30 días)
sana el 21 de Mayo de 2013
AOA,
P = [ 138 6.31210089 6 0 0.2 0;
202 6.31210089 6 0 0.2 0;
264 6.31210089 6 0 0.2 0;]';
T =[1 2 3];
Here, the matrix has 3 columns, and 6 rows. But when i try to get the same data from excel file which is in 2d form, the first column above is considered as a row i.e. after getting data from excel my P matrix is 3 x 6 i.e. 6 columns and 3 rows. But i want the data matrix to be of 6 x 3.
Following is my code to read data from excel sheet and copying it to array P.
%copying data from the Numeric array to P
for i = 1: 1:1110
for j = 1: 1 : 61
P(i,j) = NUMERIC1 (i,j);
end
end
How to get data in that form, and i can't take transpose.
##### 2 comentariosMostrar NingunoOcultar Ninguno
bym el 21 de Mayo de 2013
why can't you take the transpose?
sana el 22 de Mayo de 2013
my bad i realized afterwards that i can take the transpose.:)

Iniciar sesión para comentar.

bym el 21 de Mayo de 2013
reverse i & j ?
%copying data from the Numeric array to P
for i = 1: 1:1110
for j = 1: 1 : 61
P(i,j) = NUMERIC1 (j,i); % reversed i & j
end
end
##### 1 comentarioMostrar -1 comentarios más antiguosOcultar -1 comentarios más antiguos
sana el 22 de Mayo de 2013
thank you !!!

Iniciar sesión para comentar.

### Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

### Community Treasure Hunt

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

Start Hunting!

Translated by