protected static List <MergeRegion> GetMergeRegions(ISheet sheet)
{
var result = new List <MergeRegion>();
for (var i = 0; i < sheet.NumMergedRegions; i++)
{
var rgn = new MergeRegion();
rgn.NPOIRegion = sheet.GetMergedRegion(i);
var row = sheet.GetRow(rgn.NPOIRegion.FirstRow);
rgn.LeftTopCell = row.GetCell(rgn.NPOIRegion.FirstColumn);
result.Add(rgn);
}
return(result);
}
public void Setup()
{
var target = Engine.Object.Construct(Arguments.Empty);
Engine.Global.FastAddProperty("Excel", target, true, false, true);
Workbook.Setup(target);
Sheet.Setup(target);
SheetList.Setup(target);
Row.Setup(target);
RowList.Setup(target);
Cell.Setup(target);
CellList.Setup(target);
Comment.Setup(target);
Color.Setup(target);
Font.Setup(target);
MergeRegionList.Setup(target);
MergeRegion.Setup(target);
CellStyleList.Setup(target);
CellStyle.Setup(target);
}
