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?
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
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?
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”.
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.
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.
@@user-jw7dm8hz9u 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.
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!
Every time I use PowerShell, it impress me more.
I feel very privileged to have found the Doug videos.
Thanks for all these wonderful examples. I enjoyed all of them a lot.
Glad you like them! Please let us know what else you would like to see.
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.
Glad to hear that you liked it, hope this helped.
The $trace demo was great! Thanks!
Glad it was helpful!
This is really useful. Yes , I admit I been exporting to CSV and manipulating then saving to XLSX. Like the workbook and sorting in months...etc
glad you found it useful
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?
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
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?
Probably with Microsoft.Graph
Glad it was helpful!
You mentioned around 45:14 of the video that you default parameters in your powershell profile.
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”.
Is there a way to modify print settings of a xlsx file, for example page orientation?
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.
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?
I would recommend reaching out to Doug Finke through social media, or providing feedback on the import excel GitHub project.
@@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?...
@@marvinojoye3741 github.com/dfinke
Has this module any security issues?
Did someone have checked that?
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.
@@user-jw7dm8hz9u 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.
Any1 knows how i can turn column with numbers like 8,5E+12 to display as actual TEXT with the green arrow in top left corner of the cell ?
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.