Dear all,
I am writing to ask for a problem on the putexcel modify. I have an existing excel xls. file which is generated using a different data set. I was trying to use putexcel to add new data to this existing file. The code I use is:
putexcel set filename.xls, sheet("Sheet1") modify open
putexcel A1 = ("Table 7: Empirical Research")
However, the error message says "workbook filename.xls could not be loaded. r(603)"
I also used multiple ways to change directory using the code:
putexcel set "C:\A\B\filename.xls", sheet("Sheet1") modify open
putexcel A1 = ("Table 7: Empirical Research")
Now the error message changes to "could not write to file. r(691)"
With little information in the error message, I could not find the problem here.
Thank you so much in advance!
Best regards,
Scarlett Ling
Related Posts with Putexcel modify not working
three-digit SIC codesHallo, I have a variable name SIC (Standard Industry Classification Code), type (str4), SIC codes fr…
By group bar charts only displaying results for one type of observations within each groupHi all, I use Stata 16.1 and I'm trying to make bar charts for two different groups. The first gro…
Risk strata under x axis STCOMPETDear Statalists, I should add the risk strata (number of patients at risk) under risk axis followin…
How to run the regression if the frquency of a variable is higher than a specific number?Let say I have a dataset Code: SIC3 Freq. Percent Cum. …
Combine two time and date variables, and creating a yearly (readable) variableDear stata community I have a data-set that is combined from two different datasets, by append. I h…
Subscribe to:
Post Comments (Atom)
0 Response to Putexcel modify not working
Post a Comment