Sets or returns whether values should be preserved when importing into merged cells. The default value is true.

 public boolean PreserveDataOnMergedCells{ get; set; }

Public Property PreserveDataOnMergedCells() As Boolean


          //--- Get PreserveDataOnMergedCells
          bool preserveData = importProps.PreserveDataOnMergedCells;

          //--- Set PreserveDataOnMergedCells
          importProps.PreserveDataOnMergedCells = false;
        

          '--- Get PreserveDataOnMergedCells
          Dim preserveData As Boolean = importProps.PreserveDataOnMergedCells

          '--- Set PreserveDataOnMergedCells
          importProps.PreserveDataOnMergedCells = False

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:

When PreserveDataOnMergedCells is set to true it will also affect column names when UseColumnNames is also set to true.