23.02.2021, 21:42 | #1 |
Сенбернар
|
EPPlus + DAX2009: то ли оно глючит, то ли я...
Рисуем рамочки.
Это из EPPlus Tutoroal-а: X++: using (ExcelRange range = worksheet.Cells["A1:H1"]) { range.Style.Font.Bold = true; range.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; range.Style.VerticalAlignment = ExcelVerticalAlignment.Center; range.Style.Fill.PatternType = ExcelFillStyle.Solid; range.Style.Fill.BackgroundColor.SetColor(Color.White); range.Style.Border.Top.Style = ExcelBorderStyle.Thin; range.Style.Border.Top.Color.SetColor(Color.Red); range.Style.Border.Left.Style = ExcelBorderStyle.Thin; range.Style.Border.Left.Color.SetColor(Color.Green); range.Style.Border.Right.Style = ExcelBorderStyle.Thin; range.Style.Border.Right.Color.SetColor(Color.Green); range.Style.Border.Bottom.Style = ExcelBorderStyle.Thin; range.Style.Border.Bottom.Color.SetColor(Color.Green); } X++: public void setBorder(MSOfficeBookMark_RU _bookmark) { #define.MEDIUM (11) OfficeOpenXml.ExcelNamedRange excelNamedRange = this.findRange(_bookmark); OfficeOpenXml.Style.ExcelStyle excelRangeStyle; OfficeOpenXml.Style.Border excelBorder; OfficeOpenXml.Style.ExcelBorderItem top; ; new InteropPermission(InteropKind::ClrInterop).assert(); excelRangeStyle = excelNamedRange.get_Style(); excelBorder = excelRangeStyle.get_Border(); top = excelBorder.get_Top(); top.set_Style(#MEDIUM); CodeAccessPermission::revertAssert(); } И что я делаю не так, интересно?
__________________
Best Regards, Roman |
|