Powershell $SecondSheet = $M圜ol | Select-Object Host, PNic, Speed, MAC, DeviceID, 'IP Address', N = 'Mngmt IP' E = I've pulled info from the network and used the following code to generate one of my worksheets in my Excel report:

I'm having trouble finding meaningful documentation on cell and column formatting and I was hoping that, if there's anyone familiar with both ImportExcel, the module, and/or Excel in general, someone could help me with a niggling problem I'm having with one of my columns. Specifically, I have a report that I've done having to do with Networking Topography, specifically as it relates to our VMWare infrastructure. Now that that's out of the way, for those who ARE familiar with the module, I'm trying to get into the nitty-gritty of formatting. Weekly Module Spotlight: ImportExcel (Powershell Magazine) Now, for those not familiar with the module, I think you guys will really enjoy it. Module that, as it says on the tin, exports all the information I gather into an actual Excel sheet instead of a CSV.

Thank you for your understanding.Good morning my fellow POSH explorers! I have a little bit of an esoteric question today: In my new position I've been doing a lot of development on using Powershell to create reports for my team. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. If you have further question during developing/using the VBA code, please post your question to the MSDN forum for Visual Basic for Applications Microsoft does not guarantee the accuracy of this information. Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. ' Examine output of these in the Immediate windowĬall it like this (where A5 contains the required typeName) =GetData(A5, 'typeID') GetData = xmlResp.getElementsByTagName(sItem).Item(0).Text One way would be to use the MSXML2 library, something like this: Function GetData(sName As String, sItem As String, Optional sURL = '') As Variant If you want to find the similar feature ( Importxml function) in Excel 2010, please try the Mr.

Excel import xml with preset columns