MATLAB: Getting mouse coordinates with x and y attached to them and displaying them in excel.

mousexy

Hello, everybody

A have an issue, I am trying to display the xy coorsdinates of the mouse clicks to an excel sheet. The things is that I am only able to write the numbers but cannot attach x or y to the assigned cell.

here's the code:

[x,y]=ginput(50200)
sheet=1;
xlRange = 'A2';
xlswrite('coordinates.xls',x,sheet,xlRange);
ylRange = 'B2';
xlswrite('cncface.xls',y,sheet,ylRange);

So, my question is, how can i get the coordinates along with 'x' or 'y' attached to them? Displaying the coordinates several times.

Thank you.

Best Answer

Convert x and y to cell arrays with the desired leading text ('x' or 'y'):

xs = [ repmat('x', size(x)), num2str(x)];
ys = [ repmat('y', size(y)), num2str(y)];

Now call xlswrite with xs instead of x, and ys instead of y.

Related Solutions

MATLAB: How to write Data at once in an excel sheet (avoid formation of excel sheet in every loop!)

Change

Data{i} = {x(i),y(i)};

Data(i, :) = {x(i),y(i)};

That is, you need a 2d cell array not nested cells

MATLAB: How to write data to excel without overwrite data that already in the excel

To write in the empty rows, you have to specify that to xlswrite. So, either you know the row number beforehand and use that 'xlRange' to write the variable 'A'. Example:

filename = 'F:\FYP\Training.xls';
A = {person,A,B,EuclideanDistance,r};
sheet = 1;
empty_row = 10
xlRange = ['A',num2str(empty_row)];
xlswrite(filename,A,sheet,xlRange)

Or if you don't know the row number beforehand you can count the filled rows inside the file using xlsread. Example:

filename = 'F:\FYP\Training.xls';
A = {person,A,B,EuclideanDistance,r};
sheet = 1;
[~,~,ev] = xlsread(filename,sheet); % ev is cell array containing every filled row and column
empty_row = size(ev,1) + 1; 
xlRange = ['A',num2str(empty_row)];
xlswrite(filename,A,sheet,xlRange)

I hope it helps !

Best Answer

Related Solutions

MATLAB: How to write Data at once in an excel sheet (avoid formation of excel sheet in every loop!)

MATLAB: How to write data to excel without overwrite data that already in the excel

Related Question