Python transformer to convert a bytes array containing EXCEL data into a Panda Object

excel_dataframe_transformer.py

import datetime
import os

from pandas import read_excel

def ExcelDataframeTransformer(excel_binary, tmp_path):
  print("Reading EXCEL")

  filename = datetime.datetime.now().strftime("%Y%m%d%H%M%S")
  print("Saving EXCEL into", tmp_path+'/'+filename+'.xls')

  with open(tmp_path+'/'+filename+'.xls', 'wb') as f:
      f.write(excel_binary)

  print("Parsing EXCEL", tmp_path+'/'+filename+'.xls')
  panda_object = read_excel(tmp_path+'/'+filename+'.xls')     
  
  print("Removing EXCEL", tmp_path+'/'+filename+'.xls')

  os.remove(tmp_path+'/'+filename+'.xls')

  return panda_object