Test for letters on clipboard data

2 次查看（过去 30 天）
Nuno
Nuno 2012-1-23
Hi all,
How can i test my clipboard data (column of numbers) for letters among numbers?
i tried isnumeric but since i'm copying from excel the class of data is double true but i'm only interested in numbers...
i'm writing a wizard to help user create a text file with columns of numbers copied from excel where user pastes one column at a time by selecting the column in excel and then presses a button to paste it in to the text file, but i want to prevent user from copying letters inside the column that might be unseen. i was thinking in some kind of routine that checks the clipboard data for any letters and then return a warning or error message saying that data is invalid...but i'm running out of ideas...

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

回答（1 个）

Walter Roberson
Walter Roberson 2012-1-23
xlsread() can return 3 outputs, one numeric, one text, and the other "raw".
  1 个评论
Nuno
Nuno 2012-1-23
I don't want to use xlsread() because user doesn't actually creates a excel file he uses excel to gather all columns of data and then copy and paste each one at a time to the wizard by selecting it on excel spreadsheet and clicking on import button on the wizard to paste the data in to the text file...

请先登录，再进行评论。

类别

在 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