Statalist


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

Re: st: reading in multiple worksheet excel data


From   Michael Hanson <mshanson@mac.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: reading in multiple worksheet excel data
Date   Sun, 06 Jul 2008 16:55:45 -0400

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


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



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