How do I input a variable into a string?

26 次查看（过去 30 天）
Jegor
Jegor 2024-11-11，16:03
编辑： Stephen23 2024-11-11，16:20
I am currently working on a project that takes weather data and crates a histogramm based on it. Data is structured in an Excel notebook with every month's data being in it's own sheet. The code below shows how the programm calls the data from the Excel sheet and builds the histogramm. However, i am having trouble with calling data from specific rows from the sheet. I need to change the x'es in 'Bx:Yx' to the lv variable from my code. What are the ways of doing that?
lv=get(h_list,'Value')+1 %date
mv=d(get(h_popup,'Value')) %month
Assimuudid=readmatrix("Andmed.xlsx","Sheet",(mv),'Range','Bx:Yx') %the data
theta=Assimuudid
radio_ryhm_callback %function that creates the histogramm

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2024-11-11，16:19
编辑：Stephen23 2024-11-11，16:20
Ran in:
lv = 3; % example value
"B"+lv+":Y"+lv
ans = "B3:Y3"
sprintf('B%u:Y%u',lv,lv)
ans = 'B3:Y3'

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by