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

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?

[M.Many]

It would be nice to give the dataset with the first rows

[jj rice]

Hi

[CD11]

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.

Answer 1

[Vimal Rathod]

Hi,

It is difficult to use those commands from MATLAB alone. You would need to use ActiveX to use all commands of Excel VBA.

Refer to the following links to know more about it.

https://se.mathworks.com/matlabcentral/answers/411253-how-can-i-write-data-into-excel-sheet-and-hide-other-unused-rows-and-columns-in-a-sheet

To know more about how to use ActiveX server commands refer the following link.

https://se.mathworks.com/help/matlab/using-com-objects-in-matlab.html?s_tid=CRUX_lftnav