MATLAB Answers

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

4 views (last 30 days)
sana on 21 May 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.
[NUMERIC1,TXT1,RAW1]=xlsread('D:\Mphil CS\Semester 2\Machine Learning\Data\small data.xlsx');
%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 CommentsShowHide 1 older comment
sana on 22 May 2013
my bad i realized afterwards that i can take the transpose.:)

Sign in to comment.

### Accepted Answer

bym on 21 May 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 CommentShowHide None
sana on 22 May 2013
thank you !!!

Sign in to comment.

### Community Treasure Hunt

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

Start Hunting!