Hi, I have written some code using tab2xl command and would like to know how to format the alignment of the text (row headings).
This is my code:
tab2xl var1 week using Output.xlsx, missing row(3) col(1) sheet ("var1output", replace)
putexcel set "Output.xlsx", sheet("var1output") modify
qui putexcel A1 = "Var1 by week"
The problem with this is that all the names of the rows are much longer than the size of the cell so I can only see the last couple of words but I want to see the whole row name.
Is there something missing for aligning or formatting the placement of the row headings?
My thoughts are whether there may be something I can use after the col(1)?
Many thanks!
This is my code:
tab2xl var1 week using Output.xlsx, missing row(3) col(1) sheet ("var1output", replace)
putexcel set "Output.xlsx", sheet("var1output") modify
qui putexcel A1 = "Var1 by week"
The problem with this is that all the names of the rows are much longer than the size of the cell so I can only see the last couple of words but I want to see the whole row name.
Is there something missing for aligning or formatting the placement of the row headings?
My thoughts are whether there may be something I can use after the col(1)?
Many thanks!
