How to convert string data from excel columns to a table of ascii characters in workspace
Show older comments
Hi there,
I'm trying to find out how to take specific columns in an excel spreadsheet and convert this data to ascii format in the workspace.
This is what I have so far:
[ndata,text,alldata] = xlsread('pGEX-4t-2-Cryw unique enzyme list','C1:E44');
%Takes the strings from rows C1:C44, D1:D44, and E1:E44 and assigns the string information to the variable 'text'
z=text(:,[1,3]);
%Takes just C and E column information (restriction enzyme and cut sites) and passes it to variable z
Now I'd like to take this table I have created and convert it to ascii format.
Any ideas?
Thanks!
Collin
1 Comment
Answers (0)
Categories
Find more on Spreadsheets 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!