Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Example
Code Block
csharp
csharp
titleC#

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

          //--- Set PreserveDataOnMergedCells
          importProps.PreserveDataOnMergedCells = false;
        
Code Block
vb.net
vb.net
titlevb.net

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

          '--- Set PreserveDataOnMergedCells
          importProps.PreserveDataOnMergedCells = False
        
Web only
To see what this looks like, go to our online documentation:
To see what this looks like, go to our online documentation:

Given the following data set:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

When importing into the following cells:

Image Added

When PreserveDataOnMergedCells is equal to true the result would be:

Image Added

When PreserveDataOnMergedCells is equal to false the result would be:

Image Added

Remarks

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