Stata 17 Table command - shading cells for .docx documents

[Alun Evans]

Hi,

I'm having a problem with the new stata 17 table command. I want to output tables to .docx where cells are coloured according to their values. My problem is that the shading only highlights the value and does not apply to the whole cell.

Does anyone have any ideas how I can get the whole cell to be shaded?

webuse auto7.dta, clear

table (headroom) (foreign), statistic(mean price)

 
 collect style cell foreign[1]#headroom[2.5], shading(background(aqua)) border(all)
 collect style cell foreign[0]#headroom[4.5], shading(background(lime)) border(all)

 collect export  "shading example.docx", replace

[Alun Evans]

Stata technical support came back with this which worked perfectly.

putdocx clear

webuse auto7.dta, clear

table (headroom) (foreign), statistic(mean price)

collect style cell foreign[1]#headroom[2.5], shading(background(aqua)) border(all)

collect style cell foreign[0]#headroom[4.5], shading(background(lime)) border(all)

putdocx begin

putdocx collect

putdocx table tbl1(6,3), shading(aqua)

putdocx table tbl1(10,2), shading(lime)

putdocx save example.docx, replace