Introduced in build 8.5.1
Description
Sets or returns whether values should be preserved when importing into merged cells. The default value is true
.
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.