Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Roberto Liebscher <roberto.liebscher@ku.de> |
| To | statalist@hsphsun2.harvard.edu |
| Subject | st: import excel Command: Automatic Adjustment of cellrange Option in Loop |
| Date | Fri, 21 Feb 2014 21:36:40 +0100 |
Hello Statalisters,I have got several excel files at hand which I would like to convert into *.dta files. I would like to write a loop importing all the excel files and save them as *.dta. However, the problem is that the cellrange is not the same for every file. So I would be happy to know if there is a way to "automate" the adjustment for the cellrange option?
In the end the loop should look like this:
forvalues i=1/100 {
import excel "C:\`i'.xlsx", cellrange(A3:XX) firstrow clear
save `i'.dta
}
where XX is supposed to be the last cell in the bottom right of the
worksheet that has a value in it. Is there any chance to do this?
Any help is highly appreciated. Best, Roberto -- Roberto Liebscher Catholic University of Eichstaett-Ingolstadt Department of Business Administration Chair of Banking and Finance Auf der Schanz 49 D-85049 Ingolstadt Germany Phone: (+49)-841-937-1929 FAX: (+49)-841-937-2883 E-mail: roberto.liebscher@ku-eichstaett.de Internet: http://www.ku.de/wwf/lfb/ * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/