Hi guys,
Using v7.1.2.2 of Aspose, trying to get a simple PivotTable to display some conditional formatting.
I specifically need to display a DataBar, any Databar, however when i try to save the file, I get an error. I have duplicated the exception in the code below.
Workbook workbook = new Workbook();
//Create data source Table1
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Cells[0, 0].Value = “Header1”;
worksheet.Cells[0, 1].Value = “Header2”;
worksheet.Cells[0, 2].Value = “Header3”;
for (int i = 1; i < 21; i++)
{
int value = i - 1;
worksheet.Cells[i, 0].Value = “Value1-” + (value < 10 ? “a” : “b”);
worksheet.Cells[i, 1].Value = “Value2-” + value;
worksheet.Cells[i, 2].Value = value;
}
worksheet.ListObjects.Add(0, 0, 20, 2, true);
//Create PivotTable
workbook.Worksheets.Add(“PivotSheet”);
worksheet = workbook.Worksheets[1];
int index = worksheet.PivotTables.Add("=Sheet1!A1:C21", “A1”, “PT”);
PivotTable pivotTable = worksheet.PivotTables[index];
pivotTable.AddFieldToArea(PivotFieldType.Row, “Header1”);
pivotTable.AddFieldToArea(PivotFieldType.Row, “Header2”);
pivotTable.AddFieldToArea(PivotFieldType.Data, “Header3”);
var fc = pivotTable.PivotFormatConditions[pivotTable.PivotFormatConditions.Add()];
fc.ScopeType = PivotConditionFormatScopeType.field;
FormatConditionCollection fcs = fc.FormatConditions;
CellArea area = new CellArea
{
StartRow = 1,
EndRow = 1,
StartColumn = 2,
EndColumn = 2
};
FormatCondition condition = fcs[fcs.Add(area, FormatConditionType.DataBar, OperatorType.Equal, “”, “”)[0]];
condition.Type = FormatConditionType.DataBar;
condition.DataBar.MinCfvo.Type = FormatConditionValueType.Number;
condition.DataBar.MinCfvo.Value = 0;
condition.DataBar.MaxCfvo.Type = FormatConditionValueType.Number;
condition.DataBar.MaxCfvo.Value = 1;
condition.DataBar.Color = Color.Green;
condition.DataBar.ShowValue = true;
workbook.Save(“TestPivot.xlsx”);
A little help please?