Hi, I was wondering if there is any R way to open/close (forcibly) any file (preferably Excel) within Mac. I have tried with system() function, however it generates error saying ".. No such file or directory" since I have <<space>> in the underlying folder name. Can anyone here please help me with some workaround particularly on how to handle Space in file/folder name. Thanks for your time.
R code to open and close a file in Mac
4 messages · Christofer Bogaso, Simon Urbanek, Bob Rudis
On Nov 2, 2016, at 10:02 AM, Christofer Bogaso <bogaso.christofer at gmail.com> wrote: Hi, I was wondering if there is any R way to open/close (forcibly) any file (preferably Excel) within Mac. I have tried with system() function, however it generates error saying ".. No such file or directory" since I have <<space>> in the underlying folder name.
system(paste("open", shQuote(filename)),wait=FALSE)
Can anyone here please help me with some workaround particularly on how to handle Space in file/folder name. Thanks for your time.
_______________________________________________ R-SIG-Mac mailing list R-SIG-Mac at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-mac
Thanks, working perfectly. Any idea on forcibly closing that same file through R. Thanks again. On Wed, Nov 2, 2016 at 7:45 PM, Simon Urbanek
<simon.urbanek at r-project.org> wrote:
On Nov 2, 2016, at 10:02 AM, Christofer Bogaso <bogaso.christofer at gmail.com> wrote: Hi, I was wondering if there is any R way to open/close (forcibly) any file (preferably Excel) within Mac. I have tried with system() function, however it generates error saying ".. No such file or directory" since I have <<space>> in the underlying folder name.
system(paste("open", shQuote(filename)),wait=FALSE)
Can anyone here please help me with some workaround particularly on how to handle Space in file/folder name. Thanks for your time.
_______________________________________________ R-SIG-Mac mailing list R-SIG-Mac at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-mac
Issue an applescript event to Excel to tell it to close the file. You can do that from the system command, but it's really not R-related (it's more about how to issue apple events from the command line). On Wed, Nov 2, 2016 at 10:21 AM, Christofer Bogaso
<bogaso.christofer at gmail.com> wrote:
Thanks, working perfectly. Any idea on forcibly closing that same file through R. Thanks again. On Wed, Nov 2, 2016 at 7:45 PM, Simon Urbanek <simon.urbanek at r-project.org> wrote:
On Nov 2, 2016, at 10:02 AM, Christofer Bogaso <bogaso.christofer at gmail.com> wrote: Hi, I was wondering if there is any R way to open/close (forcibly) any file (preferably Excel) within Mac. I have tried with system() function, however it generates error saying ".. No such file or directory" since I have <<space>> in the underlying folder name.
system(paste("open", shQuote(filename)),wait=FALSE)
Can anyone here please help me with some workaround particularly on how to handle Space in file/folder name. Thanks for your time.
_______________________________________________ R-SIG-Mac mailing list R-SIG-Mac at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-mac
_______________________________________________ R-SIG-Mac mailing list R-SIG-Mac at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-mac