Want to import only certain range of data from an excel spreadsheet (.xlsm format as it has macros) into a pandas dataframe.
Was doing it this way:
data = pd.read_excel(filepath, header=0, skiprows=4, nrows= 20, parse_cols = "A:D")
But it seems that nrows works only with read_csv() ?
What would be the equivalent for read_excel()?