This question is closed. Reopen it to edit or answer.
I need to read only data that remains in the excel table after filters have been set
1 view (last 30 days)
My excel file consists of a formatted table, with each column header giving the option to filter the rows by the data in that column. For example, in a temperature column values range from 0 to 100 Celsius. By clicking the filter I can select to only see rows at 50 degrees celsius. When I apply filters like this and save the file I want to use my gui to read the excel file like normal, but I want it to only read the rows that remain after the filter. When I tried this in matlab, it still reads all the rows in the file and seems to ignore the filter option. Is there a way to do this?