Esempio n. 1
0
        /**
         * Creates cacheSource and workSheetSource for pivot table and Sets the source reference as well assets the location of the pivot table
         * @param source Source for data for pivot table
         * @param position Position for pivot table in sheet
         * @param sourceSheet Sheet where the source will be collected from
         */

        protected internal void CreateSourceReferences(AreaReference source, CellReference position, ISheet sourceSheet)
        {
            //Get cell one to the right and one down from position, add both to AreaReference and Set pivot table location.
            AreaReference destination = new AreaReference(position, new CellReference(position.Row + 1, position.Col + 1));

            CT_Location location;

            if (pivotTableDefinition.location == null)
            {
                location = pivotTableDefinition.AddNewLocation();
                location.firstDataCol   = (/*setter*/ 1);
                location.firstDataRow   = (/*setter*/ 1);
                location.firstHeaderRow = (/*setter*/ 1);
            }
            else
            {
                location = pivotTableDefinition.location;
            }
            location.@ref = (/*setter*/ destination.FormatAsString());
            pivotTableDefinition.location = (/*setter*/ location);

            //Set source for the pivot table
            CT_PivotCacheDefinition cacheDef    = GetPivotCacheDefinition().GetCTPivotCacheDefInition();
            CT_CacheSource          cacheSource = cacheDef.AddNewCacheSource();

            cacheSource.type = (/*setter*/ ST_SourceType.worksheet);
            CT_WorksheetSource worksheetSource = cacheSource.AddNewWorksheetSource();

            worksheetSource.sheet = (/*setter*/ sourceSheet.SheetName);
            SetDataSheet(sourceSheet);

            String[] firstCell = source.FirstCell.CellRefParts;
            String[] lastCell  = source.LastCell.CellRefParts;
            worksheetSource.@ref = (/*setter*/ firstCell[2] + firstCell[1] + ':' + lastCell[2] + lastCell[1]);
        }
Esempio n. 2
0
        /**
         * Creates cacheSource and workSheetSource for pivot table and sets the source reference as well assets the location of the pivot table
         * @param sourceRef Source for data for pivot table - mutually exclusive with sourceName
         * @param sourceName Source for data for pivot table - mutually exclusive with sourceRef
         * @param position Position for pivot table in sheet
         * @param sourceSheet Sheet where the source will be collected from
         */
        protected internal void CreateSourceReferences(CellReference position, ISheet sourceSheet, IPivotTableReferenceConfigurator refConfig)
        {
            //Get cell one to the right and one down from position, add both to AreaReference and Set pivot table location.
            AreaReference destination = new AreaReference(position, new CellReference(position.Row + 1, position.Col + 1));

            CT_Location location;

            if (pivotTableDefinition.location == null)
            {
                location = pivotTableDefinition.AddNewLocation();
                location.firstDataCol   = (/*setter*/ 1);
                location.firstDataRow   = (/*setter*/ 1);
                location.firstHeaderRow = (/*setter*/ 1);
            }
            else
            {
                location = pivotTableDefinition.location;
            }
            location.@ref = (/*setter*/ destination.FormatAsString());
            pivotTableDefinition.location = (/*setter*/ location);

            //Set source for the pivot table
            CT_PivotCacheDefinition cacheDef    = GetPivotCacheDefinition().GetCTPivotCacheDefinition();
            CT_CacheSource          cacheSource = cacheDef.AddNewCacheSource();

            cacheSource.type = (/*setter*/ ST_SourceType.worksheet);
            CT_WorksheetSource worksheetSource = cacheSource.AddNewWorksheetSource();

            worksheetSource.sheet = (/*setter*/ sourceSheet.SheetName);
            SetDataSheet(sourceSheet);

            refConfig.ConfigureReference(worksheetSource);
            if (worksheetSource.name == null && worksheetSource.@ref == null)
            {
                throw new ArgumentException("Pivot table source area reference or name must be specified.");
            }
        }