Re: st: reading in multiple worksheet excel data

[Michael Hanson <mshanson@mac.com>]

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/