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
Should I rename all the variables with the year immediately following the original variable names when I merge data across years with loopI run the following code: local i = 1998 while `i' < 2007{ local j=`i'+1 **step 10: match by …
Error Using the Command 'using'Hello everyone, I just downloaded data from PSID. Every time I run the do.file that comes with the …
Rescaling TimeHi Statlist, I have the following problem. I have a panel dataset of the form: Code: * Example gen…
Tokenize and looping through tokensHi Statlist, I have the following problem. I have defined 3 local variables defining the path to so…
Creating a variable with three condtionsI am using a data set of 50 countries which are separated into four regions. I want to create a vari…
Subscribe to:
Post Comments (Atom)
0 Response to Putexcel modfiy dont work as intended
Post a Comment