G'day flexvault,

"I searched on this, but all I found were examples of limited size."

I went straight to the documentation (Excel::Writer::XLSX) and found the set_row() method which has:

The most common use for this method is to change the height of a row:

$worksheet->set_row( 0, 20 );    # Row 1 height set to 20
[download]

From your description and code, it appears you have:

$worksheet->set_row( 0, 5020 );    # Row 1 height set to 5,020
[download]