Common.Data.DataSetHelper.ExcelVersion

<< Click to Display Table of Contents >>

Navigation:  Configuration > ST_CONFIG Entries > EarthSoft.Reports >

Common.Data.DataSetHelper.ExcelVersion

Example

 

Choose the target version of Microsoft Excel when exporting a data grid 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 using 2003, when exporting to Excel, the default file will be saved as .xls. If using 2007 or higher, exporting to Excel will default to the .xlsx file type.

 

Excel_file_type

 

Note: Be aware of row and column count limitations for each file extension; exceeding the rows or columns supported will prevent the file from saving. The .xls file type supports up to 65536 rows and 256 columns, while the .xlsx file type supports 1048576 rows and 16384 columns.

 

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