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

From |
"Neil Shephard" <nshephard@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: RE: st: Appending several excel data sets into one |

Date |
Mon, 17 Sep 2007 15:50:16 +0100 |

On 9/17/07, Sergiy Radyakin <serjradyakin@gmail.com> wrote: > Here is a quote from Mr. Coveney > > "If workbooks contain multiple sheets, you would like to access the sheet > names. Excel doesn't provide this facility, but an add-in called > ASAP-utilities http://www.asap-utilities.com/ includes one to create an > index sheet listing all sheets in the workbook. " > Pedantic, but it was actually Allan Reese who you are quoting there (see http://www.stata.com/statalist/archive/2007-09/msg00508.html). > And this is exactly where my comment was pointed to (index sheet). > Otherwise I would have posted a VBA code that appends 200 sheets together. I would hazard that Micheal was pointing out that there is a solution which requires the user to learn only one language (i.e. Stata) as this is the package that analysis is to be performed in, as demonstrated by the code posted by Joseph Coveney (see http://www.stata.com/statalist/archive/2007-09/msg00510.html) Its useful that you have demonstrated that it is possible to achieve something in Excel with a relatively small number of lines rather than having to fork out for a third-party application (although I'm at a loss as to what the code you posted is for as there was no indication, and it didn't look like Stata code at all), but this would require that the original poster spent time learning Stata _and_ whatever language you posted in (which you are obviously already familiar and proficient in), which is clearly more time consuming than the ODBC solution that was provided. No doubt judicious programming of Excel does make reproducibility a mute point, but the crux is that this rarely happens. Excel is popular not because of how programmable it is via macros or Visual Basic, but because its a simple and intuitive point and click interface. This is itself the very downfall of the software. (Aside from the "black-box" of tricks that are hidden under the bonnet). For my own reference I have collated links to various expositions of problems associated with Excel at http://slack.ser.man.ac.uk/progs/stata/avoid_excel.html Regards Neil -- "In mathematics you don't understand things. You just get used to them." - Johann von Neumann Email - nshephard@gmail.com / n.shephard@sheffield.ac.uk Website - http://slack.ser.man.ac.uk/ Photos - http://www.flickr.com/photos/slackline/ * * 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/

**Follow-Ups**:**Re: RE: st: Appending several excel data sets into one***From:*"Sergiy Radyakin" <serjradyakin@gmail.com>

**References**:**Re: RE: st: Appending several excel data sets into one***From:*Joseph Coveney <jcoveney@bigplanet.com>

**Re: RE: st: Appending several excel data sets into one***From:*"Sergiy Radyakin" <serjradyakin@gmail.com>

**Re: RE: st: Appending several excel data sets into one***From:*"Michael Blasnik" <michael.blasnik@verizon.net>

**Re: RE: st: Appending several excel data sets into one***From:*"Sergiy Radyakin" <serjradyakin@gmail.com>

- Prev by Date:
**Re: RE: st: Appending several excel data sets into one** - Next by Date:
**st: Pitfall with ctset (survival)** - Previous by thread:
**Re: RE: st: Appending several excel data sets into one** - Next by thread:
**Re: RE: st: Appending several excel data sets into one** - Index(es):

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