Home › Discussions › Questions & Answers › Auto-Sizing Columns in Excel Output

Auto-Sizing Columns in Excel Output

Avatar photoCustomer Questions & Answers 5 replies

I need to ensure the column width in the Excel output accommodates the header names but is not overly wide. How can I control how the column width is determined?

5 replies

  • Support Enginatics

    You use the profile option ‘Blitz Report XLSX Column Width Mode’. This defines if the column width in Blitz Reports XLSX output files gets aligned to the column headers, the data, or both.

  • Avatar photoCustomer

    What is the default mode used for column width calculation?

  • Support Enginatics

    The default mode is ‘both’.

  • Avatar photoCustomer

    Is there a way to adjust the calculated width globally?

  • Support Enginatics

    Yes, you can use the profile option ‘Blitz Report XLSX Column Width Scale Percentage’ to adjust the width scale.

  • You must be logged in to reply to this post.