用DDE间接实现的，要是不弹出Excel窗口就更好。


注：运行环境为 Office2003 + SAS 9.1.3

求币。

SAS 官网上有相似的问题可以参考
http://support.sas.com/kb/33/255.html

Problem Note 33255: Dashes mistranslated to underscores when using the IMPORT and EXPORT procedures in sheetnames
   

Dash characters are mistranslated to underscores when using the SHEET= option with the IMPORT and EXPORT procedure. In this example:

proc export data = sashelp.class
dbms = excel
file = "j:\mydata\testout.xls"
replace;
sheet = 'AE-MHX';
run;
The sheet created in EXCEL is named AE_MHX instead of AE-MHX.

The IMPORT procedure works in a similar way. In this example the IMPORT procedure will attempt to import a sheet with a dash character.

proc import file = "j:\mydata\testout.xls"
dbms = excel
out = test
replace;
sheet = 'AE-MHX';
run;
However the IMPORT procedure will actually look for AE_MHX as the sheetname.

To circumvent the problem, avoid dashes in your sheetname when creating the Excel file and rename the dash character to an underscore character when importing the file.

但是他没有回答问题啊，只是提出了问题

此题无解。

嗯，回去试试。