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/
