/// <summary> /// Занесение данных в ячейку /// </summary> /// <param name="text"></param> /// <param name="row"></param> /// <param name="column"></param> /// <param name="width"></param> /// <param name="height"></param> /// <param name="borderWeight"></param> /// <param name="borderStyle"></param> public void Print(object text, int row, int column, int width = 1, int height = 1, int borderWeight = 0, Microsoft.Office.Interop.Excel.XlLineStyle borderStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous, Color?color = null) { if (width < 1 || height < 1 || row < 0 | column < 0 || borderWeight < 0) { throw new Exception("Отрицательные параметры недопустимы!"); } Write(row, column, text); if (width > 1 || height > 1) { MergeCells(column, column + width - 1, row, row + height - 1); } Borders(row, column, width, height, borderWeight, borderStyle); if (color != null) { FillColor(row, column, color.Value, width, height); } }
/// <summary> /// Нанесение границ /// </summary> /// <param name="row"></param> /// <param name="column"></param> /// <param name="width"></param> /// <param name="height"></param> /// <param name="borderWeight"></param> /// <param name="borderStyle"></param> public void Borders(int row, int column, int width = 1, int height = 1, int borderWeight = 4, Microsoft.Office.Interop.Excel.XlLineStyle borderStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous) { if (width < 1 || height < 1 || row < 0 | column < 0 || borderWeight < 0) { throw new Exception("Отрицательные параметры недопустимы!"); } if (borderWeight > 0) { string startingLiteral = GetCellName(column, row + 1); string endLiteral = GetCellName(column + width - 1, row + height); for (int i = 7; i < 11; i++) { workSheet.get_Range(startingLiteral, endLiteral).Borders[(XlBordersIndex)i].LineStyle = borderStyle; workSheet.get_Range(startingLiteral, endLiteral).Borders[(XlBordersIndex)i].Weight = borderWeight; } } }