Powershell. Find the number of columns in an array.

Posted on 2009-12-27
Last Modified: 2012-05-08
Powershell v1.
I'm writing a script that puts the contents of an array into an Excel workbook. The scripts needs to know how many columns and how many rows are in the array. The count property gives me the number of rows. How do I find out the number of columns in an aray?

Consider the following snippet:

If you type "$array.length", you get response "2" because there are 2 rows in the array. But suppose you want to know how many columns are in the array. You can see that there are are 5 columns. How do you programmatically get that number?
Question by:HondoExpat
    LVL 19

    Accepted Solution


    Try this

    The reason is that you have an array that has two nested arrays...

    Open in new window


    Author Comment

    That works perfectly. Sometimes I wish PS was a little more intuitive.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    This article shows how a content item can be identified directly or through translation of a navigation type. It then shows how this information can be used to create a menu for further navigation.
    This is a PowerShell web interface I use to manage some task as a network administrator. Clicking an action button on the left frame will display a form in the middle frame to input some data in textboxes, process this data in PowerShell and display…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now