python - 如何使其成为导出员工信息的功能?
问题描述
这是一个从员工管理系统中导入员工信息的功能。我想做一个类似的功能,可以导出员工信息。如何制作?
def import_employees():
with open('Employee_database.csv', 'r') as csvfile: #Opens the student answer file, and closes once finished
employee_reader = csv.reader(csvfile)
first_row = True
for row in employee_reader:
#Skip the first row with column names
if first_row:
first_row = False
continue
try:
fullName = row[0] + ' ' + row[1] #Creates full name for dictionary key
employeeList[fullName] = row
except IndexError:
pass
print('The following employees were imported:\n')
for employee in employeeList.keys():
print(employee)
print(' ')
input('<Press Enter to Continue>')
try:
import_employees()
except:
with open('Employee_database.csv', 'w') as employeeCSV:
employee_writer = csv.writer(employeeCSV)
csvrow1 = ['FirstName','LastName','SSN','Phone','Email','Salary']
employee_writer.writerow(csvrow1)
解决方案
推荐阅读
- android - 如何在android的默认材料日期选择器中获取开始日期和结束日期的日期对象?
- laravel - Schema 类如何从其他类访问方法
- forex - 画一条线的指标,看看我能赚多少点
- angular - Angular:chart.js 图表未显示
- react-native - 卸载时跟踪本机“IOS”或Android“应用程序
- types - ATS - 由“int”排序参数化的数据类型声明
- sql - 在 SQL Server 中使用动态表名定义游标
- php - 将多个 php 搜索结果输出到不同的页面?
- javascript - 使用 map 函数从二维数组中获取行和列索引
- javascript - 对单选按钮和多选应用验证