= Stata PutExcel =

'''`-putexcel-`''' manipulates [[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 [[Stata/Matrices|matrix]].

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

Then try:

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



=== Styles ===

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

----



== External Content ==

[[Stata/Graph|Graphs]] can be inserted. 

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

----



== See also ==

[[https://www.stata.com/manuals/rptputexcel.pdf|Stata manual for -putexcel-]]



----
CategoryRicottone