Comments (4)
dfinke
commented on June 26, 2024
What does -PivotFilter do now for you?
from importexcel.
CraigChamberlain
commented on June 26, 2024
It provides the option to filter once Im in the file. I would like to
preset the filter to a specific value.
…On Tue, 14 Nov 2023, 18:18 Doug Finke, ***@***.***> wrote:
What does -PivotFilter do now for you?
—
Reply to this email directly, view it on GitHub
<#1538 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ALRDEQ3WH7HZNXFNA3KMGWTYEOYWZAVCNFSM6AAAAAA7JB7MO6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMJQHA3TCMJYHA>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
from importexcel.
dfinke
commented on June 26, 2024
Yes, the Pivote Table Filter does not have the capability to be preset when the file is created
from importexcel.
CraigChamberlain
commented on June 26, 2024
I can't see a property for this in the XML either. Do you know if it can be done to an existing pivot table? I couldn't find any likely properties in PageFields . There is a property, Items, that is only populated once the file has been opened and saved.
#testPivotFilter.ps1
$excel = Open-ExcelPackage $xlFile
$excel.Sheet1PivotTable.PivotTables[0].PageFields[0]
from importexcel.
Related Issues (20)
- Problems creating multiple charts using ImportExcel PowerShell module, in the same tab with different sources HOT 3
- Is there a way to format a table column using the column name ? HOT 1
- Error saving after using Add-Worksheet with this specific file HOT 3
- Brackets not supported in filepath when using Import-Excel cmdlet HOT 3
- Dates sorted incorrectly in PivotTable when using GroupDateColumn
- Refactor Question - Improving ImportExcel module import time HOT 7
- Microsoft Excell ERROR: "found a problem with some content" HOT 7
- Assistance needed to update excel spreadsheet
- Formula in NoteProperty exported using Export-Excel is broken with #REF! HOT 1
- Pipeline input accepted without a process block
- NumberFormat Dates HOT 4
- "Header" parameter HOT 1
- Import-Excel reads null values with PowerShell 7.4.0 HOT 5
- import-excel cannot read excel formatted xml HOT 1
- Issue with empty values in generated Excel. HOT 1
- Issue with user-defined number format HOT 5
- Export-Excel's -CellStyleSB switch doesn't seem to parse dimensions.address correctly for use with Set-CellStyle HOT 2
- Can't get 'Close-ExcelPackage' to work properly HOT 5
- Exporting hashtable to new (empty) file doesn't transfer as expected HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from importexcel.