//--- 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
Remarks
When PreserveDataOnMergedCells is set to true it will also affect column names when UseColumnNames is also set to true.