Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Exporting Stata output to MS Excel


From   Kit Baum <baum@bc.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: Exporting Stata output to MS Excel
Date   Fri, 13 Oct 2006 10:06:02 -0400

Roger said, in re the latest version of xml_tab,


Doesn't work for me either in Excel 2000. Checking MS website, it appears xml
support was introduced in Excel 2002 <http://support.microsoft.com/kb/ 288215/>

Zurab, i think you should add this to the "Requires" bit of the Description
on SSC and perhaps also the help file.



I have changed the package description on SSC. I have just installed MS Excel 2004 for Mac OS X (previously I had an older Excel) and the sequence of commands Dominic provides generate an XML file that MS Excel 2004 cannot read; it generates a "Strict Parse Error". Excel then offers to open the file as text. MS Excel 2004 knows how to deal with XML files, but claims that this one "is not a valid Excel XML spreadsheet".

Kit

Kit Baum, Boston College Economics
http://ideas.repec.org/e/pba1.html
An Introduction to Modern Econometrics Using Stata:
http://www.stata-press.com/books/imeus.html


*
* 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/




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