How to loop through a 2D array and remove BLANK columns?

[minttea]

Hello everyone!

I am new to this forum so please let me know whether I am breaking any rules.

I have done quite a bit of searching for an answer, but I really can't find what I'm looking for. I've mainly searched within these forums.

I'm unable to supply my exact code as this is from work, but it's been on my mind all night so I would like to just try and find a solution. 

 

Basically, I am creating a script that gets information from an Excel spreadsheet about purchases, and then I am required to turn that information into an array to fill out some documents. 

 I create an array from an Excel spreadsheet.

$anArray = $oExcel.Activesheet.UsedRange.Value 

 

In some instances, an excel spreadsheet could have blank rows. 

I believe I need to do a  nested for loop to look for the blank values and delete them from the array.

 

Does anyone have any ideas for me? Thank you so much

 

 

[water]

Welcome to AutoIt and the forum!

As you use the array to fill out some documents you could simply ignore blank lines/columns while processing the array.

[Subz]

Something like:

#include <Array.au3>
Local $a2DArray[5][4] = [[0,1,2,3],[4,5,6,7],["",8,9,10],[11,12,13,14],["",15,16,17]]
_ArrayDisplay($a2DArray, "Before")
For $i = UBound($a2DArray) - 1 To 0 Step - 1
    If $a2DArray[$i][0] == "" Then _ArrayDelete($a2DArray, $i)
Next
_ArrayDisplay($a2DArray, "After")