|
⇤ ← Revision 1 as of 2023-06-07 20:44:01
Size: 709
Comment:
|
← Revision 2 as of 2025-10-24 17:32:23 ⇥
Size: 829
Comment: Rewrite
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| The '''`putexcel`''' command is used for generating Excel Spreadsheets. | '''`-putexcel-`''' manipulates [[Excel]] spreadsheets. |
| Line 25: | Line 25: |
| To insert a table, first it must be stored in a matrix. | To insert a table, first it must be stored in a [[Stata/Matrices|matrix]]. |
| Line 51: | Line 51: |
| External graphs can be inserted. | [[Stata/Graph|Graphs]] can be inserted. |
| Line 58: | Line 58: |
| ---- == See also == [[https://www.stata.com/manuals/rptputexcel.pdf|Stata manual for -putexcel-]] |
Stata PutExcel
-putexcel- manipulates Excel spreadsheets.
Contents
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
Graphs can be inserted.
graph export foo.png putexcel C1 = image(foo.png)