excel_compare/scripts/excel.py
def convert_excel_csv(filename):
    '''
    This function convert a xls or xlsx file into a multiple csv files in temp directory
    Return a list of csv files in the tmp directory
    '''
    excel = pd.ExcelFile(filename)
    sheets = excel.sheet_names
    files_location = f"/tmp/{filename}"
    os.mkdir(files_location)
    for sheet in sheets:
        sheet_content = pd.read_excel(excel, sheet)
        sheet_filename = f'/tmp/{filename}/{sheet}.csv'
        sheet_content.to_csv(sheet_filename, index = False, header = True)
    return files_location

    This function convert a xls or xlsx file into a multiple csv files in temp directory
    Return a list of csv files in the tmp directory
    
This function convert a xls or xlsx file into a multiple csv files in temp directory
Return a list of csv files in the tmp directory
This function convert a xls or xlsx file into a multiple csv files in temp directory Return a list of csv files in the tmp directory
def convert_excel_csv(filename):
    excel = pd.ExcelFile(filename)
    sheets = excel.sheet_names
    files_location = f"/tmp/{filename}"
    os.mkdir(files_location)
    for sheet in sheets:
        sheet_content = pd.read_excel(excel, sheet)
        sheet_filename = f'/tmp/{filename}/{sheet}.csv'
        sheet_content.to_csv(sheet_filename, index = False, header = True)
    return files_location
def convert_excel_csv ( filename ) : excel = pd . ExcelFile ( filename ) sheets = excel . sheet_names files_location = f"/tmp/{filename}" os . mkdir ( files_location ) for sheet in sheets : sheet_content = pd . read_excel ( excel , sheet ) sheet_filename = f'/tmp/{filename}/{sheet}.csv' sheet_content . to_csv ( sheet_filename , index = False , header = True ) return files_location
This function convert a xls or xlsx file into a multiple csv files in temp directory
Return a list of csv files in the tmp directory
This function convert a xls or xlsx file into a multiple csv files in temp directory Return a list of csv files in the tmp directory
'''
    This function convert a xls or xlsx file into a multiple csv files in temp directory
    Return a list of csv files in the tmp directory
    '''
filename