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
event study - eventstudy2I am a postgraduate student writing my thesis. I am somewhat a novice in the field I have chosen to …
Geonear producing unstable resultsI'm trying to use geonear to identify the nearest neighbors within a dataset at the household-day le…
MisstableHello, Looking to do misstable summarize. I have a variable split into cases and controls. Then I h…
Age and GenderBonjour, First and foremost, I have to warn you that Im such a beginner on STATA & statistics o…
Generating mean returns, based on xtile returnsHi comminuty, I seem to have problems with calculating mean returns (ret_sup in my data). My datase…
Subscribe to:
Post Comments (Atom)
0 Response to Putexcel modfiy dont work as intended
Post a Comment