How to hide rows in an excel sheet through Matlab by text name?

Question

CD11 2020-11-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/665753-how-to-hide-rows-in-an-excel-sheet-through-matlab-by-text-name

回答： Vimal Rathod 2020-12-1

I am viewing an excel sheet through Matlab that has numeric data for various countries, with certain places (i.e. the US) having one row indicating total values for the entire country, and other rows with numeric data for each individual area (state, province, etc.) within the country. I am trying to sum up the values in this sheet for each location, so I only need to collect data on the total values for each country. If I need to call the rows by the country name and not the row positions (i.e. row 40-50) to hide them, how can I do that?

3 个评论
显示 1更早的评论隐藏 1更早的评论

jj rice 2020-11-28

Hi

CD11 2020-11-28

The file is very large so i'm not sure if I can paste it here, but basically the first column is "country," the second is "state" (if it has them), and all other 250+ columns have dates in the first row and values for virus cases in the other cells.

请先登录，再进行评论。

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