Use vars in Array for COM?

[4rxsid]

Hi all,

I'm extracting data from a MySQL db, and populating the info into a MS Excel spreadsheet.

Everything is working just fine, with the exception of trying to put the rows returned from the db into an Array (there are more than 5 rows returned...just simplified here) and then spinning through that array and populating different cells with that variabls in the array. Can I store $varibles in an Array() as opposed to 'strings' ?

...//other data and strings inserted into other Cells above here just fine, then:

$typeData = Array ($var1,
		   $something2,
		   $anothername3,
		   $word4,
		   $input5);

$xRow=5;$yRow=6; //Starting cell.

for ($y=0;$y<=4;$y++) {
    $cell = $sheets->Cells($yRow,$xRow);
    $cell->activate;
    $cell->value = $typeData[$y]; //**I THINK this is where it's crashing....
    unset($cell);
    if ($xRow == 8) {
	$xRow = 5;
	$yRow ++;
    } elseif ($xRow == 6 ) {
	//$xRow = ($xRow +2);
	$xRow = 8;
    } else {
	$xRow++;
    }
}

Any ideas?

Thanks!

[4rxsid]

I'm using something similar in code above this with:

$wArray[] is populated during the spin through each record returned in a query.

//Now spin through each in the array 
for ($wCnt=1;$wCnt<=14;$wCnt++) { 
    $cell = $sheets->Cells($xRow,$yRow);    //Select the cell 
    $cell->activate;                      //Activate the cell 
    $cell->value = $wArray[$wCnt];          //print value to cell 
    unset($cell);                

    //unset the cell var to create anew. 
    if ($yRow == 18) { 
        $yRow++; 
    } else { 
        $yRow --; 
        $xRow ++; 
    } 
} 

the code above works excellent. but the original code posted doesnt. I think because the $typeData array has $vars in it...whereas the $wArray array has strings of data from a query result.

I can also do individual lines/cells just fine:

$cell = $sheets->Cells(5,2) ;  

$cell->activate;                  

$cell->value = $var1;        

unset($cell); 

referencing the variable directly works...but if i put all the variables in an array...there are over 20 different variables, then try to reference them in the for loop...it hangs the program.

I could do the above over 20 plus times...I just wanted to clean it up a bit with far less code by using the array and for loop.

[4rxsid]

from above....

anyone know why this works

$typeData = Array ('var1_Data', 
           'something2_Data', 
           'anothername3_Data', 
           'word4_Data', 
           'input5_Data');

but this does not?

$typeData = Array ($var1, 
           $something2, 
           $anothername3, 
           $word4, 
           $input5);

why can't i reference $variables contents that are stored in an Array?