OptionRange
- Last UpdatedNov 25, 2021
- 1 minute read
Reference to a range of cells that contains formatting options, which are applied to the query results. The option range must be nine contiguous cells with the following acceptable values:
|
Option |
Valid values |
|---|---|
|
Date Format |
Any valid Excel date format. For example: hh:mm:ss. |
|
Display Heading |
TRUE/FALSE |
|
Bold Heading |
TRUE/FALSE |
|
Italic Heading |
TRUE/FALSE |
|
Result Alignment |
right/left/center |
|
Number Format |
General/Fixed |
|
Decimal Places (only applied if the Number Format = Fixed) |
Integer value (0-10) |
|
Fit Results |
TRUE/FALSE |
|
Check tags exist |
TRUE/FALSE |
If a heading currently exists, and the Display Heading option is set to FALSE, the heading is not deleted. Also, none of the other heading options are applied.