[Telerik] SpreadSheet workSheet handling

- Add/Delete 

Add, Remove and Reorder Worksheets | Telerik Document Processing

 

-- Activate Sheet Tab

workbook.ActiveWorksheet = workbook.Worksheets[1];

 

 

//-- Tag처러

string shtName = grdVIEW.Workbook.Worksheets[Count].Name.ToString();

string shtTag = string.Empty;

if (shtName.ToString().Contains(".xls"))

{

string[] stringSeparators = new string[] { ".xls" };

string[] result = shtName.Split(stringSeparators, StringSplitOptions.None);

if (result.Length > 0) shtTag = string.Format("{0}.{1}", result[0].ToString(), "xls");

}

else if (shtName.ToString().Contains(".txt"))

{

string[] stringSeparators = new string[] { ".txt" };

string[] result = shtName.Split(stringSeparators, StringSplitOptions.None);

if (result.Length > 0) shtTag = string.Format("{0}.{1}", result[0].ToString(), "txt");

}

else shtTag = shtName.ToString();

 

 

//-- Date(날짜) 처리

CellSelection cellSelection = this.grdVIEW.Workbook.Worksheets[SheetIndex].Cells[Row, 3];

ICellValue value = cellSelection.GetValue().Value;

cellSelection.SetFormat(new CellValueFormat("yyyy/MM/dd"));

CellValueFormat format = cellSelection.GetFormat().Value;

CellValueFormatResult formatResult = format.GetFormatResult(value);

string result = formatResult.InfosText;

isDate = DateTime.TryParse(result.ToString(), out OrderDate);

 

-- sheet protection

Worksheet wsht = grdVIEW.Workbook.Worksheets[SheetIndex];

wsht.Protect(wsht.Name.ToString(), WorksheetProtectionOptions.Default); //시트 변경 보호

 

 

-- sheet align

grdVIEW.Workbook.Worksheets[SheetIndex].Columns[0].SetHorizontalAlignment(RadHorizontalAlignment.Left); //품명 좌측정렬

-- sheet 틀고정

RadWorksheetEditor worksheetEditor = grdVIEW.ActiveWorksheetEditor;

worksheetEditor.FreezePanes(new CellIndex(1, 1));

--행추가

int index = 2;

int itemCount = 3;

 

if (worksheet.Rows.CanInsert(index, itemCount))

{

RowSelection selection = worksheet.Rows[index, index + itemCount];

selection.Insert();

}

 

-- 행삭제

RowSelection selection = grdVIEW.Workbook.Worksheets[SheetIndex].Rows[Row, Row];

selection.Remove();

--정렬

grdVIEW.Workbook.Worksheets[SheetIndex].Columns[Col].SetHorizontalAlignment(RadHorizontalAlignment.Right);

grdVIEW.Workbook.Worksheets[SheetIndex].Columns[0].SetHorizontalAlignment(RadHorizontalAlignment.Left); //품명 좌측정렬

grdVIEW.Workbook.Worksheets[SheetIndex].Rows[0].SetHorizontalAlignment(RadHorizontalAlignment.Center);//해더 가로 중간 정렬

 

CellSelection cellSelection = grdVIEW.Workbook.Worksheets[Count].Cells[Row, 3];

cellSelection.SetHorizontalAlignment(RadHorizontalAlignment.Center);

 

grdVIEW.Workbook.Worksheets[SheetIndex].Rows[0].SetVerticalAlignment(RadVerticalAlignment.Center); //해더 세로 중간 정렬