첨부 실행 코드는 나눔고딕코딩 폰트를 사용합니다.
728x90
반응형
728x170
fpSpread1.Sheets[0].RowCount              = 10;
fpSpread1.Sheets[0].ColumnCount           = 15;
fpSpread1.Sheets[0].ColumnFooter.Visible  = true;
fpSpread1.Sheets[0].ColumnFooter.RowCount = 1;

// 값
for(int rowIndex = 0; rowIndex < fpSpread1.Sheets[0].RowCount; rowIndex++)
{
    for(int columnIndex = 0; columnIndex < fpSpread1.Sheets[0].ColumnCount; columnIndex++)
    {
        fpSpread1.Sheets[0].Models.Data.SetValue(rowIndex, columnIndex, columnIndex + rowIndex * fpSpread1.Sheets[0].ColumnCount);
    }
}

fpSpread1.Sheets[0].ColumnFooter.Cells[0, 0].Value = "합계";

fpSpread1.Sheets[0].ColumnFooter.SetAggregationType(0, 1, FarPoint.Win.Spread.Model.AggregationType.Sum);
728x90
반응형
그리드형(광고전용)
Posted by icodebroker

댓글을 달아 주세요