A new update to StataNow has just been released
28 January 2026
No comments
An update to StataNow is now available. You can update your copy of StataNow to access the latest features, including the following: Read more…
Archive
Posts Tagged ‘Word’
Export tabulation results to Excel—Update
7 June 2018
No comments
It’s summer time, which means we have interns working at StataCorp again. Our newest intern, Chris Hassell, was tasked with updating my community-contributed command tab2xl with most of the suggestions that blog readers left in the comments. Chris updated tab2xl and wrote tab2docx, which writes a tabulation table to a Word file using the putdocx command.
Read more…
Retaining an Excel cell’s format when using putexcel
4 February 2014
23 comments
In a previous blog entry, I talked about the new Stata 13 command putexcel and how we could use putexcel with a Stata command’s stored results to create tables in an Excel file.
After the entry was posted, a few users pointed out two features they wanted added to putexcel:
- Retain a cell’s format after writing numeric data to it.
- Allow putexcel to format a cell.
In Stata 13.1, we added the new option keepcellformat to putexcel. This option retains a cell’s format after writing numeric data to it. keepcellformat is useful for people who want to automate the updating of a report or paper. Read more…