[C#/WINFORM/SPREAD] 시트 복사하기

■ 시트를 복사하는 방법을 보여준다.

▶ 예제 코드 (C#)


#region 시트 복사하기 - CopySheet(sourceSheetView, targetSheetName)

/// <summary>
/// 시트 복사하기
/// </summary>
/// <param name="sourceSheetView">소스 SheetView</param>
/// <param name="targetSheetName">타겟 시트명</param>
/// <returns>복사 SheetView</returns>
public FarPoint.Win.Spread.SheetView CopySheet(FarPoint.Win.Spread.SheetView sourceSheetView, string targetSheetName)
{
    FarPoint.Win.Spread.SheetView targetSheetView = null;

    if(sourceSheetView != null)
    {
        targetSheetView = FarPoint.Win.Serializer.LoadObjectXml
        (
            sourceSheetView.GetType(),
            FarPoint.Win.Serializer.GetObjectXml(sourceSheetView, targetSheetName),
            targetSheetName
        ) as FarPoint.Win.Spread.SheetView;
    }

    return targetSheetView;
}

#endregion

#region 시트 복사하기 - CopySheet(sourceSheetView, targetSheetName)

/// <summary>

/// 시트 복사하기

/// </summary>

/// <param name="sourceSheetView">소스 SheetView</param>

/// <param name="targetSheetName">타겟 시트명</param>

/// <returns>복사 SheetView</returns>

public FarPoint.Win.Spread.SheetView CopySheet(FarPoint.Win.Spread.SheetView sourceSheetView, string targetSheetName)

{

FarPoint.Win.Spread.SheetView targetSheetView = null;

if(sourceSheetView != null)

{

targetSheetView = FarPoint.Win.Serializer.LoadObjectXml

(

sourceSheetView.GetType(),

FarPoint.Win.Serializer.GetObjectXml(sourceSheetView, targetSheetName),

targetSheetName

) as FarPoint.Win.Spread.SheetView;

}

return targetSheetView;

}

#endregion