How to import filtered excel sheet with readtable()?

I'm trying to read data into a Matlab table from Excel. There is an Excel sheet which has a filter on a column enabled. The readtable function, by default, reads only the filtered data (neglecting the rows that were filtered out).

Is there a way within the readtable() function call to import ALL rows within the spreadsheet (including the ones that have been filtered out in Excel)?

Thanks, NT

Answer 1

[Sravya Pulavarthi]

Hi Nikhil, you should be able to import all rows of the spreadsheet with readtable by default even though some have been filtered in Excel.

[AHMED FAKHRI]

Hi @Sravya Pulavarthi, thanks, what if I want readtable to exclude all and import the filtered only?