Page 1 of 1
write out colunm name
Posted: Sun Apr 27, 2025 7:24 pm
by 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
Re: write out colunm name
Posted: Mon Apr 28, 2025 9:30 am
by TomDoan
Do you mean no label over the date column?
Re: write out colunm name
Posted: Mon Apr 28, 2025 7:37 pm
by hardmann
Dear Tom:
Yes it is.
Best Regard
Hardmann
Re: write out colunm name
Posted: Tue May 27, 2025 4:12 pm
by TomDoan
That was added with version 11.
Re: write out colunm name
Posted: Tue Jun 10, 2025 6:12 pm
by hardmann
Dear Tom:
There is new problem.
![Image]()
Best Regard
Hardmann
Re: write out colunm name
Posted: Tue Jun 10, 2025 9:29 pm
by 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.
Re: write out colunm name
Posted: Wed Jun 11, 2025 8:12 am
by hardmann
Dear Tom:
Thanks, It works.
copy(dates,format=xlsx,org=columns,dformat="YYYY:PP")
Best Regard
Hardmann