Info
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
2 views (last 30 days)
Show older comments
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?
1 Comment
Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!