Re: st: Stata/Excel Estout Question

["Ben Jann" <ben.jann@gmail.com>]

Yes,

. estout using example.xls

will just write a text file with a .xls suffix. (The chosen filename
has no effect on how -estout-  formats the document.)

Note that you can specify

. esttab using esample.csv, plain

to write Excel style CSV format using -esttab-. The -plain- option
should be specified if the purpose is to do further calculations in
Excel. If you use a German version of Excel, you might want to specify

. esttab using esample.csv, plain scsv

For examples see http://repec.org/bocode/e/estout/esttab.html#esttab010.

Native XLS format is binary and cannot be written by -estout- or -esttab-.

ben

On 6/20/07, Johannes Geyer <JGeyer@diw.de> wrote:
> Dear Statalist,
>
> I have  a combined question concerning Stata and Excel:
>
> I want to use the following code
>
> estimates store ABC
> estout ABC using ${ESTOUT}ABC.xls, replace
>
> When I want to use the produced output in Excel for further calculations
> (pleaese, don't ask why I cannot use Stata to do further calculations
> which I would clearly prefer...) I am confronted with Excel saving my
> estimation results in some odd format - allthough the file has the ending
> .xls it does not seem to be a "real" Excel spreadsheet, e.g. the produced
> file ABC.xls has roughly 500KB whereas when I resave the file in Excel
> format it results in ABC.xls its size if 5MB. So, I think that the first
> format is some kind of text-file and the second is some Windows standard
> format for Excel. My question is: is there a direct way from estimation
> results in Stata to a "real" Excel-spreadsheet.
>
> Any help would be appreciated,
> best
>
> Johannes
>
> _______________
> Wichtiger Hinweis!
> Das DIW Berlin zieht um. Ab 1. Juli 2007 erreichen Sie uns unter einer
> neuen Adresse:
> DIW Berlin
> Mohrenstra�e 58
> 10117 Berlin
> ----------------------
> Johannes Geyer
> Deutsches Institut f�r Wirtschaftsforschung (DIW Berlin)
> German Institute for Economic Research
> Graduate Center
> Koenigin-Luise-Stra�e 5
> 14195 Berlin, Germany
> Tel: +49-30-89789-258
>
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/