Hello,
The case is that I have an Excel-file that have multiple sheets. The sheets have similar cells where there are values I am interested in analyzing. Thus, there is a generic order in which all numbers and values are in each sheet, eg: Each sheet in cell A1 have the value for numbers of graduated college students in the region - so, that the different sheets represent a different region.
How do I make a code in my do-file that reads through all sheets in my Excel data set, picks the value from cell A1 and adds them up?
I am just looking for the generic code that can be applied to different instances on Excel-files with multiple sheets where the order of content within each sheet is similar to each other.
I hope that someone can help me with this.
Best Regards, Andreas
Related Posts with How do I make a code in my do-file that reads through all sheets in my Excel data set, picks the value from (e.g.) cell A1 and adds them up?
changing several currencies over multiple years to EUROHey, I am using stata (for the first time) for my thesis. At the moment I have got a large database …
freduse errorWhen I use the freduse command I get the following error: . freduse gdp Java installation not f…
suest, mysuest, and multiple imputations...Hi all, First post here, but have been learning a lot from forum posts for a while. I'm using sues…
Inputting value of previous rowsHello, I am new to Stata and currently using Stata 15.1. I am working on a project involving firms a…
constructing a vector of variables in order to make panel estimationHello everyone I have a set of indicators that represent my control variables I would like to create…
Subscribe to:
Post Comments (Atom)
0 Response to How do I make a code in my do-file that reads through all sheets in my Excel data set, picks the value from (e.g.) cell A1 and adds them up?
Post a Comment