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...

请先登录,再进行评论。

Community Treasure Hunt

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

Start Hunting!

Translated by