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

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.

Answer 1

[Matt Kindig]

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.

[Maria Lopez]

Didnt work, thanks though. It was displaying xy (wich is good,) within a matrix, but not displaying the actual coordinates.

[Walter Roberson]

Try xlswrite() of cellstr(xs)

Are you wanting an "x" before each x coordinate? Or only "x" as a header?

As you are writing to an existing xls file, is there an existing column format in place?

[Maria Lopez]

This what i want: x15.66 y3.66. Yes, an x before each coordinate. There is an existing file. No format, just writing directly from matlab.

[Walter Roberson]

Did you try the cellstr() variation? Another way of coding it would be

xs = cellstr( num2str(x, 'x%.2f') );   %two decimal places
ys = cellstr( num2str(y, 'y%.2f') );

[Maria Lopez]

Yup, It worked, Thank you, man! I Love You!!!! Have a nice day ahead!

Answer 2

[Walter Roberson]

towrite = {'x'; num2cell(x(:))};
xlrange = 'A1';  %note modification of range
xlswrite('coordinates.xls', towwrite, sheet, xlRange);

towrite = {'y'; num2cell(y(:))};
ylrange = 'B1';  %note modification of range
xlswrite('cncface.xls', towrite, sheet, ylRange);

Is it correct that you are wanting to write them to different files?

[Maria Lopez]

Didnt work, It only writes x and y to A1 and B1. The coordinates ar not shown, but thank you. (Typo, they both go to the same file: cncface.xls)