Jump to content
Sign in to follow this  

display array - why does ths happen?

Recommended Posts


the array at the end seems to be displaying blank but I see the values in the array...

#include <Date.au3>
#include <Excel.au3>
#include <File.au3>
#include <Array.au3>
Opt("OnExitFunc", "OnAutoItExit")
If UBound(ProcessList(@ScriptName)) > 2 Then
    MsgBox(64, "* NOTE *", "Program already running", 5)

$DATE = StringReplace(_DateAdd('d', -1, _NowCalcDate()), "/", "")
$ExcelDoc1 = "C:\Data\AUT.xls"
$oExcel1 = _ExcelBookOpen($ExcelDoc1, 0, True)
_ExcelSheetActivate($oExcel1, "AUT")
$NowCell1 = _ExcelReadArray($oExcel1, 1, 1, 255, 1, 1)
;var2=start down 1, var3=start right 2, var4=end at 255 (MAX = 256 which is the Max # of cells excel can have if starting from cell 1)
;var5=default is 0 which is right (1=down), var6=sets index base of 0 or 1 of the array created
;starting index base at 1 makes $array[0] have the # of array objects
$N1 = 1
$Error1 = False

For $C1 = 0 To $NowCell1[0];Search all cells in the row
    If $NowCell1[$N1] = "0" Then;For some reason excell puts 6 0's at the end of the date
#Region --- CodeWizard generated code Start ---
;MsgBox features: Title=Yes, Text=Yes, Buttons=OK, Icon=Info
        MsgBox(64,"data found in cell",$NowCell1[$N1])
#EndRegion --- CodeWizard generated code End ---Box 
        $N1 = $N1 + 1
$aArray = _ExcelReadSheetToArray($oExcel1);Using Default Parameters
MsgBox(0, "_ArrayToString() getting $avArray items 1 to 7", _ArrayToString($aArray, @TAB, 1, 7))

Share this post

Link to post
Share on other sites

The first is because you called _ArrayToString() with two-dimensional array, read the help file.

The second is probably because you got confused between $avArray and $aArray and mixed-up those two between comments or strings and real code. ;]

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.