adjust column width in Excel - putexcel

[boriskaiser]

Hello everyone,

I would like to increase the column width in Excel when exporting results via "putexcel". I haven't found this in the options.

A little piece of code:

sysuse auto, clear

rename foreign foreign_has_a_long_name

reg price mpg weight foreign_has_a_long_name
mat res = r(table)'
mat res = res[1...,1..4]
matlist res

putexcel set testfile.xlsx, sheet("T1") replace
putexcel A1=matrix(res), names

Any help would be appreciated - many thanks in advance!

Boris

[Roger Chu]

Hello Boris,

I'm not an expert at putexcel, but as you've noted, I'm not sure if you can change the column with in Excel using putexcel.

If you're comfortable with or willing to learn Mata, I believe you should be able to change the column width using Mata's xl() class.

Search

help [M-5] xl()

for more information.

Best,
Roger

[boriskaiser]

Hi Roger,

Thanks for the pointer.
You're right: xl() can be used to adjust the column width.

[Demetrio Guzzardi]

Hello,

does anyone actually managed to adjust the column width trough putexcel?

An help would be greatly appreciated.
Demetrio

[Long Hong]

Hi, my sense is that you could use a different format of the values in the matrix to change the width of the excel. For example, %9.2f is wider than %6.2f. I hope it could help.

[Demetrio Guzzardi]

Hi, my sense is that you could use a different format of the values in the matrix to change the width of the excel. For example, %9.2f is wider than %6.2f. I hope it could help.

Unfortunately in this way you are only changhing the width of the stata viewer but once I export in excel the columns will keep the default excel width.

Any other suggestion?

[Mathieu Lussier]

Hello,

does anyone actually managed to adjust the column width trough putexcel?

An help would be greatly appreciated.
Demetrio

Hi Demetrio,

I can't see either how you can change the width in Excel from stata. I'm pretty sure it's impossible for now. However, I think that merging cells will do the job.

[Ibrahim Bicak]

I had the same issue. Mata is the solution. Here is the example that I found useful.

https://opensdp.github.io/human-capi...at_excel_cells