这几天弄了一个项目需要做excel导入功能, 导入的时候发现excel的时间字段存储的好像不是unix时间戳。
Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
就是excel设1900年1月1日序号为1,存储的为设置时间于1900/1/1相隔多少天