ExcelAutoFitColumns

Sets the automatic sizing of all columns for Excel Workbook converted to TIFF.

Member of namespace

Convert

Syntax

bool ExcelAutoFitColumns (bool autoFitColumns)

Parameters

autoFitColumns: Type: bool

Parameters

autoFitColumns : A Boolean value that enables and disables the automatic sizing of columns in an Excel file.

True: The columns are set to automatically adjust the size based on the content.

False: The columns do not have their size adjusted.

Returns

Always True.

Level

Page level.

Details

This enables the auto sizing of columns to shrink or increase the size of the column to fit all of the data within the column. This action must be called before ExcelWorkbookToImage. If this action is not called, the setting that was saved in the original Excel file is used.

Example:

ExcelAutoFitColumns("False")
ExcelWorkbookToImage()