04-29-2017 10:11 PM
When I trying to update .xlsx file woth libname excel engine,
libname mylib Excel 'C:\temp\aaaaaa.xlsx';
I am trying to Delete the table :
drop table mylib.'myData$'n;
But It will automaticaly recovery the deleted tables by the table end with a "$", also I can't delete the talbes with "$"
what to do??
04-29-2017 11:27 PM
Define FILENAME refering the excel file that need to be deleted, then
use FDELETE function to delete the file.
filename todel 'C:\temp\aaaaaa.xlsx';
rc = fdelete(todel);
Old $ files, try to delete by OS command.
04-30-2017 01:23 PM
04-30-2017 05:33 PM
Why do you have three different threads for the same topic?
If you cannot update your version of SAS to something more modern then perhaps you can instead ask Excel to remove the sheet for you.
You should also check your settings in Excel. Perhaps there is some setting in Excel that is causing the sheets to not be permanently deleted?
Did you try closing the workbook between when you delete the old sheet and when you try to add it back?
04-30-2017 06:00 PM - edited 04-30-2017 06:06 PM
Thank you Tom.
I create new topic because I just find new problem need to be focused.excuse me for the confuse.
At same time I tried to modify Excel.I can't find the solution so far and I am still keeping on trying.
I tried close them before modify them for sure. in each times.