I'm working with some xlsx files and need to import them into program. I've written a script that handles everything I need it to do.

However, I need to apply filters to the table in excel before importing them in.

When I apply filters and prep the table to import into python, python reads the entire table ignoring all the filters.

My work around has been filtering what I need then copying that to a new sheet. Then when reading into excel I specify the new sheet of filtered data that I'm looking for.

Is there a way to read the filtered table into excel directly?

Or Should I just import the entire table and apply those same filters using pandas in my script instead?

CodePudding user response：

IIUC, you can't read only visible rows and/or columns of an Excel spreadsheet with