| Code Block |
|---|
|
//--- Get PreserveDataOnMergedCells
bool preserveData = importProps.PreserveDataOnMergedCells;
//--- Set PreserveDataOnMergedCells
importProps.PreserveDataOnMergedCells = false;
|
| Code Block |
|---|
|
'--- 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: Is being imported into the following cells:  Image Added
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:  Image Added
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:  Image Added
| 