Converting Excel Data to Python List Permanently Without Reading Into The File

This is a way to quickly move data from an excel file to a python list without having to permanently save the excel file on your computer. It does not use pd.read or any other read function, but rather outlines a process for bringing over the data from excel to python. Excel Formula: =IF(MOD(ROW(E6)-ROW($E$6)+1,10),"",-100000) Extra Step Find and Replace Values Find: (\w+) Replace: '$1' 0:00 Instructions 0:10 Explanation of Issue 1:28 Solution 7:26 Extra Step For Text Data