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?
Simple Binary Outcome QuestionHello, I am having a problem understanding a simple statement that I need to code in Stata. Define…
Measurement invariance MGCFA: correct approach and issue with identification of configural modelDear Statalist members, I have a question about measurement invariance testing for multigroup confi…
Collapsing data by both weighted and unweighted meansI have a dataset of ~100K, and I'd like to collapse the data for variable Alpha into its mean, and v…
Need help with creating first difference operator for regression - econometricsHi There Everyone. I hope you're all well. I had a question, I'm really lost - i need to create a f…
Need Help Appending a Column Using AsdocDear all, I am using Stata 16, on mac and have provided a sample of my dataset using dataex at the …
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