write out colunm name

[hardmann]

Dear Tom:

When writing XLSX files, there are dates columns but no column names. How can I add it?

Code: Select all

open copy IP_Index.xlsx
copy(dates,format=xlsx,org=columns) 2011:01 2024:12 IP_index  IP_index_sa

Best Regard
Hardmann

[TomDoan]

Do you mean no label over the date column?

[hardmann]

Dear Tom:
Yes it is.



Best Regard
Hardmann

[TomDoan]

That was added with version 11.

[hardmann]

Dear Tom:

There is new problem.



Best Regard
Hardmann

[TomDoan]

That's a known bug that will be fixed soon. However, you can just use the DFORMAT option to set the format for the date column.

[hardmann]

Dear Tom:

Thanks, It works.

copy(dates,format=xlsx,org=columns,dformat="YYYY:PP")

Best Regard
Hardmann