my $formula = $worksheet->store_formula('=A1 * 3 + 50'); for my $row (0..999) { $worksheet->repeat_formula($row, 1, $formula, $format, 'A1', 'A'.($row +1)); }