in reply to How to merge/join two multidimensional(2D) arrays

Well, you could do this:

$worksheet1->write_col('A3', [@arr, @arr1]);

since merging two arrays is as easy as putting them next to each other in list context (thanks to Perl's list-flattening). Alternatively, simply push the second array to the first, without taking a reference:

push @arr, @arr1; $worksheet1->write_col('A3', \@arr);

According to The Perl Cookbook (Recipe 4.9), the latter is more efficient. (Good book, BTW, that. I recommend it!)