Test for letters on clipboard data
3 views (last 30 days)
Show older comments
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...
0 Comments
Answers (1)
Walter Roberson
on 23 Jan 2012
xlsread() can return 3 outputs, one numeric, one text, and the other "raw".
See Also
Categories
Find more on Environment and Settings in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!