arr = ['users', 'account']

dest_filename = r'transformed.xlsx'

wb = xlsxwriter.Workbook(dest_filename)

with ExcelWriter(dest_filename) as ew:

        for arr1 in arr:

            wb.add_worksheet('sh_' + arr1)

            pandas.read_csv(arr1 + '.csv').to_excel(ew, index=FALSE, sheet_name='sh_sh_users' , encoding='utf-8' )

        wb.add_worksheet('Sheet').hide()