Putexcel modify don't work as intended
I have made a Gantt chart for project management where I want to import date variables from a Stata data file. My thought was to this with the put excel command in Stata, but it seems like the "Modify" option doesn't work?
My predefined Gantt chart is placed in my change directory and I have written the below code for testing the modify option:
putexcel set Gantt_diagram.xlsx, sheet("Sheet1") modify
putexcel A1 = "Test"
putexcel A2 = "Test2"
Stata seems to run the code fine, but there is no output in A1 or A2??
Isn't it possible to modify a predefined excel file that has not been created in Stata?
Kind regards
Frank
Related Posts with Putexcel modfiy dont work as intended
Declaring data to be time-series dataHi everyone! I have monthly data set presented as such Code: * Example generated by -dataex-. To…
Which test for between multiple groups and frequencies?Hi all, I am looking at frequencies (how many people said yes or no to a question) and would like t…
Multinomial logit models and vce(cluster) option. How to study the within group varianceDear stata users, I am utilizing a a cross sectional dataset and a multinomial logit model (MNL) to…
Creating quartiles using loop for 25 continuous independent variablesAny suggestion how to fix this loop ? I am trying to create quartiles for 25 continuous independent …
identify repeated observation within variable by idHi, I need to identify by id who has the same grade repeated multiple times. I have used [_n] and […
Subscribe to:
Post Comments (Atom)
0 Response to Putexcel modfiy dont work as intended
Post a Comment