Dear All,
I have the following issue. I wrote my own programme and I included putexcel to export some results in Excel. The part of the programme referring to putexcel is:
Apparently, when I run the programme I get the error message that the option merge is not allowed. If I remove it, Stata replies that the option border is not allowed and so on, until I am forced to remove all the options.
On the other hand, if I use the same lines outside the programme, they worked perfectly and I can customize my table. Hence my question is: Does putexcel behave differently if included in a programme? (If so, actually this would be quite strange in my view, but I do not have any other explanations).
Thanks
Dario
I have the following issue. I wrote my own programme and I included putexcel to export some results in Excel. The part of the programme referring to putexcel is:
Code:
putexcel set mytable.xlsx, sheet(Sheet1) replace putexcel (A1:D1)=("The Title"), merge border(bottom, double, black) hcenter vcenter bold putexcel A2=("Var 1") putexcel B2=("Var 2") putexcel C2=("Var 3") putexcel D2=("Var 4")
On the other hand, if I use the same lines outside the programme, they worked perfectly and I can customize my table. Hence my question is: Does putexcel behave differently if included in a programme? (If so, actually this would be quite strange in my view, but I do not have any other explanations).
Thanks
Dario
Comment