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; }