Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Re: How to save outputs to different sheets‏ in the same Excel file


From   nshephard <nshephard@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Re: How to save outputs to different sheets‏ in the same Excel file
Date   Tue, 27 Jul 2010 02:18:18 -0700 (PDT)

haiyan gao wrote:
> 
> Dear all,
>  
> Is it possible to save outputs to different sheets in the same Excel file
> in stata? For example, something like:
> outsheet v1 v2 using "M:ABC[sheet 1].xls", replace
> outsheet v2 v3 using "M:ABC[sheet 2].xls", replace
>  
> 

This _isn't_ writing Excel sheets.

-outsheet- writes Comma/tab (or user specified) delimited files that are in
a style that spreadsheets are capable of reading.

If you were to do...

outsheet v1 v2 using "M:ABC.xls", replace

...and then open the file "M:ABC.xls" in a text-processor (such as Emacs or
NotePad) you would be able to see/make sense of the data.  You wouldn't be
able to make a lot of sense of a true Excel spreadsheet in a text-editor.

I've little experience with Excel, but you might get some leverage out of
using -xmlsave- or some of the other tools returned by the search -findit
xml-

Neil

-- 
View this message in context: http://statalist.1588530.n2.nabble.com/How-to-save-outputs-to-different-sheets-in-the-same-Excel-file-tp5341389p5341405.html
Sent from the Statalist mailing list archive at Nabble.com.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index