Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| 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/