Is it possible to to do mass operations on groups of table cells,
for example apply cellValueType(), or cellStyle() to a span, row or
column?
I have a large spreadsheet (30K rows, 30 columns) where I'm loading rows from a mySQL query.
It seems slow to treat each cell, especially when I know the data
types of the columns.
my $X=1; my $Y=0;
for my $row ( @$result_rows ) { # database query results
for my $fld(@$row) {
my $Cell = $doc->getTableCell($sheet, $X, $Y);
$doc->cellValueType($Cell, $type);
$doc->cellValue($Cell, "$fld");
set_cell_style($Cell);
}
$Y++;
}
$X++; $Y=0;
}
Any suggestions for improvements would be appreciated.
