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

[nshephard <nshephard@gmail.com>]

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/