Common.Data.DataSetHelper.ExcelVersion

<< Click to Display Table of Contents >>

 >Configuration > ST_CONFIG Entries > EarthSoft.Reports >

Common.Data.DataSetHelper.ExcelVersion

Choose the target version of Excel when exporting a DataSet output as Excel.

 

This setting is used to distinguish between 2003 and later versions (2003 is the .xls format and 2007+ is the .xlsx format). If you have the value set to 2003 when you export to Excel, the default file will be saved as .xls. If you have the value of 2007, 2010, 2013, etc., exporting to Excel will default to the .xlsx file type.

 

Excel_file_type

 

EQuIS Version: 6.0+

 

Namespace: EarthSoft.EDP

 

Products Affected:

Enterprise

Professional

 

Required Modules:

Professional

Enterprise

 

ST_CONFIG

VALUE

REMARK

VALID VALUES

CONFIG_SECTION

Common.Data.DataSetHelper

Required


CONFIG_KEY

ExcelVersion

Required


OBJECT_TYPE



null

OBJECT_VALUE



null

STRING_VALUE

<version>

Choose One

2003

2007

2010

2013

2016

 

Example

 

CONFIG_SECTION

CONFIG_KEY

OBJECT_TYPE

OBJECT_VALUE

STRING_VALUE

Common.Data.DataSetHelper

ExcelVersion



2010