C# (CSharp) OfficeOpenXml.Table.PivotTable ExcelPivotTableField.SetDateGroup Examples

SetDateGroup() private method

private SetDateGroup ( eDateGroupBy GroupBy, DateTime StartDate, DateTime EndDate, int interval ) : ExcelPivotTableFieldDateGroup
GroupBy	eDateGroupBy
StartDate	DateTime
EndDate	DateTime
interval	int
return	ExcelPivotTableFieldDateGroup

Example #1

        private void AddCacheField(ExcelPivotTableField field, DateTime startDate, DateTime endDate, int interval)
        {
            //Add Cache definition field.
            var cacheTopNode   = _table.CacheDefinition.CacheDefinitionXml.SelectSingleNode("//d:cacheFields", _table.NameSpaceManager);
            var cacheFieldNode = _table.CacheDefinition.CacheDefinitionXml.CreateElement("cacheField", ExcelPackage.schemaMain);

            cacheFieldNode.SetAttribute("name", field.DateGrouping.ToString());
            cacheFieldNode.SetAttribute("databaseField", "0");
            cacheTopNode.AppendChild(cacheFieldNode);
            field.SetCacheFieldNode(cacheFieldNode);

            field.SetDateGroup(field.DateGrouping, startDate, endDate, interval);
        }

Example #2

File: ExcelPivotTableField.cs Project: huoxudong125/EPPlus

        private void AddCacheField(ExcelPivotTableField field, DateTime startDate, DateTime endDate)
        {
            //Add Cache definition field.
            var cacheTopNode = _table.CacheDefinition.CacheDefinitionXml.SelectSingleNode("//d:cacheFields", _table.NameSpaceManager);
            var cacheFieldNode = _table.CacheDefinition.CacheDefinitionXml.CreateElement("cacheField", ExcelPackage.schemaMain);

            cacheFieldNode.SetAttribute("name", field.DateGrouping.ToString());
            cacheFieldNode.SetAttribute("databaseField", "0");
            cacheTopNode.AppendChild(cacheFieldNode);
            field.SetCacheFieldNode(cacheFieldNode);

            field.SetDateGroup(field.DateGrouping, startDate, endDate);
        }