예제 #1
0
 private static void GenerateConditionalFormatting(XlWorksheet ws, UInt32 dxfId, DataTable t)
 {
     ws.AppendConditionalFormatting(new String[] { "K3:K" + (t.Rows.Count + 2).ToString() }, dxfId, "Value(E3)<>K3");
     ws.AppendConditionalFormatting(new String[] { "J3:J" + (t.Rows.Count + 2).ToString() }, dxfId, "D3<>J3");
 }