Coming back to this 10 months later and having a better understanding about PS. This module still blows my mind how amazing it is and I'm actually following a long with what you're saying! Thanks Doug and Mike!
Colleague of mine told me about this 2 days ago since I've been fighting with Export CSV and nasty tricks to put the Data in the Excel. It really a cool stuff. It should save me lot of time.
Hey Doug, truly awesome module! is it possible to utilize the Design features for Pivot Tables, i.e. 'Do Not Show Subtotals', 'Show In Tabular Form' & 'Repeat All Item Labels'? i tried ' -NoTotalsInPivot & -PivotDataToColumn' to no avail. i need the objects in '-PivotRows' to swap to columns like they do when using 'Show in Tabular Form'. Any help is greatly appreciated, thanks!
Doug was just a speaker for the night, and he wont likely see this message. I would suggest reaching out to him on social media. He also runs the New York PowerShell User's Group, try joining one of his meetings.
Is this module essentially making the application com object easier to use? Or is it using something other than the Excel namespace under the hood? I have started writing my own functions to manipulate Excel files, but I have been using the com object. It has gotten to the point where I am thinking about creating my own class to reuse these functions and I am wondering if I am about to reinvent the wheel.
Do you also have Projects width Exsemples where you can read the Formats or Propertys of an allready Exsisting Excelsheet? Second can you make an Api that let you use System.Linq concepts for Powershell and Excel if you want to use Linq::Zip for Grouping Array or Cell Properties?
Thank you for the detailed demo. Now clients are asking for PowerBI-like live reports more than static Excel reports that need to be continually updated. Can one interact with a Excel Power Pivot data model using PowerShell? Is there a way to generate live reports using PowerShell?
Does anyone know if it's possible to add calculated fields to pivot tables using importexcel? i've got everything else working but I just need to add a calculated field to the pivot table as the last hurdle and i'm struggling
Sorry for the delay, but I don’t think you can change the print settings with ImportExecel since I believe print uses its on library separate from excel. You should reach out to Doug Finke.
Not sure I understand the question. Default Parameters are set automatically, you can change them if the default doesn’t work for you. In the example you mentioned I think it is talking about the default for ErrorAction. You can use Get-Variable to see all of the default variables and any variables created during your current session. The Error Action Variable is called ErrorActionPreference and defaults to “Continue”.
I face also Problems if i for Exsample have a Blank PS Objrect and i want for each [Psobject].propertie.value in a [Psobject[]] Array the Range [Worksheet]Cell Begin 'A1 to Ending like 'N310' and i want to generate for each Notepropertie in my InputObject the Coresponding Address of the Excelrange. So that i can keep the Properties of an old Sheet like Cell Formating and override width $dt = OpenExcelpackage "/path/to/Excelfile" -Workbook "sheetName" and override just the Individal Values in the Ranges i maped. Since the Blank ImportExcel dont allow me to Import the Metainformation of the OpenOfficeXML Data for Excel. And im not deep in Openxml sax...😮 Can you work on an Idea for ImportExcel V8 or V9?
@@RTPSUG Can you give me the Link to his Jira Repo... So that i can communicate there my Prefferences or Ideas to solve some Opsticals or Extend Funcionalities?...
I don’t believe there is any security audit on it. Modules don’t generally have security audits and there shouldn’t be a need for one. Powershell is a high level programming language and any issues would likely be in PowerShell or the .Net framework not the module itself. We do have some other security related videos I suggest you check them out.
@@RTPSUG I dont agree on that one. If your looking on the "xy" vurnabilty for ssh in linux. In general OpenSource project can have hidden functions, in this case for example maybe my Excel Sheet will be uploaded somewere. This plugin is big engough to cause real damage if there are not enough security lookups from the community. I looked into this module and gladly there are no hidden lookups, but in gernal you should adress this kind of issues when you present a new plugin.
@@HansiFlick-u1s I am not stating there is no concern, but modules are not compiled code anyone can easily look at the modules they pull from the gallery and review the code. One of our other videos with IamJacoby he shows how malicious code can be store in the description of a module on the gallery, but this is only for payload delivery.
I do not have an answer for you, but you could try joining the PowerShell Discord aka.ms/psdiscord and or PowerShell Slack at aka.ms/psslack and ask for help.
