Hi all,
I’m making a script that runs a query in MySQL and then places the values in an Excel document with DCOM. Now, the code does run and everything is placed in the excel document in the correct way.
There’s just one problem: I have to place a call to excel for every cell, so if my query yields 2000 rows with 17 columns each, that takes close to an eternity. My question is, is it possible to insert an entire array into an excel row with one command? (or even better yet, the entire arrayset at once)
This is what I use to import now:
[code=php]$rownum=1;
while($row = mysql_fetch_row($export))
{
$rownum++;
$colnum=0;
foreach($row as $value)
{
$colnum++;
$cell = $sheets->Cells($rownum,$colnum);
$cell->activate;
$cell->value = “$value”;
}
}