Stata PutExcel

-putexcel- manipulates Excel spreadsheets.

Contents

Usage

putexcel set foo.xlsx

putexcel A1 = "foobar"
putexcel B1 = `total'
putexcel B2 = formula(EXCEL_EXPR)

To insert a table, first it must be stored in a matrix.

tab foo bar, matcell(foobar)

Then try:

putexcel D1 = matrix(foobar), rownames

putexcel A1:A5, merge hcenter border(bottom, thick)

Graphs can be inserted.

graph export foo.png
putexcel C1 = image(foo.png)