Concatenate strings and numbers
조회 수: 109 (최근 30일)
이전 댓글 표시
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
채택된 답변
DGM
2022년 3월 9일
편집: DGM
2022년 3월 9일
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!