Introduced in build 8.5.1
Description
Sets or returns whether values should be preserved when importing into merged cells. The default value istrue
.
C#
vb.net
Examples
C#
vb.net
Given the following data set:
1 | 2 | 3 | 4 | 5 |
6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 |
Is being imported into the following cells:
If PreserveDataOnMergedCells
is equal to true
, each value will be assigned to a cell or group of merged cells.
The result for the above example would be:
If PreserveDataOnMergedCells
is equal to false
, ImportData
will treat all cells as though they are unmerged. Any additional values that are imported into merged areas will be lost.
The result for the above example would be:
Remarks
WhenPreserveDataOnMergedCells
is set to true
it will also affect column names when UseColumnNames
is also set to true.