Statalist


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

Re: st: reading in multiple worksheet excel data


From   "Joseph Coveney" <jcoveney@bigplanet.com>
To   "Statalist" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: reading in multiple worksheet excel data
Date   Mon, 7 Jul 2008 08:41:29 +0900

Michael Hanson wrote:

With all due respect to the suggested solutions, it seems to me that
the simplest would be to save your Excel file in XML format, then use
the -xmluse <filename>, doctype(excel) sheet( ) cells( )- command as
appropriate to your data.

    -- Mike

On Jul 3, 2008, at 2:19 PM, Murali Kuchibhotla wrote:

 Hello All,
           I often work with excel files comprising of multiple
worksheets. Is
there a simple way to read into Stata a single sheet from such a file
(something that mimics the insheet command for single sheet excel
files)?

Sincerely,
Murali Kuchibhotla
--------------------------------------------------------------------------------

Agreed.  If you're creating the Excel files, yourself, intending working up
the data in Stata, then XML is the way to go, given that Excel is your
considered choice.

I think that the suggestions assumed that Murali is receiving numerous Excel
files from others who didn't happen to (or won't reliably) save the files in
Excel 2002/2003's uncompressed XML format.  In order to help assure
reproducibility of the analyses and to maintain a data management trail,
it's best to avoid opening-and-saving-as-XML via point-and-click
manipulations from within Excel.

Joseph Coveney


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