Page 1 of 1
Writing Series in an Excel File with COPY
Posted: Fri Dec 25, 2015 12:17 pm
by alexecon
I am using
Code: Select all
open copy test.xls
copy(dates,format=xls,org=columns)
but it crashes RATS every time. If I do it with the Wizard ("Export to") from the View Series window it works fine.
Is anything with my instruction obviously wrong?
Re: Writing Series in an Excel File with COPY
Posted: Fri Dec 25, 2015 12:34 pm
by TomDoan
Is there any possibility that it can't write to test.xls on the current default directory? The wizard forces you to select a usable file.
Re: Writing Series in an Excel File with COPY
Posted: Fri Dec 25, 2015 12:42 pm
by alexecon
Apparently not. I have tried different file names and locations but the problem persists.
Re: Writing Series in an Excel File with COPY
Posted: Sat Dec 26, 2015 3:35 pm
by TomDoan
I assume this is on the Mac? Leave the open copy off and see what happens when it prompts you file for the file name.
Re: Writing Series in an Excel File with COPY
Posted: Sun Dec 27, 2015 4:29 am
by alexecon
Yes, this is on a Mac with Yosemite. Leaving open copy out allowed me to write the file (even though it still crashes RATS on occasion).
Re: Writing Series in an Excel File with COPY
Posted: Sun Dec 27, 2015 11:57 am
by alexecon
alexecon wrote:Yes, this is on a Mac with Yosemite. Leaving open copy out allowed me to write the file (even though it still crashes RATS on occasion).
Update on this. COPY crashes RATS every time now with or without OPEN COPY preceding it. I tried saving at different folders, with different names, different types of data (e.g. xls, xlsx, rat) ensuring that all locations are writable (i.e. no files with the same name open, etc.)
Re: Writing Series in an Excel File with COPY
Posted: Mon Jan 04, 2016 12:36 pm
by alexecon
By the way, for anyone who may have experienced the same issues with COPY,
DEDIT does the job wonderfully. Something like