| 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: When importing Is being imported into the following cells:  Image Modified
When If PreserveDataOnMergedCells is equal to true the result , each value will be assigned to a cell or group of merged cells. The result for the above example would be:  Image Modified
When If PreserveDataOnMergedCells is equal to false the result , 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 Modified
| 