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

1 次查看（过去 30 天）
Maria Lopez
Maria Lopez 2013-3-25
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.

请先登录，再回答此问题。

采纳的回答

Matt Kindig
Matt Kindig 2013-3-25
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.
  5 个评论
显示 3更早的评论
Walter Roberson
Walter Roberson 2013-3-25
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') );

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2013-3-25
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?
  1 个评论
Maria Lopez
Maria Lopez 2013-3-25
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)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by