Hi,
Macro is one way to proceed, by doing much of the work in excel itself. If
this is not something you do often, then you can download and install ASAP
utilites which can do this (apart from 100s of other useful stuff) for you.
You can get it from
http://www.asap-utilities.com/download-asap-utilities-excel.php?file=1
Even if you go the macro way, this is a nifty utility to have.
Best
Rajesh
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wallace, John
Sent: 03 July 2008 20:27
To: [email protected]
Subject: st: RE: reading in multiple worksheet excel data
I would think the easiest thing to do would be to make an Excel macro
that pages through the sheets and exports the active one to a text file.
You could then switch to Stata and have a do-file read them in using
insheet.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Murali
Kuchibhotla
Sent: Thursday, July 03, 2008 11:19 AM
To: [email protected]
Subject: st: reading in multiple worksheet excel data
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/
------------------------------------------------------------
This transmission is intended for the sole use of the individual
and entity to whom it is addressed, and may contain information
that is privileged, confidential and exempt from disclosure under
applicable law. You are hereby notified that any use,
dissemination, distribution or duplication of this transmission by
someone other than the intended addressee or its designated agent
is strictly prohibited. If you have received this transmission in
error, please notify the sender immediately by reply to this
transmission and delete it from your computer.
*
* 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/
