Choose the target version of Microsoft 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.
EQuIS Version: 7+
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 |