Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Nick Cox <njcoxstata@gmail.com> |
| To | statalist@hsphsun2.harvard.edu |
| Subject | st: Re: st: Re: st: Export Excel – multiple worksheets |
| Date | Tue, 23 Oct 2012 09:33:49 +0100 |
Kathrin is clearly referring to the -export excel- command added in Stata 12. The help makes it explicit that you can specify variables you want exported and that there is a -sheet()- option, so nothing exotic seems needed here, and there is no need to install a user-written command. People on Stata < 12 can see http://www.stata.com/help.cgi?export_excel for what is concerned. Nick On Tue, Oct 23, 2012 at 9:22 AM, Muhammad Anees <anees@aneconomist.com> wrote: > Read -help xml_tab- whereby -xml_tab is a user written command by > Zurab Sajaia and Michael Lokshin and available from SSC - ssc install > xml_tab - which has an option ----sheet(name [, sh_opts])--- which > names a worksheet where the table is outputted. I hope this would be > of some help to your case. On Tue, Oct 23, 2012 at 1:07 PM, Kathrin Jacobs <jacobs.1@gmx.net> wrote: >> I want to use the export excel feature and I am unsure about the syntax. I would like to export variables into multiple Excel worksheets. >> >> In the end, GDP from 2000 to 2010 for certain industries should be in the first worksheet, employment from 2000 to 2010 for certain industries should be in the second worksheet, etc. >> >> My data looks like this in Stata: >> Industry GDP_2000 … GDP_2010 EMP_2000 … EMP_2010 >> a 1458 1589 5777 6458 >> b 1871 1751 2458 2587 >> c 1775 1879 3845 4148 >> >> I need the data look like this in Excel: >> Worksheet 1: >> Industry GDP_2000 … GDP_2010 >> a 1458 1589 >> b 1871 1751 >> c 1775 1879 >> >> Worksheet 2: >> Industry EMP_2000 … EMP_2010 >> a 5777 6458 >> b 2458 2587 >> c 3845 4148 >> * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/