Reading data with Strcat and alternative

1 次查看（过去 30 天）
Francesco Milani
Francesco Milani 2020-4-25
回答： Walter Roberson 2020-4-25
variable = xlsread('data.xlsx','Sheet', strcat('B', i_cell, ':G', f_cell));
In the above example I undestand that I am reading a specific sheet of the excel file but I dont get what " strcat('B', i_cell, ':G', f_cell)); " actually does.
Is there another way of writing the above code in a more easy way, by using another function instead of strcat?
Thanks in advance!

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

采纳的回答

Walter Roberson
Walter Roberson 2020-4-25
range = sprintf('B%d:G%d', start_row, end_row); %where start_row and end_row are numeric
variable = xlsread('Data.xlsx', 'Sheet', range);
However it is confusing that you have something that looks like a range as a sheet name.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by