in reply to Error when reach end excel sheet limit

The limit is 65,535 but I would stop well short of that.

Remember that Excel also provides for “external data ranges” that can come from almost any source and can be of almost any size...   You can prepare information for this use with your Perl script, in a wide variety of formats, and the resulting presentation is very nice.