MATLAB Answers

How to import filtered excel sheet with readtable()?

6 views (last 30 days)
Nikhil Tawakley
Nikhil Tawakley on 10 Apr 2017
Answered: Sravya Pulavarthi on 12 Feb 2021
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

Answers (1)

Sravya Pulavarthi
Sravya Pulavarthi on 12 Feb 2021
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.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!