/// <summary> /// Метод получающий информацию об заданной ячейке /// </summary> /// <param name="CellAddr">Адрес ячейки(пока без проверки на рэндж)</param> /// <returns></returns> public static CellInfo GetCellInfo(string CellAddr) { CellInfo res = new CellInfo(); if (workSheet != null) { res.Row = workSheet.Range[CellAddr].Row; res.Column = workSheet.Range[CellAddr].Column; res.ColumnWidth = workSheet.Range[CellAddr].Width; res.RowHeight = workSheet.Range[CellAddr].Height; res.Interior = workSheet.Range[CellAddr].Interior; res.Font = workSheet.Range[CellAddr].Font; res.HorizontalAlignment = workSheet.Range[CellAddr].HorizontalAlignment; res.VerticalAlignment = workSheet.Range[CellAddr].VerticalAlignment; } return res; }
/// <summary> /// Метод устанавливающий настройку ячейки /// </summary> /// <param name="cell"></param> public static void SetCellDecor(CellInfo cell) { if (workSheet != null) { //--Font settings workSheet.Cells[cell.Row, cell.Column].Font.Name = cell.Font.Name; workSheet.Cells[cell.Row, cell.Column].Font.Size = cell.Font.Size; workSheet.Cells[cell.Row, cell.Column].Font.Bold = cell.Font.Bold; workSheet.Cells[cell.Row, cell.Column].Font.Italic = cell.Font.Italic; workSheet.Cells[cell.Row, cell.Column].Font.Underline = cell.Font.Underline; workSheet.Cells[cell.Row, cell.Column].Font.Background = cell.Font.Background; workSheet.Cells[cell.Row, cell.Column].Font.Color = cell.Font.Color; workSheet.Cells[cell.Row, cell.Column].Font.ColorIndex = cell.Font.ColorIndex; workSheet.Cells[cell.Row, cell.Column].Font.FontStyle = cell.Font.FontStyle; workSheet.Cells[cell.Row, cell.Column].Font.Strikethrough = cell.Font.Strikethrough; workSheet.Cells[cell.Row, cell.Column].Font.ThemeFont = cell.Font.ThemeFont; workSheet.Cells[cell.Row, cell.Column].Font.TintAndShade = cell.Font.TintAndShade; //--Interior settings workSheet.Cells[cell.Row, cell.Column].Interior.Color = cell.Interior.Color; workSheet.Cells[cell.Row, cell.Column].Interior.ColorIndex = cell.Interior.ColorIndex; workSheet.Cells[cell.Row, cell.Column].Interior.Pattern = cell.Interior.Pattern; workSheet.Cells[cell.Row, cell.Column].Interior.PatternColor = cell.Interior.PatternColor; workSheet.Cells[cell.Row, cell.Column].Interior.PatternColorIndex = cell.Interior.PatternColorIndex; workSheet.Cells[cell.Row, cell.Column].Interior.PatternTintAndShade = cell.Interior.PatternTintAndShade; workSheet.Cells[cell.Row, cell.Column].HorizontalAlignment = cell.HorizontalAlignment; workSheet.Cells[cell.Row, cell.Column].VerticalAlignment = cell.VerticalAlignment; } }