求助：DDE 读 EXCEL file

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

My program:

options noxwait noxsync;
filename patients dde
"excel|D:\lvjinghui\project\pfizer\2010-04-26 A4061039\reference\[A4061039 target and actual graph.xls]1039 !$A$2:$F$68";
data _null_;
   infile patients;
   input;
   put _infile_;
run;
  
Error in log:

ERROR: DDE session not ready.
FATAL: Unrecoverable I/O error detected in the execution of the data step program.
       Aborted during the EXECUTION phase.

请问高手怎样解决这个问题呀？

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：EXCEL file exce xcel cel execution reference patients during excel

估计是你的excel文件没打开

怎么打开？
我用  
options noxwait noxsync;
x ' "D:\lvjinghui\project\pfizer\2010-04-26 A4061039\reference\[A4061039 target and actual graph.xls";
还是不行!

lvjinghui 发表于 2010-6-23 15:40
My program:

options noxwait noxsync;
filename patients dde
"excel|D:\lvjinghui\project\pfizer\2010-04-26 A4061039\reference\[A4061039 target and actual graph.xls]1039 !$A$2:$F$68";
data _null_;
   infile patients;
   input;
   put _infile_;
run;
  
Error in log:

ERROR: DDE session not ready.
FATAL: Unrecoverable I/O error detected in the execution of the data step program.
       Aborted during the EXECUTION phase.

请问高手怎样解决这个问题呀？

options noxwait noxsync;
%SYSEXEC  "D:\lvjinghui\project\pfizer\2010-04-26 A4061039\reference\A4061039 target and actual graph.xls";
filename patients dde
"EXCEL|D:\lvjinghui\project\pfizer\2010-04-26 A4061039\reference\[A4061039 target and actual graph.xls]1039 !R2C1:R68C6"
;
RUN;
/*1039 !$A$2:$F$68";*/
data _null_;
   infile patients;
   input;
   put _infile_;
run;

You may try above.
Note: I saw they identify the selection in worksheet by R*****C***:R*****C*** but not in your form $A... Honestly, I do not know if that is the reason.

要先用x命令运行Excel软件，再打开文件