I need help with merging cells in MS Excel. I am using this to do it.
$excel->Workbooks(1)->Worksheets('Sheet1')->Range($a,$b)->{MergeCells}
+ = 1;
whare $a = Cells(1,2);
and $b = Cells(1,4);
now this works fine, but every time a merge occurs in excel a pop up box appears warning me that my data will be merged. I don't want this box appearing every time there is a merge. Because, I might be merging cells in a loop and might be doing it 20-30 times in my perl script. I don't want 30 warning boxes appearing giving me that warning. Does anyone know how to fix this?
please respond to cpareto@force10networks.com
Thanks, Chuck
Edit by tye: Add formatting tags