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.
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 |
CONFIG_SECTION |
CONFIG_KEY |
OBJECT_TYPE |
OBJECT_VALUE |
STRING_VALUE |
|---|---|---|---|---|
Common.Data.DataSetHelper |
ExcelVersion |
2010 |