stata导入excel时显示error“ mandatory element missing”

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

用stata导入.xlsx格式文件时，出现这个窗口。excel文件是我自己录入的数据。
有没有人遇到过这个情况。。。

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Mandatory Element missing EXCEL Error element excel error

You could fix this by saving the excel-files that you want to upload as an Excel 97-2003 Workbook. This way, Stata did not run the error anymore.

réussite 发表于 2014-6-6 00:36
You could fix this by saving the excel-files that you want to upload as an Excel 97-2003 Workbook. T ...

OK, I will try it. Thank you very much.

réussite 发表于 2014-6-6 00:36
You could fix this by saving the excel-files that you want to upload as an Excel 97-2003 Workbook. T ...

为什么会不能直接读取呢 按理说stata可以识别xlsx文件啊

小木虫qwe 发表于 2016-5-16 22:47
为什么会不能直接读取呢 按理说stata可以识别xlsx文件啊

是xml 文件，或者与Office版本有关

réussite 发表于 2016-5-16 22:51
是xml 文件，或者与Office版本有关

我后来搞明白了 用stata12不能读取中文变量名

请问最后是怎么解决的

réussite 发表于 2014-6-6 00:36
You could fix this by saving the excel-files that you want to upload as an Excel 97-2003 Workbook. T ...

It works.Thank you very much! I also use the stata12.Maybe the software version is old.

réussite 发表于 2014-6-6 00:36
You could fix this by saving the excel-files that you want to upload as an Excel 97-2003 Workbook. T ...

thanks！

把文件格式另存为97-03XLs版本就可以了