It depends on a number of variables. For instance, the amount of unique strings that are written and the amount of memory available on the system. The best solution is to test it.
For a solution like this see the row_wrap.pl program in the examples directory of the Spreadsheet::WriteExcel distro.
If you have a followup question please post it to the Spreadsheet::WriteExcel Google group:John.