Stata: Output the results into Excel tables

Stata: Output the results into Excel tables

• Stata manual: putexcel, putexcel advanced
• Stata blogs: Chuck Huber (2017).Creating Excel tables with putexcel
• part 1: Introduction and formatting
• part 2: Macro, picture, matrix, and formula expressions
• part 3: Writing custom reports for arbitrary variables
• ASCII Codes
• Example: 
  cd c:\temp sysuse auto regress price mpg i.foreign margins foreign mat rtable=r(table)' putexcel set demo.xlsx,sheet(demo) replace local cell1=char(64+1)+string(1) local cell2=char(64+1)+string(5) putexcel `cell1'=matrix(rtable) /// `cell2'=matrix(rtable[1...,1],rtable[1...,5..6],rtable[1...,2]),names