Concatenate strings and numbers
118 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I'm using the following code to try and create a "Range" for importing an excel spreadsheet into MATLAB. Instead of getting a single string, I am getting a 1x2 string for CoeffsRange. MaxRows is the number of rows in the Excel spreadsheet that contain data. Here's the code
String1=num2str(MaxRows)
CoeffsRange = ["H2:K" String1]
0 commentaires
Réponse acceptée
DGM
le 9 Mar 2022
Modifié(e) : DGM
le 9 Mar 2022
Strings and chars are different. Take care in how you combine them.
MaxRows = 10;
String1 = num2str(MaxRows) % a char vector
CoeffsRange = ["H2:K" String1] % [string char] -> string array
CoeffsRange = ['H2:K' String1] % [char char] -> char vector
CoeffsRange = "H2:K" + String1 % string + char -> string
CoeffsRange = strcat("H2:K",String1) % or use strcat()
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!