Excel logger cwxtndxl.ini parameters

Hi there

There are a few parameters in the Pulse Excel Logger ini:

image

Apart from the obvious ones what are these parameters used for?

Thanks!

Hi @dfranken,

  • UPDATE_STAMP

  • ENABLE_SIMPLE_TM1_SHEET_CHECK

    • This is to enable/disable the check for a certain named range in determining whether an Excel sheet is a TM1 workbook
    • It simply checks for the Named Range: TM1REBUILDOPTION, if it is available on a worksheet
  • RECALCULATE_FIRST_SHEET

    • To trigger a sheet recalculation on the first worksheet
    • Some prefer to put settings on the first worksheet to determine the correct Admin Host / Environment, hence this setting
      • This also enables the Excel Logger to correctly grab the correct username in the worksheet, especially those workbook whose Excel environment is set to Manual calculation
      • For performance consideration in order to not trigger a full workbook calculation
  • DETECT_SHEET_RANGE_ROW / DETECT_SHEET_RANGE_COLUMN

    • The area of rows / columns used in checking the type of worksheet is

The diagnostics section is optional, and you can remove that from the INI file. The ENABLE_DEBUG is the parameter we would usually be asking to be set to true to enable extra logging of information for investigating/troubleshooting issues.

Cheers!

Paul