由前pression EPPlus格式条件 [英] Format condition by expression EPPlus

问题描述

我使用EPPlus使用条件格式创建的Excel。我使用C＃code ++做的条件格式，但它不工作。

请查看我的下面code和让我知道我错了：

  ExcelPackage PCK =新ExcelPackage（）;
变种WS = pck.Workbook.Worksheets.Add（样品1）;
VAR _formatRangeAddress =新ExcelAddress（H16：K31，H33：K44，H46：K57，H59：K69，H71：K73）;
串_statement == AND（COUNTA（H16：H16）2，COUNTA（H16：K16）大于0）;
VAR _cond4 = ws.ConditionalFormatting.AddEx pression（_formatRangeAddress）;
_cond4.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
_cond4.Style.Fill.BackgroundColor.Color = Color.Green;
_cond4.Formula = _statement;
pck.SaveAs（Response.OutputStream）;
Response.ContentType =应用程序/ vnd.openxmlformats-officedocument.s preadsheetml.sheet
Response.AddHeader（内容处置，附件;文件名= Sample1.xlsx）;
 

解决方案

请试试这个：

  ExcelPackage PCK =新ExcelPackage（）;
变种WS = pck.Workbook.Worksheets.Add（样品1）;
VAR _formatRangeAddress =新ExcelAddress（H16：K31，H33：K44，H46：K57，H59：K69，H71：K73）;
串_statement =AND（COUNTA（H16：H16）2，COUNTA（H16：K16）大于0）;
VAR _cond4 = ws.ConditionalFormatting.AddEx pression（_formatRangeAddress）;
_cond4.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
_cond4.Style.Fill.BackgroundColor.Color = Color.Green;
_cond4.Formula = _statement;
pck.SaveAs（Response.OutputStream）;
Response.ContentType =应用程序/ vnd.openxmlformats-officedocument.s preadsheetml.sheet
Response.AddHeader（内容处置，附件;文件名= Sample1.xlsx）;
 

I am creating excel using EPPlus with conditional formatting. I am using C# code to do conditional formatting but its not working.

Please check my below code and let me know where I am wrong:

ExcelPackage pck = new ExcelPackage();
var ws = pck.Workbook.Worksheets.Add("Sample1");
var _formatRangeAddress = new ExcelAddress("H16:K31,H33:K44,H46:K57,H59:K69,H71:K73");
string _statement = "=AND(COUNTA(H16:H16)<2,COUNTA(H16:K16)>0)";
var _cond4 = ws.ConditionalFormatting.AddExpression(_formatRangeAddress);
_cond4.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
_cond4.Style.Fill.BackgroundColor.Color = Color.Green;
_cond4.Formula = _statement;
pck.SaveAs(Response.OutputStream);
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;  filename=Sample1.xlsx");

解决方案

Please try this:

ExcelPackage pck = new ExcelPackage();
var ws = pck.Workbook.Worksheets.Add("Sample1");
var _formatRangeAddress = new ExcelAddress("H16:K31,H33:K44,H46:K57,H59:K69,H71:K73");
string _statement = "AND(COUNTA(H16:H16)<2,COUNTA(H16:K16)>0)";
var _cond4 = ws.ConditionalFormatting.AddExpression(_formatRangeAddress);
_cond4.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
_cond4.Style.Fill.BackgroundColor.Color = Color.Green;
_cond4.Formula = _statement;
pck.SaveAs(Response.OutputStream);
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;  filename=Sample1.xlsx");

这篇关于由前pression EPPlus格式条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！