def setUp(self): self.clear_cache() self.login_as(self.admin) from constance import config self.config = config self.new_users = [] self.excel_file = os.path.join(os.getcwd(), 'tests/seahub/views/sysadmin/batch_add_user.xlsx') data_list = [] data_list.append(['email', 'password', 'username', 'department', 'role', 'quota']) for i in xrange(20): username = "******" + str(i) +".com" password = "******" name = "name_test" + str(i) department = "department_test" + str(i) if i < 10: role = "guest" else: role = "default" quota = "999" data_list.append([username, password, name, department, role, quota]) self.new_users.append(username) wb = real_write_xls('test', data_list[0], data_list[1:]) wb.save(self.excel_file)
def write_xls(self, sheet_name, head, data_list): assert 'Role' in head return real_write_xls(sheet_name, head, data_list)