//--- Get PreserveDataOnMergedCells
bool preserveData = importProps.PreserveDataOnMergedCells;
//--- Set PreserveDataOnMergedCells
importProps.PreserveDataOnMergedCells = false;
Code Block
vb.net
vb.net
title
vb.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.