<div>
That works perfectly. Sometimes I wish PS was a little more intuitive.
</div>


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

<div>
<div class="content wysiwyg-content">
Powershell v1.<br />
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?<br />
<br />
Consider the following snippet:<br />
$array=@(&quot;Row1,Col1&quot;,&quot;Row1<wbr />,Col2&quot;,&quot;Ro<wbr />w1,Col3&quot;,&quot;<wbr />Row1,Col4&quot;<wbr />,&quot;Row1,Col<wbr />5&quot;),(&quot;Row2<wbr />,Col1&quot;,&quot;Ro<wbr />w2,Col2&quot;,&quot;<wbr />Row2,Col3&quot;<wbr />,&quot;Row2,Col<wbr />4&quot;,&quot;Row2,C<wbr />ol5&quot;)<br />
<br />
If you type &quot;$array.length&quot;, you get response &quot;2&quot; 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?
</div>
</div>


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:
$array=@("Row1,Col1","Row1,Col2","Row1,Col3","Row1,Col4","Row1,Col5"),("Row2,Col1","Row2,Col2","Row2,Col3","Row2,Col4","Row2,Col5")

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?

Powershell. Find the number of columns in an array.

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.