现有Excel文件emp.xlsx,部分数据如下:
EID | NAME | SURNAME | GENDER | STATE | BIRTHDAY | HIREDATE | DEPT | SALARY |
1 | Rebecca | Moore | F | California | 1974-11-20 | 2005-03-11 | R&D | 7000 |
2 | Ashley | Wilson | F | New York | 1980-07-19 | 2008-03-16 | Finance | 11000 |
3 | Rachel | Johnson | F | New Mexico | 1970-12-17 | 2010-12-01 | Sales | 9000 |
4 | Emily | Smith | F | Texas | 1985-03-07 | 2006-08-15 | HR | 7000 |
5 | Ashley | Smith | F | Texas | 1975-05-13 | 2004-07-30 | R&D | 16000 |
6 | Matthew | Johnson | M | California | 1984-07-07</ |