= Stata PutExcel =

The '''`putexcel`''' command is used for generating Excel Spreadsheets.

<<TableOfContents>>

----



== Usage ==

{{{
putexcel set foo.xlsx

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



=== Tables ===

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

{{{
tab foo bar, matcell(foobar)
}}}

Then try:

{{{
putexcel D1 = matrix(foobar), rownames
}}}



=== Styles ===

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

----



== External Content ==

External graphs can be inserted. 

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



----
CategoryRicottone