Width of columns in Excel-output

jimmyhartington · April 20, 2022, 12:56pm

Hi

Is there a way to set the width of columns in Excel-output to adjust to the length of the content?
I have made a cli command which automates a transform, but out always have too narrow columns.

Admin · April 20, 2022, 1:28pm

No. We don’t provide a way to change Excel basic formatting. I think it is unlikely that we are ever going to cover the presentation of the data in Excel (column width, font, bold, italic etc).

jimmyhartington · April 20, 2022, 2:00pm

OK.
I just noticed I can append to a file. So I should be able to make a standard file and make sure to append to it instead of overwriting. I will try this.

Admin · April 20, 2022, 2:45pm

I guess that could work.

I don’t know if there is any way to make it work with Excel templates.

jimmyhartington · April 20, 2022, 6:37pm

I do not use the Excel template format.
Just an .xlsx file with the header and a certain column width as the image below. Then the rows are appended to the file.
My cli setup copies the template file in place before the transformation.