public XSSFPivotTable()
: base()
{
pivotTableDefinition = new CT_PivotTableDefinition();
pivotCache = new XSSFPivotCache();
pivotCacheDefinition = new XSSFPivotCacheDefinition();
pivotCacheRecords = new XSSFPivotCacheRecords();
}
public void TestAddOneColumnLabelToPivotTableDoesNotCreateColField()
{
int columnIndex = 0;
pivotTable.AddColumnLabel(DataConsolidateFunction.SUM, columnIndex);
CT_PivotTableDefinition defintion = pivotTable.GetCTPivotTableDefinition();
Assert.AreEqual(defintion.colFields, null);
}
public void TestAddTwoColumnLabelsToPivotTable()
{
int columnOne = 0;
int columnTwo = 1;
pivotTable.AddColumnLabel(DataConsolidateFunction.SUM, columnOne);
pivotTable.AddColumnLabel(DataConsolidateFunction.SUM, columnTwo);
CT_PivotTableDefinition defintion = pivotTable.GetCTPivotTableDefinition();
Assert.AreEqual(defintion.colFields.field[0].x, -2);
}
public void TestColumnLabelCreatesDataField()
{
int columnIndex = 0;
pivotTable.AddColumnLabel(DataConsolidateFunction.SUM, columnIndex);
CT_PivotTableDefinition defintion = pivotTable.GetCTPivotTableDefinition();
Assert.AreEqual(defintion.dataFields.dataField[(0)].fld, columnIndex);
Assert.AreEqual(defintion.dataFields.dataField[(0)].subtotal,
(ST_DataConsolidateFunction)(DataConsolidateFunction.SUM.Value));
}
public void TestColumnLabelSetCustomName()
{
int columnIndex = 0;
String customName = "Custom Name";
pivotTable.AddColumnLabel(DataConsolidateFunction.SUM, columnIndex, customName);
CT_PivotTableDefinition defintion = pivotTable.GetCTPivotTableDefinition();
Assert.AreEqual(defintion.dataFields.dataField[(0)].fld, columnIndex);
Assert.AreEqual(defintion.dataFields.dataField[(0)].name, customName);
}
public void TestAddThreeSametColumnLabelsToPivotTable()
{
int columnOne = 0;
int columnTwo = 1;
int columnThree = 2;
pivotTable.AddColumnLabel(DataConsolidateFunction.SUM, columnOne);
pivotTable.AddColumnLabel(DataConsolidateFunction.SUM, columnTwo);
pivotTable.AddColumnLabel(DataConsolidateFunction.SUM, columnThree);
CT_PivotTableDefinition defintion = pivotTable.GetCTPivotTableDefinition();
Assert.AreEqual(defintion.dataFields.dataField.Count, 3);
}
public void ReadFrom(Stream is1)
{
try
{
//XmlOptions options = new XmlOptions(DEFAULT_XML_OPTIONS);
//Removing root element
//options.LoadReplaceDocumentElement=(/*setter*/null);
XDocument xmlDoc = ConvertStreamToXml(is1);
pivotTableDefinition = CT_PivotTableDefinition.Parse(xmlDoc.Document.Root, NamespaceManager);
}
catch (XmlException e)
{
throw new IOException(e.Message);
}
}
private void readPivotTable(XSSFSheet sheet)
{
List <XSSFPivotTable> tables = sheet.GetPivotTables();
if (tables.Count > 0)
{
try
{
CT_PivotTableDefinition cT_PivotTableDefinition = tables[0].GetCTPivotTableDefinition();
parseLocation(cT_PivotTableDefinition.location.@ref);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.logException(ex);
}
}
}
public void TestAddRowLabelToPivotTable()
{
int columnIndex = 0;
Assert.AreEqual(0, pivotTable.GetRowLabelColumns().Count);
pivotTable.AddRowLabel(columnIndex);
CT_PivotTableDefinition defintion = pivotTable.GetCTPivotTableDefinition();
Assert.AreEqual(defintion.rowFields.GetFieldArray(0).x, columnIndex);
Assert.AreEqual(defintion.rowFields.count, 1);
Assert.AreEqual(1, pivotTable.GetRowLabelColumns().Count);
columnIndex = 1;
pivotTable.AddRowLabel(columnIndex);
Assert.AreEqual(2, pivotTable.GetRowLabelColumns().Count);
Assert.AreEqual(0, (int)pivotTable.GetRowLabelColumns()[(0)]);
Assert.AreEqual(1, (int)pivotTable.GetRowLabelColumns()[(1)]);
}
public void SetCTPivotTableDefinition(CT_PivotTableDefinition pivotTableDefinition)
{
this.pivotTableDefinition = pivotTableDefinition;
}
